Red Gate forums :: View topic - SQL Agent Not Running - Failed 1060
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

SQL Agent Not Running - Failed 1060

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



Joined: 11 May 2012
Posts: 2
Location: United States

PostPosted: Fri May 11, 2012 11:15 pm    Post subject: SQL Agent Not Running - Failed 1060 Reply with quote

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.
Back to top
View user's profile Send private message
RajK



Joined: 02 Feb 2012
Posts: 58

PostPosted: Mon May 14, 2012 9:19 am    Post subject: Reply with quote

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/content/knowledgebase/SQL_Backup/KB200708000144

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.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 922
Location: Red Gate Software

PostPosted: Mon May 14, 2012 9:27 am    Post subject: Reply with quote

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:

@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
Back to top
View user's profile Send private message Send e-mail
jcterv



Joined: 11 May 2012
Posts: 2
Location: United States

PostPosted: Tue May 15, 2012 7:19 pm    Post subject: Reply with quote

Awesome.. This worked right away.. THANK YOU!
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