Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Backup failed?

Author  Topic 

megmar
Starting Member

10 Posts

Posted - 2009-02-17 : 16:51:31
I went to check my backup and noticed that it did not run over the weekend. I checked my error log and it states that SQL server agent is not running...has the red circle on it. Should I manually restart that? I don't know where else to begin looking.

I did also see that "the local host server is not running" and the SQL server agent terminated (normally).....Can anyone please tell me what I should maybe do or look for?

Sorry I am new to this. I am using a sql2005 server

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-17 : 16:52:38
Yes you should manually restart the service.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

megmar
Starting Member

10 Posts

Posted - 2009-02-17 : 19:01:55
I will restart the SQL Server Agent. Is there anything else that I should be looking for?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-17 : 19:08:47
I'd check Event Viewer for why it stopped.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

megmar
Starting Member

10 Posts

Posted - 2009-02-18 : 09:08:00
I checked event viewer and since I am so new to this I don't know. The warnings I get on the sql server are licensing replication couldn't be started because couldn't reach the license logging on the domain.

The SQL server error log states: SQLVDI; Loc=cvds:cleanup. Errorcode 288 attempt to release mutex not owned by caller.

I also have login failed for user "xx"
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2009-02-19 : 13:35:23
If this is a critical app, might be wroth looking at some sort of monitoring that allows restarts

Jack Vamvas
--------------------
http://www.ITjobfeed.com
Go to Top of Page
   

- Advertisement -