SQL Restore Operations
You can restore a SQL database from any of the following backups:
- The most recent backup
- A backup from a specified date and time
You can also perform a point-in-time restore for a database.
You can perform any of the following restore operations:
- In-place restore
When you restore a database in place, you restore it to the same path on the same client from which the database was backed up.
The restore operation will overwrite the source data on the database.
- Out-of-place restore
When you restore a database out of place, you can restore it to any one of the following destinations:
- A different client from which the database was backed up
- A different instance from which the database was backed up
- A different database name
- Restore to Disk
You can restore SQL Server data directly to a disk from the Admin Console.
This restored data on the disk can be used later to perform database restore using SQL Management studio or any other third party tools.
Last modified: 12/4/2018 9:56:50 PM