Red Gate forums :: View topic - Scheduled Backup Never Starts
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

Scheduled Backup Never Starts

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
psherwood



Joined: 16 Feb 2012
Posts: 4

PostPosted: Fri Feb 24, 2012 10:01 pm    Post subject: Scheduled Backup Never Starts Reply with quote

I've setup a scheduled backup that should kick off at 11pm every evening. It has been 4 days and it still won't automatically kick off.

Right above the Job it says "Your SQL Server Agent doesn't appear to be running". I've clicked the Start SQL Server Agent link and it never goes away. I've also tried going into services and starting the agent. It comes back and says it quit because no one was using it. Is the agent my problem?

How do I get this scheduled job to start when it's supposed to?
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Mon Feb 27, 2012 11:00 am    Post subject: Reply with quote

Thanks for your post. SQL Backup relies on the SQL Server Agent to be running in order for a scheduled task to be run.

Unless you're using Task Scheduler and calling an executable from the command line, any sort of scheduled job running in SQL Server relies on the SQL Server Agent to be running.

I'd therefore take a closer look at the SQL Server Agent and see why that's stopping, as to the best of my knowledge it shouldn't just stop through inactivity.

Kind regards,

Peter
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
psherwood



Joined: 16 Feb 2012
Posts: 4

PostPosted: Tue Feb 28, 2012 3:50 pm    Post subject: Reply with quote

I went into Services and looked at the properties of Server Agent. It was set to run under the Network Service user. I then looked at SQL Server and it was set to run under Local System Account. I then changed Server Agent to run under Local System Account and started it. It stayed running.

My scheduled backup completed successfully last night! Thanks for your help.

-Phil
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group