How to restore SQL databases which were backed up with Backup Exec.

記事: 100016098
最終公開日: 2024-07-29
評価: 1 2
製品: Backup Exec

Problem

How to restore SQL databases which were backed up with Backup Exec.

Solution

 
 
  
To submit Microsoft SQL Server restore jobs:
 
1. Verify the storage location (tape, disk, deduplication store, etc) has the backup set needed for restore.

2. From the Backup and Restore window select the server from the list then select Restore from the top bar.

3. Select SQL Server Databases in the Restore Wizard

Image

 

4. Select the SQl Instance the database resides on, then select the database to restore.

Image

 

5. Select the database time or transacation log to restore the database to.

Image

 

6. Select if the database will be restored to the original location or redirected. 

Note: Redirecting restores of SQL can be performed with "Redirect the data to a different SQL server instance and/or database name".

You can redirect the following:
A database backup to a different server, database, or instance.
A different file and folder path.
Differential and log backups to wherever the associated database is restored.
A database from a 32-bit or 64-bit platform to any other platform.

 

Image

 

7. Select how to the database is restored

Image

 

8. Select the consistency check option to use for the restore

Image

 

9. Select the recovery state for the databases

Image

 

10. Select any additional options needed for the restore

Image

 

11. Enter a name for the job and set the schedule for when the job will run

Image

 

12. Review the Retore Summary, click Finish to start the restore.

Image 

Note: If restoring the Master database, it must be restored in it's own job. No other databases can be selected.
 
 
 
 
 
 
 

Was this content helpful?