Recovering SQL Server Data
Applies To: System Center Data Protection Manager 2007
When you recover SQL Server data, you can choose from the following options:
Recover the database to its original location
Recover the database with a new name to its original location or to a different instance of SQL Server
Recover the database to a different instance of SQL Server
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