Posted on 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

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