Поделиться через

Recovering SQL Server Data

  • Статья

Назначение: System Center Data Protection Manager 2010

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

How to Copy a SQL Database to Tape

How to Recover a SQL Database and Allow Additional Log Backups