You can back up 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:

• The user is a member of the Local Administrators group on the document library server.
• The user is a member of the SPS_WPG group or Administrators group on the content index servers.
• The user is a member of the db_owner database role on the configuration database and site databases.

Back Up Data

1. 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 Backup tab.
3. In the Backup location and name box, do the following:
   1. Type or browse to the location where you want to store the backup files.
   2. After the folder name, type the file name that will be the prefix for each backup file.
4. In the tree view, expand Available components by clicking the plus sign.
5. Click the components that you want to back up.
6. In the Backup comment box, type a comment.
7. Optionally, select the Overwrite existing files check box.
8. Click Backup.
9. On the successful completion message box, click OK.

Back Up Data Using the Command Prompt

Though the SharePoint Portal Server 2003 Backup and Restore program can be run from the Start menu, you can also back up your data on a regular schedule using the command prompt.

1. On the taskbar, click Start, and then click Command Prompt.
2. Change directories to the \Bin directory of your SharePoint Portal Server installation.
3. Use the program in one of three ways:
   • Type "spsbackup" to run the backup and restore program normally without any command line options.
   • Run the backup and restore program with the following command line parameters:

     spsbackup { /all | /teamdbs | /ssodb | /doclib | { /portal portalUrl [ /service { sitedbs | index } ] } } /file backupfilepath\fileprefix [/overwrite]

     You must choose one of the following for the type of data to back up:

     /all Backs up all data from all portal sites and team databases.

     /teamdbs Backs up all team databases.

     /ssodb Backs up all data from single sign-on databases.

     /doclib Backs up all data from document libraries.

     /portal portalUrl Backs up the portal site with the specified portalUrl.

     You may also add the following optional parameter to the /portal portalUrl parameter:

     /service Backs up a specific service, either sitedbs or index.

     The following parameters are added next:

     /file backupfilepath\fileprefix This required parameter specifies the files that contain the backup image. backupfilepath is the directory to the location of backup files, and fileprefix is the first few characters in the file names of the backup files.

     /overwrite This optional parameter overwrites any previous backup image.

   • Run the backup and restore program with the following command line parameters:

     spsbackup /DMLocalPath LocalPath

     LocalPath is the local path of the document library server where you want to temporarily hold the backup image.