Restoring Data

You can restore all server farm components or individual components.

Important  You must install the Microsoft SQL Server 2000 client tools on the front-end Web server from which you run the backup and restore process in a server farm.

To back up or restore an image successfully, the following accounts must have access to the directory containing the backup files:

• The service account for SQL Server must have write access to the directory.
• The search service and database access accounts for search must have write access to the directory.
• The current user must have write access to the directory.

The current user must also have the following rights:

• Membership in the local administrators group on the document management server
• Administrator rights on the database server, either as a member of the local administrators group or as a member of the SQL Server 2000 System Administrators server role

Note  Some information is not restored, and must be configured after restore has completed. This includes proxy settings, the configuration database, e-mail settings, and various registry settings described in the documentation.

Alternate access settings are not backed up, but are stored by the configuration database. If you restore to the same deployment and the configuration database is on a different server in that same deployment, these settings will be intact. Otherwise, you will have to reconfigure alternate access settings.

Restore data

1. On the taskbar, click Start, point to All Programs, point to SharePoint Portal Server, and then click SharePoint Portal Server Data Backup and Restore.

   The Microsoft Office SharePoint Portal Server 2003 Backup and Restore dialog box opens.

2. Click the Restore tab.
3. In the Manifest file box, specify the location of the manifest file. You can also click Browse to find the location of the manifest file.

   The manifest file is the XML file that is in the directory that you specified for the backup files when you backed up the server. The file name is the prefix you specified for the backup file names. For example, if the file name you specified as the prefix for the backup file names was Adventure, the name of the manifest file would be Adventure.XML.

4. In the tree view, expand Available components by clicking the plus sign.
5. Click the components that you want to restore.

   Components that are ready to be restored are labelled as Ready in the Restore Item column. If a component is labelled as Parameters Needed, you cannot select the check box for the component. You must click the component, click Edit, and then provide the missing parameters.

   If a component is labelled as Dependent Item, you must first select the check box for the component on which it is dependent. This is typically the SITEDBS component corresponding to the portal site.

6. Click Restore.

   Caution  Restore will overwrite existing data. Ensure that you have verified that each backup image corresponds to the correct component.

7. On the confirmation message box, click OK.
8. On the successful completion message box, click OK.