Redirecting the restore of a Microsoft Office SharePoint Server 2007 database to an alternate SQL instance

You can restore SharePoint databases to an alternate SQL instance. For example, you can attach a database to a new Web application.

To redirect the restore of a Microsoft Office SharePoint Server 2007 database to an alternate SQL instance

  1. On the navigation bar, click the arrow next to Restore.

  2. Click New Restore Job.

  3. Navigate to and select the SharePoint database that you want to restore.

  4. On the Properties pane, under Destination, click Microsoft SharePoint Redirection.

  5. Check Redirect Microsoft SharePoint sets.

  6. Click Restore Sharepoint databases to an alternate SQL instance.

  7. In the Restore to SQL server\instance field, enter the SQL server and instance to which you want to redirect the SharePoint database.

  8. In the Restore to database field, enter the name of the database to which you want to redirect the SharePoint database.

  9. Select Replace existing database to overwrite an existing database with the same name.

    If you do not select this field and a database with the same name exists on the SQL instance, you receive an error.

  10. Use the default logon account as indicated, or click Change to select a different one.

  11. On the Properties pane, select other job properties that might be appropriate for your environment.

  12. Start the restore job.

More Information

About using the SharePoint Agent with SharePoint Server 2007 and Windows SharePoint Services 3.0

Redirecting the restore of a Microsoft Office SharePoint Server 2007 database to an alternate SQL instance