Link Menu Expand (external link) Document Search Copy Copied

Microsoft SQL Server Restore

Restore is integral part of SQL Server protection, Veeam provides following options to restore SQL server:

  1. VM or physical server restore
    • Instant VM or server restore
    • ‘Bare Metal Restore’ for physical servers
    • Full VM restore
  2. 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

  1. File level restore to local Veeam server
  2. Copy the mdf and ldf file to target SQL server
  3. Attach the database to target SQL server

SQL Table Level Restore

  1. Restore SQL database to staging SQL server (standalone SQL node)
  2. Open SQL Server Management Studio; connect to both staging and target SQL servers
  3. Right-click on the database name, then select “Tasks” > “Export data…” from the object explorer
  4. The SQL Server Import/Export wizard opens; click on “Next”
  5. Provide authentication and select the staging server; click “Next”
  6. Specify the target SQL server; click on “Next”.
  7. Select the tables to restore
  8. Complete the restore

References


Back to top

Copyright © 2023 Solutions Architects, Veeam Software.