SQL Agent Not Running - Failed 1060

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

SQL Agent Not Running - Failed 1060

Postby jcterv » Fri May 11, 2012 11: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.
jcterv
 
Posts: 2
Joined: Fri May 11, 2012 11:07 pm
Location: United States

Postby RajK » Mon May 14, 2012 9: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.
RajK
 
Posts: 58
Joined: Thu Feb 02, 2012 8:21 am

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

Hi

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
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

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

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


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests