Microsoft SQL Server 2008
Administration Best Practices

How to apply RESTORE checks on database backup files?

 

Execute the following script to demonstrate the restore command variations for checking the content of a database backup file:

USE master;

 

restore headeronly from disk='F:\data\backup\inventorydb.bak'

 

restore filelistonly from disk='F:\data\backup\inventorydb.bak'

 

restore labelonly from disk='F:\data\backup\inventorydb.bak'

 

restore verifyonly from disk='F:\data\backup\inventorydb.bak'

 

 

The Best SQL Server 2008 Training in the World
 
 
SQLUSA.com Home Page