Here is a list of commands to verify the backup files in sql server.
1. Execute below command for finding the backup set is complete and that all volumes are readable.
Restore verifyonly from disk='C:\MSSQL\shiva.bak'
Restore headeronly from disk='C:\MSSQL\shiva.bak'
Restore filelistonly from disk='C:\MSSQL\shiva.bak'
1. Execute below command for finding the backup set is complete and that all volumes are readable.
Restore verifyonly from disk='C:\MSSQL\shiva.bak'
2. Execute below command for finding the backup header information for all backup sets on a particular backup device.
Restore headeronly from disk='C:\MSSQL\shiva.bak'
3. Execute below command for finding the database and log files contained in the backup set.
Restore filelistonly from disk='C:\MSSQL\shiva.bak'
No comments:
Post a Comment