How to back up and restore http://companyweb data in Windows Small Business Server 2003

How to back up and restore http://companyweb data in Windows Small Business Server 2003

Article ID : 829112
Last Review : May 4, 2005
Revision : 5.0

SUMMARY

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 to the top

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 FilesMicrosoft SQL ServerMSSQL$SharePointData.

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 FilesMicrosoft SQL ServerMSSQL$SharePointData 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 ShareP
oint Services databases are installed. By default, this is Program FilesMicrosoft SQL ServerMSSQL$SharePointData .
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 to the top

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 FilesMicrosoft Sharedweb server extensions60BIN
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 FilesMicrosoft Sharedweb server extensions60BIN
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, including, but 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 the tools that are used to create and debug procedures. Microsoft support professionals 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. If you have limited programming experience, you may want to contact a Microsoft Certified Partner or the Microsoft fee-based consulting line at (800) 936-5200. For more information about Microsoft Certified Partners, visit the following Microsoft Web site:

For additional information about the support options available from Microsoft, visit the following Microsoft Web site:

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:backupscompanyweb). Next, save the Notepad file by using the file name Wssback.vbs, and then create a scheduled task to run this script daily.

dim dayweekdim strBackupdayweek = datepart("w",(date))strBackup = """C:Program FilesCommon FilesMicrosoft Sharedweb server extensions60BINstsadm""" + _"-o backup -url http://companyweb -filename x:backupscompanyweb" + cstr(dayweek) + ".dat -overwrite"wscript.echo "Backing up Companyweb"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.

back to the top

REFERENCES

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 additional information, click the following article number to view the article in the Microsoft Knowledge Base:

829113 How to restore a Windows SharePoint Services CompanyWeb database after the intranet component and SQL Server or MSDE 2000 have been removed on Windows Small Business Server

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

827701 How to perform a disaster recovery operation of SharePoint Services Companyweb and SharePoint Services Databases

back to the top


APPLIES TO
Microsoft Windows Small Business Server 2003 Premium Edition
Microsoft Windows Small Business Server 2003 Standard Edition
Microsoft Windows SharePoint Services
Keywords: 
kbhowtomaster kbbug KB829112

Link to this Article