Right-click the database, point to Tasks, and then click Restore. Click the type of restore operation you want (Database, Files and Filegroups, or Transaction Log). This opens the corresponding restore dialog box. On the General page, in the Restore source section, click From device.
How do I restore a SQL database from a query?
- Connect to your SQL Server and right-click on the “Databases” directory and choose “Restore Database”
- Click the button beneath the “Source” section next to “Device”
- In the “Select backup device” press “Add”
- Select the backup file or files (.bak) you are going to restore, then click “OK”
Which command is used to restore the database in SQL?
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.
