Posted on 2014-11-042018-02-09 by sqldba — Leave a comment

Using SQL Server Restore to see Backup Media Set Info

restore headeronly
from disk = ‘V:backupsmydb.bak’
go

restore filelistonlyfrom disk = ‘V:backupsmydb.bak’
go

restore verifyonly
from disk = ‘V:backupsmydb.bak’
go

Leave a Reply

You must be logged in to post a comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.