Microsoft SQL Server Restore
Restore is integral part of SQL Server protection, Veeam provides following options to restore SQL server:
- VM or physical server restore
- Instant VM or server restore
- ‘Bare Metal Restore’ for physical servers
- Full VM restore
- SQL Application Item Level Restore
Veeam uses specially designed Veeam Explorer for SQL to perform application item level restore. To optimize the restore of SQL database install Veeam Management console on SQL server locally to perform the restores.
SQL Failover Cluster Database Restore (applicable to agent based cluster backup only)
SQL Database Restore
Please follow the below steps to restore SQL database
- File level restore to local Veeam server
- Copy the mdf and ldf file to target SQL server
- Attach the database to target SQL server
SQL Table Level Restore
- Restore SQL database to staging SQL server (standalone SQL node)
- Open SQL Server Management Studio; connect to both staging and target SQL servers
- Right-click on the database name, then select “Tasks” > “Export data…” from the object explorer
- The SQL Server Import/Export wizard opens; click on “Next”
- Provide authentication and select the staging server; click “Next”
- Specify the target SQL server; click on “Next”.
- Select the tables to restore
- Complete the restore