March 29, 2010 at 4:25 am
HI Experts,
Is there anyway to find what exactly happened to backup file taken as per the maintenance plan.
Our last week full back taken as per maintenance plan is mising from server.
TIA
March 29, 2010 at 5:47 am
Please check log of maintenance plan or the Job.
It may happen that SQL Server agent was not running and Backup did not happen. Or becuase of some issues like space not available backup did not happen. You can figure it out from the logs.
March 29, 2010 at 5:53 am
if u're sure maint. plan took backup successfully, then someone might have deleted the backup files..
March 29, 2010 at 6:02 am
Sometimes backup files are moved to some other place.
For example backups are taken to local disk to reduce time and avoid network issue.
Later the backup files are move to tape or some other network share.
Check whether this is the case.
March 29, 2010 at 7:06 am
check with your server admins to see if they have auditing for file deletions turned on, otherwise you are down to checking with those people who have the access to delete the file.
Have you checked in msdb..backupmediafamily that the backup went to where you expect?
---------------------------------------------------------------------
March 30, 2010 at 6:48 pm
If your backup job has a "delete old backup files" as a last step then make sure it is deleting only the old files.
Thanks
Jay
http://www.sqldbops.com
March 30, 2010 at 6:51 pm
If the file is not there then somebody or some process has deleted if the backup completed successfully.
I would certainly verify that auditing is on for that fileshare and check with the sysadmins.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply