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.
| Author |
Topic |
|
TonyTheDBA
Posting Yak Master
121 Posts |
 Posted - 2007-11-14 : 09:56:25
|
| OK I seem to recall someone posting a link/Code that has a stored procedure that checks to see if the Archive attribute has been removed from a Backup file (Thereby indicating that it has been written to tape). This is something that I need to implement, as it appears that our network guys don't backup all the disks on a server or inform me when a tape backup has failed. . . . I've just been embarrased one time to many, so I wnat a routine that will check the backup files and check they have been copied to tape. If Not I'll email all and sundry to find out why.Its not as if we only hold 1 days worth of backup on the server the minimum is three days and often its 7.Our SQL Backup routine is FULL twice a day , TLOGs every 15 minutes, and DIFFS every 3 Hours. (Shamelessly modified from Tara's excellent Backup scripts). As this is on a SAN we have a CA (Continuous Access) service that duplicates the disk writes to our other remote located SAN in case of Site Failure SO In thoery if we loose the SAN at site A, we have the lastest Backups at Site B (And can bring up the Hidden LUNS and present them to the cluster).The latest issue has come to light when we were asked to investigate what changes a user had made to the DB 20 Days Ago . . . . No there were no tape backups, so even though I had a tool to investigate the TLOGS, I couldn't.So if anyone can post a link to the script it would be appreciated, I have tried searging but the complexities of google defeat me :(-- RegardsTony The DBA |
|
|
|
|
|
Check That A Disk Backup Has been written to tape