This article discusses how to back up a Windows SharePoint Services http://companyweb database in Microsoft Small Business Server 2003 and how to restore the database back to the original server. You can do the backup and the restore operations by using Microsoft Windows NT Backup or by using the Stsadm.exe command-line tool.

For these steps to work, you must meet the following criteria:

•	You must restore the database to the same server where you performed the backup operation.
•	The following Windows SharePoint Services database and log files must be on the server: • STS_Config.mdf • STS_Config_log.ldf • STS_Servername_1.mdf • STS_Servername_1_log.ldf

Back up and restore a Windows SharePoint Services http://companyweb database by using Windows NT Backup

1.

To back up the Windows SharePoint Services http://companyweb database by using Windows NT Backup, follow these steps: a. Click Start, point to All Programs, point to Accessories, point to System Tools, and then click Backup. b. In the Backup or Restore Wizard, click Advanced Mode, and then click the Backup tab. c. Click to select the check box of the folder where the Windows SharePoint Services databases are installed. By default, this is \Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data. Note This is the default installation folder for Windows SharePoint Services databases. d. Specify a destination for the backup, and then click Start Backup.

2.

To restore a Windows SharePoint Services http://companyweb database by using Windows NT Backup, follow these steps: Note This action overwrites the existing Windows SharePoint Services databases. Microsoft recommends that you back up the current \Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data folder before you restore files.   a. Click Start, point to All Programs, point to Accessories, point to System Tools, and then click Backup. b. In the Backup or Restore Wizard, click Advanced Mode. c. Click the Restore and Manage Media tab. d. Select the tape drive or other backup storage device that contains the http://companyweb database(s) that you backed up in step 1. e. Click to select the check box of the folder where the Windows SharePoint Services databases are installed. By default, this is \Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data . f. On the Tools menu, click Options. g. Click the Restore tab, click to select the Always replace the file on my computer check box, and then click OK.   h. Verify that Restore Files to is set to Original location, and then click Start Restore. Click OK to start restoring your data. Note After you click Start Restore, you can click Advanced in the Confirm Restore dialog box. Microsoft recommends that you do not make any changes to the default advanced restore options until you know that the restore was successful. For more information about advanced restore options, visit the following Microsoft Web site:   i. When the restore is complete, click Close in the Restore Progress dialog box, and then click Yes to restart the server.

 

Back up and restore a Windows SharePoint Services http://companyweb database by using the Stsadm.exe command-line tool

1.

To back up a Windows SharePoint Services http://companyweb database by using Stsadm.exe, follow these steps: a. Click Start, and then click Run. b. In the Open: box, type cmd, and then click OK. c. At the command prompt, type the following, and then press ENTER: cd %programfiles%\Common Files\Microsoft Shared\web server extensions\60\BIN d. At the command prompt, type the following, where Backup_Path is the path of the backup file, and then press ENTER: stsadm -o backup -url http://companyweb -filename Backup_Path For example, if you type stsadm -o backup -url http://companyweb -filename c:\backup.dat, you will back up http://companyweb to the Backup.dat file. This file is located in the root directory of drive C. Note This command backs up the http://companyweb top-level Web site and its subwebs only. If you have additional top-level Web sites, you must use Stsadm.exe to back up each top-level site. e. Type exit, and then press ENTER.

2.

To restore a Windows SharePoint Services http://companyweb database by using Stsadm.exe, follow these steps: a. Click Start, and then click Run. b. In the Open: box, type cmd, and then click OK. c. At the command prompt, type the following and then press ENTER: cd %programfiles%\Common Files\Microsoft Shared\web server extensions\60\BIN d. At the command prompt, type the following, where Backup_Path is the path of the backup file, and then press ENTER: stsadm -o restore -url http://companyweb -filename Backup_Path -overwrite For example, if you type stsadm -o restore -url http://companyweb -filename c:\backup.dat -overwrite, you will restore http://companyweb from the Backup.dat file. This file is located in the root directory of drive C. e. Type exit, and then press ENTER.

Example script to create daily backups of the http://companyweb database

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. The following example script uses a numbered value for the day of the week. The script then appends this number to the name of the backup file that the script creates in the X:\Backups location. To use this script, copy the following code to a Notepad file, and then customize the text string that specifies the backup file (x:\backups\companyweb). Next, save the Notepad file by using the file name Wssback.vbs, and then create a scheduled task to run this script daily.

dim dayweek
dim strBackup 
dayweek = datepart("w",(date)) 
strBackup = """C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN\stsadm""" + _
"-o backup -url http://companyweb -filename x:\backups\companyweb" + cstr(dayweek) + ".dat -overwrite" 
Set WshShell = WScript.CreateObject("WScript.Shell") 
Return = WshShell.Run(strBackup, 0, true) 
Set WshShell = Nothing

To add this script as a scheduled task, follow these steps:

1.	Open Control Panel.
2.	Double-click Scheduled Tasks.
3.	On the File menu in Scheduled Tasks, point to New, and then click Scheduled Task.
4.	Type a name for the scheduled task, such as Companyweb Backup.
5.	Double-click the new task to open the task properties.
6.	In the Run box, type cscript Drive:\Wssback.vbs. Note In this step, Drive is the location of the Wssback.vbs file.
7.	Click Set password, type the password for the user account that the task will use in the Password box and in the Confirm password box, and then click OK.
8.	Click the Schedule tab, configure the appropriate schedule, and then click OK.
9.	To test the scheduled task, right-click the task, and then click Run. After the task runs, visit the location that you specified for the backup file to verify that the script created the file.

For more information about the Windows SharePoint Services Software Development Kit (SDK), visit the following Microsoft Web site: For more information about the Windows SharePoint Services Administrator's Guide, visit the following Microsoft Web site: For more information, click the following article number to view the article in the Microsoft Knowledge Base: For more information, click the following article number to view the article in the Microsoft Knowledge Base: