Use the Specify Alternate Recovery Location page of the Recovery Wizard to specify where you want to locate the database files that you are recovering.

When recovering a mirrored SQL Server database, you must always recover to an alternate location. If you want to recover to the original location, you must still recover to an alternate location, and then provide the path to one of the partners of the mirrored database.

This page contains the elements described in the following table.

Elements

Name Description

Instance of SQL Server

Browse to select an instance of SQL Server for the database that you are recovering.

Note
For mirrored SQL Server databases you can recover to the “latest” point-in-time.

Recovered database name

Specify the name of the recovered database.

Database file locations

Specify the database file locations for the database you are recovering.

To proceed with the recovery, click Next.

See Also