Debugging and testing a windows service

I have 2 questions: 1. I am creating a windows service that will export a database on one server and imports onto another server every day once a day at 3am GMT. I have installed my service and followed this: http://ift.tt/2gdLQvc. However I have tried while in the code for the service and it wont allow me to attach to the process and have also tried doing it in a blank visual studio page (BOTH AS THE ADMINISTRATOR) and cannot and the problem is is when i run my service it stops for some reason so if possible I need some ideas on how i can test and debug to ensure the service Is doing what i wanted.

2. I am using my event viewer to tell me some of the errors but this seems quite costly with time however i have received one error which is:

Service cannot be started. System.ArgumentException: Source property was not set before writing to the event log. at System.Diagnostics.EventLogInternal.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData) at System.Diagnostics.EventLog.WriteEntry(String message) at DBBackUpService.BackUpService.OnStart(String[] args) in C:\Dev\Projects\DBBackUpService\DBBackUpService\BackUpService.cs:line 27 at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)