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
Author
Message
Posted Friday, March 7, 2014 1:10 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 10:48 PM
Points: 446, Visits: 855
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.

Gary



Post #1548875
Posted Tuesday, May 6, 2014 9:00 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 8:01 AM
Points: 416, Visits: 1,345
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