Check Databse Backup file if it's Valid on multiple databses

Question

Check Databse Backup file if it's Valid on multiple databses

FTdenali

SSCertifiable

Points: 5362
More actions
April 28, 2012 at 1:10 pm

#255086

Comments posted to this topic are about the item Check Databse Backup file if it's Valid on multiple databses

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Paul Randal One Orange Chip Points: 29544 More actions · Answer 1

The script should be titled 'check if backup file exists' as all doing a restore verifyonly does is make sure the file is there and a cursory look at the backup header. Would be much more useful to see whether the backup was taken using WITH CHECKSUM and also use WITH CHECKSUM on the verify.

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 2

akljfhnlaflkj

SSC Guru

Points: 76202

May 10, 2016 at 1:56 pm

#1877972

Thanks for the script.