I can't seem to locate any error messages in the Log...Any ideas how i can get this working again?Check the SQL Server Agent Jobs to see if it is enabled. If it is not there, go to the DB Maintenance Job and reschedule it and the save it again. You should then see it in the SQL Server Agent Jobs.
Wednesday, March 7, 2012
Database Maintenance Plan
I created a Database Maintence Plan to backup one of my database @. 7pm but doesn't seem to do anything at all. It was working for the past months untill just this morning i noticed that no latest *.BAK files were created since 18-Aug-2006. I have other databases which do backup OK except for this particular database. I can manually back it up but cannot automatically backup from the Database Maintenance Plan.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment