Backing Up Data

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 Backup Operators group on the content index servers.
• The user has permission to backup the SQL Server 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 | { /portalportalUrl [ /service { sitedbs | index } ] } } /filebackupfilepath\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.

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

     You may also add the following optional parameter to the /portalportalUrl parameter:

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

     The following parameters are added next:

     /filebackupfilepath\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.

     /DMLocalPath   LocalPath Backs up all data from all portal sites and databases to the location specified in LocalPath.

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

     spsbackup/DMLocalPathLocalPath

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