What is restore command in SQL?

Question

Rajanikant Hawaldar · Answer

Following are the restore commands RESTORE HEADERONLY - gives you a list of all the backups in a file RESTORE LABELONLY - gives you the backup media information RESTORE FILELISTONLY - gives you a list of all of the files that were backed up for a give backup RESTORE DATABASE - allows you to restore a full, differential, file or filegroup backup RESTORE LOG - allows you to restore a transaction log backup RESTORE VERIFYONLY - verifies that the backup is readable by the RESTORE process

Amit Mohanty · Answer

https://www.mssqltips.com/sqlservertutorial/85/sql-server-restore-commands/

Brahma Prakash Shukla · Answer

There are several RESTORE commands and options that can be used to restore and view the contents of your backup files. In this next section we will look at the following commands that can be used: RESTORE HEADERONLY - gives you a list of all the backups in a file RESTORE LABELONLY - gives you the backup media information RESTORE FILELISTONLY - gives you a list of all of the files that were backed up for a give backup RESTORE DATABASE - allows you to restore a full, differential, file or filegroup backup RESTORE LOG - allows you to restore a transaction log backup RESTORE VERIFYONLY - verifies that the backup is readable by the RESTORE process