Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Wednesday, January 27, 2016 10:20 PM
Points: 468, Visits: 984
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
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, September 22, 2016 11:12 AM
Points: 645, Visits: 1,929
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