Tuesday, November 4, 2014

Using SQL Server Restore to see Backup Media Set Info 



restore headeronly
from disk = 'V:\backups\mydb.bak'
go

restore filelistonlyfrom disk = 'V:\backups\mydb.bak'
go

restore verifyonly
from disk = 'V:\backups\mydb.bak'
go
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)