RESTORE HEADERONLY. This statement provides details regarding the backup database and returns all the backup's header information.
RESTORE LABELONLY. This statement returns a result set containing information about the backup media on which the backup is stored. The output of this statement includes only partial header information.
RESTORE VERIFYONLY. This statement verifies whether the backup data is complete.
RESTORE FILELISTONLY. This statement returns a list of data files and log files in the backup.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.