Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Database Restore Testing Documentation Expand / Collapse
Posted Friday, March 7, 2014 1:10 PM


Group: General Forum Members
Last Login: Thursday, August 13, 2015 12:33 PM
Points: 468, Visits: 976
I test my database backups about once a month, on average.

My question is, I am in need of a template or document where I can record which database backup was tested, where it was restored to, when was it restored, by whom(won't always be me) and which dbcc commands where run on the restored database. And any other information I may need to add at a later date.

I know I could probably create something in Excel but I need to be able to report to higher ups and provide documentation to them.

Any Guidance is appreciated.


Post #1548875
Posted Tuesday, May 6, 2014 9:00 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, November 11, 2015 7:38 AM
Points: 576, Visits: 1,700
I use RedGate for that, which sends an email.

But in your case, I guess you can copy the DBCC results and save on notepad. Then archive locally on a share. To me, that would be enough evidence that you performed a complete DBCC chek and found zero logical or physical errors.
Post #1568008
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse