Maint. not running - SQL Server Forums

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

Maint. not running

Author

Topic

preacher
Starting Member

4 Posts

Posted - 2007-12-07 : 08:47:35

Just two days ago, I noticed none of the scheduled maintenance jobs (backups) are running. I can run them manually successfully, but they are not running according to the maintenance schedule. There are no errors thrown.

Just prior to this happening, our anti-virus detected and deleted what it described as a virus [trojan]. The file was named sqlmaint.rll. I have done extensive searching and have not found anything definitive for this file. Obviously, this has something to do with maintenance not running, but how can I resolve this?

Thanks in advance for any help.
Deacon

Windows Server 2003 Enterprise
SQL Server 2000

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2007-12-07 : 08:54:50

where did you search? got this from the top hit on google...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=945054&SiteID=1

you should be able to just copy it back into the file location from a different installation? (assuming you have one of course)

Em

preacher
Starting Member

4 Posts

Posted - 2007-12-07 : 10:52:51

Thank you for the reply. I restored the sqlmaint.rll file from an archive and reset the schedule time to test with no success. There are no entries in the logs to indicate the backup was even attempted. I welcome any further suggestions.

Thanks again,
Deacon

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-07 : 23:34:25

Nothing in job history?

preacher
Starting Member

4 Posts

Posted - 2007-12-08 : 07:37:49

Nothing at all. It is like there is not even a job scheduled.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-08 : 17:34:37

You can run the job manually? Any message in sql agent error log?

preacher
Starting Member

4 Posts

Posted - 2007-12-08 : 21:26:18

I had a chance to restart the server today and it seems as if everything is working properly again. I guess something just had not been reset yet.

For the record, there were no entries in the job history at all since the 4th (which was the last successful run). Very strange... I am still too new to SQL to know what is worthy or not of panic.

Thank you again for your quick response and help. I have bookmarked this forum and will do some reading here every chance I get.

Deacon

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources