I have a backup scheduled (daily full and transactional every hour) on one of the servers and the the backup plan job is successful everyday. No errors at all. But there is not Full backup at all on the folder for the last four days. Does this thing happen to anyone of you? If it is a known issue please tell me how you solve it.
asked Feb 25, 2010 at 05:02 PM in Default
I have more questions than answers.
First, just to check the obvious, are you certain you are pointing it to that folder and not having it save somewhere else? I have done that one myself.
Does it work as expected with a file actually produced if you run it manually instead of through the job?
Are you using SQL Server 2005's native backup capabilities or using a 3rd party solution such as Red Gate SQL backup?
answered Feb 25, 2010 at 07:00 PM
Has the job been successful prior to the last four days?
If so, what has changed?
If not, can you add logging to your maintenance plan and run the plan again? After running the plan again, you would be able to read the log and find any errors that were encountered.
answered Feb 25, 2010 at 05:26 PM
Try the standard report in Management Studio that shows backup and restore events. (Right click on the database in Object Explorer.) It's not very obvious but if you click on the + in the Device Type column it will show you the file name the backup was written to. There's also a section that shows backup errors. Does that give you any clues?
answered Feb 26, 2010 at 05:29 AM
Are you checking the history/status of the SQL Agent job, or the Maintenance Plan?
Right-click on the maintenance plan in Object Explorer and choose View History.
answered Feb 26, 2010 at 06:29 AM