question

chauhan_5041 avatar image
chauhan_5041 asked

checking backup files (third party tools)

any third party tools for backup files checking.
backup
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
[Red Gate SQL Backup Pro][1] works with the basics of RESTORE VERIFYONLY as outlined in @Thomas Rushton answer. But, it goes one step farther. It has an entire infrastructure built around reminding you that you need to test restores of your databases. It also has a wizard built in that will help you set up a scheduled restore of your database to whatever server you want, renaming the database, moving the files as needed. It's pretty handy, check it out. You could also look at [SQL Virtual Restore][2] which does all the checks of restoring a database, but only actually mounts the backup files. This means it doesn't really do the full restore, saving you a ton of disk space. This is also from [Red Gate][3]. Disclosure: I work for Red Gate Software. [1]: http://www.red-gate.com/products/dba/sql-backup/ [2]: http://www.red-gate.com/products/dba/sql-virtual-restore/ [3]: http://www.red-gate.com/
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image
ThomasRushton answered
Define "checking". Assuming your backups are created using the native SQL Server `BACKUP` command, then you have a variety of options: * [RESTORE HEADERONLY][1] * [RESTORE VERIFYONLY][2] * [RESTORE FILELISTONLY][3] These provide an assortment of methods to quickly look into your database backups. HOWEVER, there is no substitute for taking your backup files and doing a full restore from those files. Obviously, you're going to need to do that into a separate environment... [1]: http://msdn.microsoft.com/en-gb/library/ms178536.aspx [2]: http://msdn.microsoft.com/en-us/library/ms188902.aspx [3]: http://msdn.microsoft.com/en-us/library/ms173778.aspx
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

And to ensure that VERIFYONLY does a complete check, you need to run CHECKSUM when performing the backups.
0 Likes 0 ·
ramesh 1 avatar image
ramesh 1 answered
redgate is the best option
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.