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)
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