Sqlserver-dba.com

Subscribe

SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
SQL Server – Backup file information needed for RESTORE SQL database

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'

 Related Posts

Differential backup cannot be restored . BACKUP with COPY_ONLY

SQL Server - RESTORE VERIFYONLY

SQL Server faster restores with instant file initialisation


Author: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Enjoy this post? Enter your email address for updates on new posts:

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer