SQL Agent Not Running - Failed 1060

Forum for users of Redgate's SQL Backup tool

SQL Agent Not Running - Failed 1060

Postby jcterv » Fri May 11, 2012 10:15 pm

I have a new box running SQL 2005 Express on Windows 2003 R2.

My SQL server is running as Network Service. I had to manually run SQBServerSetup.exe which installs and starts. But when I'm looking on the job's tab it says the SQL Agent is not running. My backups don't appear to be working.

Should I create a local user for SQL Agent to run as? Then how do I make sure the local user can pass an auth to Network Service.
Posts: 2
Joined: Fri May 11, 2012 10:07 pm
Location: United States

Postby RajK » Mon May 14, 2012 8:19 am

I am the support engineer that is investigating the issue you have raised.

Since you are using the express edition of SQL Server there will be an issue with the SQL Server Agent service.

The issue you are mentioned is documented in the following url:

http://www.red-gate.com/supportcenter/c ... 0708000144

If possible please use the suggestions in this url and let me know if this fixes the issue.

Thanks for your patience and feedback in this matter.
Posts: 58
Joined: Thu Feb 02, 2012 7:21 am

Postby eddie davis » Mon May 14, 2012 8:27 am


Thank you for your post into the SQL Backup 6 forum.

For what ever reason, Microsoft removed the SQL Agent from SQL Server Express Edition, hence why the SQL Backup GUI is indicating that the SQL Agent is not running.

Unfortunately SQL Backup does not detect that you have installed the SQL Backup Server components on a SQL Instance using the Express Edition. So the application allows you to create or run the Scheduled Backup Job wizard but in reality no job is created.

To workaround this problem, you need to use the SQL Backup Command Line and create batch files with the necessary parameters and keywords. Once you have created a batch file, use the Windows scheduler to to start the batch file .

An example batch file is as follows:
Code: Select all
@echo off
"C:\\Program Files\\Red Gate\\SQL Backup 6\\SQLEXP\\SQLBackupC.exe" -E -I SQLEXP -SQL "BACKUP DATABASE [AdventureWorks] TO DISK = 'C:\\Program Files\\Microsoft SQL Server\\MSSQL.3\\MSSQL\\Backup\\<AUTO>.sqb' WITH DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, THREADCOUNT = 2"

Further information can be found HERE under the Learning SQL Backup section ->Scripting SQL Backup section.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
Posts: 1150
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Postby jcterv » Tue May 15, 2012 6:19 pm

Awesome.. This worked right away.. THANK YOU!
Posts: 2
Joined: Fri May 11, 2012 10:07 pm
Location: United States

Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest