How to copy a sql database to a network folder – Dell PowerVault DP600 User Manual

Page 72

Advertising
background image

72

How to Copy a SQL Database to a Network Folder

You can only copy a SQL Server database from a recovery point that was created from an

express full backup.

To copy a database to a network folder

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 Copy to a network folder, and then click Next.

If the recovery point that you selected was not created from an express full backup, you

will be presented with new recovery point choices.

8. Specify the destination path to which the database should be copied.

9. On the Specify recovery options page, you can select either or both of the following

options:

Restore security

Specify whether to use the security settings of the data being recovered or the

security settings of the target destination.

Send an e-mail when this recovery completes.

Select this option to specify an e-mail address or addresses to notify upon recovery

completion. If you select this option, you must enter the e-mail address to notify.

Multiple e-mail addresses must be separated by a comma.

10. On the Summary page, review the recovery settings, and then click Recover.

See Also

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 Tape

How to Recover a SQL Database and Allow Additional Log Backups

Advertising