Back up SSPs (Office SharePoint Server 2007)
Applies To: Office SharePoint Server 2007
This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.
Topic Last Modified: 2008-07-18
Before you perform these procedures, ensure that:
You are logged on to the server running the SharePoint Central Administration Web site.
You have read Back up and restore SSPs (Office SharePoint Server 2007).
You have created a backup folder on the network in which to store your backups. For more information, see Prepare to back up and restore a farm (Office SharePoint Server 2007).
Back up SSPs by using built-in tools
Use this procedure to back up a Shared Services Provider (SSP) by using the SharePoint Central Administration Web site.
Membership in the Farm Administrators SharePoint group is the minimum required to complete the following procedure. You also need to be a member of the db_backupoperator fixed database role on each database you are backing up on the database server where each database is stored. The SSP content databases might be on a different database server than the SSP database.
Back up an SSP by using the user interface
On the SharePoint Central Administration Web site, on the Operations page, in the Backup and Restore section, click Perform a backup.
On the Select Component to Backup page, select the check boxes for the SSP you want to back up. Click Continue to Backup Options. Verify that all associated databases are automatically checked. To back up databases separately from the SSP, see Back up databases (Office SharePoint Server).
On the Select Backup Options page:
In the Backup Content section, verify that the SSP you selected is displayed.
In the Type of Backup section, select Full.
In the Backup File Location section, type the UNC path of the backup folder.
You can view the backup job status on the status page by clicking Refresh. The page also refreshes every 30 seconds automatically. Backup and recovery uses the Windows SharePoint Services Timer Service to schedule jobs, so it may take few seconds for the backup to start.
If you receive any errors, you can find more information by viewing the spbackup.log at the UNC path you specified above.
Use this procedure to back up a Web application by using the Stsadm command-line tool.
Membership in the Administrators group on the local computer is the minimum required to complete the following procedure. You also need to be a member of the db_backupoperator fixed database role on each database you are backing up on the database server where each database is stored. The SSP content databases might be on a different database server than the SSP database.
Back up an SSP by using the command line
On the drive on which SharePoint Products and Technologies is installed, change to the following directory: %COMMONPROGRAMFILES%\Microsoft shared\Web server extensions\12\Bin.
If you do not already know what node you want to back up, type the following command:
stsadm –o backup –showtree
Items enclosed by square brackets ([ ]) cannot be directly selected for backup but are backed up when their parent item is selected.
To back up an SSP, type the following command:
stsadm -o backup -directory <\\server name\folder name> -backupmethod full -item <SSP name>
where \\server name\folder name is the UNC path of the backup folder and where SSP name is the name of the SSP that you want to back up. For example: SharedServices1. All databases associated with the SSP will be included automatically in the backup.
If the backup completes successfully, the Command Prompt window displays the following text:
Completed with 0 warnings. Completed with 0 errors. Backup completed successfully. --------------------------------------------------------- Operation completed successfully.
If there are errors or warnings, or if the backup does not complete successfully, review the spbackup.log file in the folder that you specified in step 3.
Schedule or delay backups
It is not possible to schedule backups from the SharePoint Central Administration Web site. There is no operation that enables you to automate backups by using the Stsadm command-line tool. You can, however, automate the process by creating a batch file and then using Task Scheduler in Windows Server 2003 to run the batch file at a specific time. Because performance can be affected when doing backups with the Office SharePoint Server 2007 built-in tools, you might want to schedule your backups for off-peak times such as at night or on weekends.
Use this procedure to create a batch file that will run a full backup of your SSP. This procedure assumes that you have already created a shared folder for your backups. For more information about how to create a shared folder, see the following article Prepare to back up and restore a farm (Office SharePoint Server 2007).
When using Task Scheduler, make sure the system date and time on your computer are accurate. To verify or change this information, double-click the time indicator on the taskbar.
Create a batch file
Click Start, and then click Run.
Type notepad, and then click OK.
In Notepad, type the following text:
@echo off echo =============================================================== echo Back up sites for the farm to C:\backup echo =============================================================== cd \Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN @echo off stsadm -o backup -directory <\\server name\folder name> -backupmethod full -item <database name> echo completed
where \\server name\folder name is the UNC path to the backup folder and where SSP name is the name of the SSP that you want to back up, for example: SharedServices1.
In Notepad, on the File menu, click Save As.
In the Save As box, select the folder where you want to keep your batch file.
Using the ".bat" file name extension, type the name of the file in the File name box, for example, backup_batch.bat.
In the Save as type box, click All files.
Schedule a backup
Start the Scheduled Task Wizard, and then click Next.
Click Browse, navigate to the batch file that you just created, and then click Open.
Type a name for your task, for example, backup_batch.
Select the frequency of this task (for example, weekly), and then click Next.
To automatically perform this backup periodically, select an interval such as Weekly or Monthly. To perform this backup one time, or to delay a single backup, select One time only.
Choose a time and start date for your backup.
Type a name and password for a user, and then click Next. This task will run as if it were started by that user.
To configure advanced settings for the task, select the Open advanced properties for this task when I click Finish check box in the final page of the wizard. This opens the properties dialog box for the task when you click Finish. You can then change the program being run on the Task tab, fine-tune the schedule on the Schedule tab, customize settings on the Settings tab, or set user and group permissions on the Security tab.