SQL Serevr Interview Question Related to DB Backup

How to check database Backup is valid or not?
The following command will check the backup file and return a message of whether the file is valid or not. If it is not valid, this means the file is not going to be useable for a restore and a new backup should be taken

Restore VERIFYONLY from disk =‘Backup-media’ 
Go

How to get the contents of a SQL Server backup file?
RESTORE HEADERONLY option allows you to see the backup header information for a backup file.

RESTORE HEADERONLY FROM DISK = ‘Backup-media’ 
GO

• Tweet
• Share
• Share
• Share
• Share