Dell PowerVault DP600 User Manual

Page 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 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.