Tuesday, October 2, 2012

Verify Backup Set Commands

Below is the list of command that we can use the verify the backup file.

Information for media set of backup ->  restore labelonly from disk = 'Path' (details about the media set on which backup is taken)

Information to check the backup set is valid  -> restore verify only from disk = 'path' (to check that my backup is valid)

Information to check the details of the files in backup - > restore filelistonly from disk = 'path' (information about database files, size and files detail)

Information to check the details of the backup file -> restore headeronly from disk = 'path'( details of backup,who has taken the backup,backup of which database, collation of database, compressed, backup of which server)

No comments:

Post a Comment