20 September,2012 by Jack Vamvas
Sometimes I’ll receive a SQL Server Backup File , either by a colleague or a third party vendor. The request is to RESTORE onto a lab or dev server . Usually there is no accompanying information , including source server SQL Server version.
Fortunately there are some RESTORE commands which supply you with all the information needed. RESTORE VERIFY ONLY, RESTORE HEADER ONLY, and RESTORE FILELIST ONLY.
Use these commands to make the appropriate decision for how you’ll compose the RESTORE command
--More appropriate for verifying the actual backup process. RESTORE VERIFYONLY FROM DISK = 'H:\test1.bak' -- View all the backup header information RESTORE HEADERONLY FROM DISK = ‘H:\test1.bak' --View list of data and log files in the backup RESTORE FILELISTONLY FROM DISK = 'H:\test1.bak'
It's important to practise & test your RESTORE strategy. Read more on Schrodinger’s backup - A warning for DBAs