I have a client that is running a SQL database on an 2003 SBS.
They have Symantec Backup EXEC 10 backing it up via an agent, but I'd like to create a backup job within SQLserver enterprise manager to do it's own scheduled backup.
When I use the wizard to create the backup job of the database I want to backup I get an popup that says "The sqlserveragent on target server '(local)' is stopped. Make sure it is running durning the scheduled execution of this job"
I looked in the services msc and that agent is set to manual. I tried setting it to automatic but the job didn't run.
Do I need to start the service and leave it running? If so, is there any downside to having it run 24x7