The Importance of Validating Backups

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Paul Randal » The Importance of Validating Backups

55 posts, Page 6 of 6

«««2 3 4 5 6

The Importance of Validating Backups

Rate Topic

Display Mode

Topic Options

Author

Message

Paul Randal

Posted Saturday, September 29, 2012 9:16 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:19 AM
Points: 1,910, Visits: 1,606

You must be corrupting a page that is not allocated - you need to figure out which page you're corrupting and then check it's allocation status using DBCC PAGE.

For the backup, if you corrupt the backup header then restore verifyonly will catch that, with or without checksum.

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

Post #1366197

SQL PG

Posted Thursday, November 08, 2012 2:23 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 7:41 AM
Points: 1, Visits: 56

Newbee ;
Paul this is a very good article but one common trend here is educating the masses that require these backups .
Would it be possible to providfe me with names of vitualisation tools which will aid in validating backs as well as restores.

Post #1382716

Neha05

Posted Tuesday, December 25, 2012 8:37 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, April 15, 2013 11:42 PM
Points: 424, Visits: 55

Nice article.

Post #1400071

Paul Brewer

Posted Tuesday, December 25, 2012 3:24 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 12:38 PM
Points: 55, Visits: 648

I've developed a stored procedure to automate the generation of restore scripts. http://paul.dynalias.com/SQL/_layouts/15/start.aspx#/
The procedure is actually a single SQL query, you can specify a STOPAT point and it works out the FULL, DIFF, LOG files needed and generates the necessary script. It includes a CHECKDB at the end, ignores WITH COPY_ONLY , allows overrides to restore file locations using WITH MOVE and so on. It's better than anything else available free I can find.

Post #1400103

Paul Brewer

Posted Tuesday, December 25, 2012 3:31 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 12:38 PM
Points: 55, Visits: 648

http://paul.dynalias.com/SQL/SiteAssets/Lists/Posts/AllPosts/sp_RestoreScriptGenie.txt

My Christmas present to the world.

Post #1400105

« Prev Topic | Next Topic »

55 posts, Page 6 of 6

«««2 3 4 5 6

Permissions