You can restore SharePoint databases to an alternate SQL instance. For example, you can use SharePoint administrative tools to harvest granular information or attach a database to a new Web application.
To redirect the restore of a Microsoft Office SharePoint Server 2010 database to an alternate SQL instance
-
Navigate to and select the SharePoint database that you want to restore.
-
On the Properties pane, under Destination, click Microsoft SharePoint Redirection.
-
Click Restore Sharepoint databases to an alternate SQL instance.
-
In the Restore to SQL server\instance field, enter the SQL server and instance to which you want to redirect the SharePoint database.
-
In the Restore to database field, enter the name of the database to which you want to redirect the SharePoint database.
-
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.
-
Use the default logon account as indicated, or click Change to select a different one.
-
On the Properties pane, select other job properties that might be appropriate for your environment.
-
To run the job now
Click Run Now.
To schedule the job to run later
Do the following in the order listed:
-
In the Properties pane, under Frequency, click Schedule.
-
Set the scheduling options.
-
Click Submit.
See Scheduling jobs.
-
More Information
About using the SharePoint Agent with SharePoint Server 2010 and Windows SharePoint Foundation 2010