Before you perform these procedures, confirm that you are logged on to the server that is running the SharePoint Central Administration Web site. The procedures in this article assume that you are restoring to the server that produced the backup — that is, you are not migrating to a new or different server. For information about how to migrate by using the Stsadm command-line tool, see
Migrate Project Server 2007 by using the Stsadm command-line tool.
.gif) Important |
|---|
| Membership in the Administrators group on the local computer is the minimum required to complete these procedures. |
Restore a server farm by using the Stsadm command-line tool
-
On the drive where SharePoint Products and Technologies is installed, change to the following directory: %COMMONPROGRAMFILES%\Microsoft shared\Web server extensions\12\Bin.
-
To obtain the backup GUID for the specific backup that you want to restore, type the following command, and then press ENTER:
stsadm -o backuphistory -directory <UNC path>
where UNC path is the path to the shared folder that contains the backup.
-
To restore a server farm, type the following command, and then press ENTER:
stsadm -o restore -directory <UNC path> -backupid <GUID from backuphistory> -restoremethod overwrite
where UNC path is the UNC path to the backup shared folder and GUID from backuphistory is the GUID of for the specific backup package that you want to restore.
-
When you receive a warning that all selected items will be overwritten, type y and then press ENTER.
-
When prompted, type the user name and password for the Web application and content databases.
-
If the recovery completes successfully, the command window displays the following text:
Completed with 0 warnings.
Completed with 0 errors.
Restore completed successfully.
---------------------------------------------------------
Operation completed successfully.
-
If the recovery does not complete successfully, the following message appears:
The restore job failed. For more information, see the error log that is located in the backup directory.
The referenced error log will be the sprestore.log file in the backup shared folder.
Restore a Web application by using the Stsadm command-line tool
-
On the drive where SharePoint Products and Technologies is installed, change to the following directory: %COMMONPROGRAMFILES%\Microsoft shared\Web server extensions\12\Bin.
-
To obtain the backup GUID for the specific backup that you want to restore, type the following command, and then press ENTER:
stsadm -o backuphistory -directory <UNC path>
where UNC path is the path to the shared folder that contains the backup.
-
If you do not already know the name of the Web application you want to restore, type the following command, and then press ENTER:
stsadm –o restore –showtree -directory <UNC path> -backupid <GUID from backuphistory>
where UNC path is the path to the shared folder that contains the backup and where GUID from backuphistory is the GUID of the backup package that you want to restore.
| Note |
|---|
| Items enclosed by square brackets ([ ]) cannot be restored. |
-
To restore a Web application, type the following command and then press ENTER:
stsadm -o restore -directory <UNC path> -backupid <GUID from backuphistory> -item <created path from tree> -restoremethod overwrite
where UNC path is the UNC path to the backup shared folder, GUID from backuphistory is the GUID for the specific backup package that you want to restore, and created path from tree is the full farm path notation as displayed by the -showtree parameter.
-
When you receive a warning that all selected items will be overwritten, type y and then press ENTER.
-
When prompted, type the user name and password for the Web application and content database.
-
If the recovery completes successfully, the command window displays the following text:
Completed with 0 warnings.
Completed with 0 errors.
Restore completed successfully.
---------------------------------------------------------
Operation completed successfully.
-
If the recovery does not complete successfully, the following message appears:
The restore job failed. For more information, see the error log that is located in the backup directory.
The referenced error log will be the sprestore.log file in the backup shared folder.
Restore a database by using the Stsadm command-line tool
-
On the drive where SharePoint Products and Technologies is installed, change to the following directory: %COMMONPROGRAMFILES%\Microsoft shared\Web server extensions\12\Bin.
-
To obtain the backup GUID for the specific backup that you want to restore, type the following command, and then press ENTER:
stsadm -o backuphistory -directory <UNC path>
where UNC path is the path to the shared folder that contains the backup.
-
If you do not already know the name of the database that you want to restore, type the following command, and then press ENTER:
stsadm –o restore –showtree -directory <UNC path> -backupid <GUID from backuphistory>
where UNC path is the path to the shared folder that contains the backup and where GUID from backuphistory is the GUID of the backup package that you want to restore.
| Note |
|---|
| Items enclosed by square brackets ([ ]) cannot be restored. |
-
To restore a database, type the following command, and then press ENTER:
stsadm -o restore -directory <UNC path> -backupid <GUID from backuphistory> -item <database name>
where UNC path is the UNC path to the backup shared folder, GUID from backuphistory is the GUID for the specific backup package that you want to restore, and database name is the full farm path notation for the database as displayed by the -showtree parameter or the unique name of the database that you want to restore.
-
When you receive a warning that all selected items will be overwritten, type y, and then press ENTER.
-
If the recovery completes successfully, the command window displays the following text:
Completed with 0 warnings.
Completed with 0 errors.
Backup completed successfully.
---------------------------------------------------------
Operation completed successfully.
-
If the recovery does not complete successfully, the following message appears:
The restore job failed. For more information, see the error log that is located in the backup directory.
The referenced error log will be the sprestore.log file in the backup shared folder.
Restore a site collection by using the Stsadm command-line tool
-
On the drive where SharePoint Products and Technologies is installed, change to the following directory: %COMMONPROGRAMFILES%\Microsoft shared\Web server extensions\12\Bin.
-
To restore a site collection, type the following command, and then press ENTER:
stsadm -o restore -url <URL name> -directory <UNC path> -restoremethod overwrite
where URL name is the URL of the site collection that you want to restore and UNC path is the UNC path to the backup shared folder.
-
When you receive a warning that all selected items will be overwritten, type y, and then press ENTER.
-
When prompted, type the user name and password for the Web application and content databases.
-
If the recovery completes successfully, the command window displays the following text:
Operation completed successfully.
If the recovery does not complete successfully, the command line provides additional details about the failure. Most commonly, an incorrect URL or file name was given.
For more information about the Restore operation, see Restore: Stsadm operation (Office SharePoint Server).
To restore a site or subsite by using the Stsadm command-line tool
You can use the export operation to save a site or subsite. You can then use the import operation to import the site or subsite to the same or another server at a later time. Although using the import operation imports data, it is not the same as using the restore operation. You cannot restore a workflow, alerts, features, solutions, or Recycle-Bin state by using the import operation. If you want a full-fidelity recovery, use the restore operation to restore the site collection as described in the "Restore a site collection by using the Stsadm command-line tool" procedure earlier in this article.
Restore a site or subsite by using the Stsadm command-line tool
-
On the drive where SharePoint Products and Technologies is installed, change to the following directory: %COMMONPROGRAMFILES%\Microsoft shared\Web server extensions\12\Bin.
-
To import a site or a subsite, type the following command, and then press ENTER:
stsadm -o import -url <URL name> -filename <import file name>
where URL name is the URL of the site or subsite that you want to import and import file name is the UNC path and file name of the file that you want to import — for example, \\backup\share\import.cmp.
-
If the import completes successfully, the command window displays the following text:
Operation completed successfully.
-
If there are errors or warnings, or if the import does not complete successfully, see the import file name.import.log file for the file that you specified in step 2.
For more information about the import operation, see Import: Stsadm operation (Office SharePoint Server).
Restore item-level objects by using the Stsadm command-line tool
You can restore specific Microsoft Office Project Server 2007 items by using the Stsadm command-line tool. These command-line operations do not restore the physical files of a database, but restore specific items from the database. These items are backed up from the Microsoft Office Project Server 2007 Published database to the Office Project Server 2007 Archive database.
|
This operation
|
Restores this item-level object
|
| Projcatgrouprestore | Categories and groups from backup |
| Projcustfieldsrestore | Enterprise custom fields and lookup tables from backup |
| Projeglobalrestore | Global project from backup |
| Projerprestore | Enterprise Resource Pool and Calendar data from the Archive database |
| Projonlinerestore | Project from backup |
| Projsyssettingsrestore | System settings from backup |
| Projviewsrestore | View definitions from backup |
For more information about using the Stsadm command-line tool with Office Project Server 2007, see Operations for the Stsadm command-line tool in Microsoft Office Project Server 2007.