Dell PowerVault DP600 - Manual (Page 69)

69
• Copy the database to a network folder
• Copy the database to tape
When you recover a SQL Server 2000 database to a different instance of SQL Server, the
recovery path on the new server must be the same as the path of the database when it was
protected on the source server. For example, DB1 on D:\sample on server1 can be recovered
only to D:\sample on server2. If you want to recover to a completely new path, then you will only
be able to recover express full backups (typically one copy per day).
When you recover a SQL Server 2005 database to a different instance of SQL Server, you can
recover the database to any chosen path on the new server. You can back up once every 15
minutes and recover to any point in time on the target SQL Server.
In both SQL Server 2000 and SQL Server 2005, you can rename the database and recover to the
original SQL instance.
You cannot recover a database from an instance of SQL Server on a computer running Windows
Server 2008 to an instance of SQL Server on a computer running Windows Server 2003.
You cannot recover a system database to a different instance of SQL Server.
In This Section
How to Recover a SQL Database to Its Original Location
How to Recover and Rename a SQL Database
How to Recover a Database to a Different Instance of SQL Server
How to Copy a SQL Database to a Network Folder
How to Copy a SQL Database to Tape
How to Recover a SQL Database and Allow Additional Log Backups
How to Recover a SQL Database to Its Original Location
To recover a database to its original location
1. In DPM Administrator Console, click Recovery on the navigation bar.
2. Using the browse functionality, select the database to recover.
3. On the calendar, click any date in bold to obtain the recovery points available for that
date. The Recovery time menu lists the time for each available recovery point.
4. On the Recovery time menu, select the recovery point you want to use.
5. In the Actions pane, click Recover.
The Recovery Wizard starts.
6. On the Review recovery selection page, click Next.
7. Select Recover to original SQL Server location, and then click Next.
8. If you selected a recovery point other than Latest, on the Specify Database State page,
select Leave database operational.