What is restore command in SQL?
Loading
What is restore command in SQL?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Brahma Prakash ShuklaPosted Oct 19, 2022, 11:41 AM
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:
Amit MohantyPosted Oct 11, 2022, 10:17 AM
https://www.mssqltips.com/sqlservertutorial/85/sql-server-restore-commands/
Rajanikant HawaldarPosted Oct 11, 2022, 9:21 AM
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