SLAPPA.ORG

Your company Web site is based on Microsoft Windows SharePoint® Services. You can enable the recovery of Windows SharePoint Services files. If a file or list item is accidentally deleted from your company Web site, you can restore it without having to perform a full recovery from your backup media. Instead, you can create a copy of your Windows SharePoint Services database on your hard disk.

Use the following procedure to schedule a task to enable you to restore Windows SharePoint Services files.

 To enable recovery of individual Windows SharePoint Services files 1.   Click Start, click Control Panel, click Scheduled Tasks, and then click AddScheduled Task.

2.   Click Next on the first page of the Scheduled Task Wizard.

3.   Click Browse, go to %Programfiles%\Common Files\Microsoft Shared\Web server extensions\60\Bin, and then double-click Stsadm.exe.

4.   Select how often you want this task to run, and then click Next.

5.   Select a time to run the schedule, and then click Next.

6.   Enter administrator credentials, and then click Next.

7.   Select the Open advanced properties when I click finish check box, and then click Finish. A dialog box appears.

8.   Click the Task tab, and then in the Run box, type “%Programfiles%\Common files\Microsoft shared\Web server extensions\60\Bin\Stsadm.exe” -o backup -url http://Companyweb -filename “target path” -overwrite, where target path is where you save the backup of your internal Web site. You must type the quotation marks. Click OK.

After you click OK, a dialog box appears, prompting you to enter administrator credentials.

Note: If you do not want a duplicate of your Windows SharePoint Services database in your backup, you can exclude the location of the database by using the Backup Configuration Wizard. Excluding the Windows SharePoint Services database from your backup does not allow you to restore a previous version of the database that is more than one day old.
 

To restore Windows SharePoint Services files

 1.   From the server, click Start, click Command Prompt, and then type “%Programfiles%\Common files\Microsoft shared\Web server extensions\60\Bin\Stsadm.exe” -o createsiteinnewdb -url http://companyweb/sites/RestoredSite -ownerlogin DOMAIN\administrator -owneremail administrator@DOMAIN.local -databasename STS_RESTORE, where DOMAIN is your server domain, administrator is the name of the built-in administrator account,  and administrator@DOMAIN.local is your administrator’s e-mail address. Include the quotation marks as part of the path. Press ENTER.

2.   Type “%Programfiles”\Common files\Microsoft shared\Web server extensions\60\Bin\Stsadm.exe” -o restore -url http://Companyweb/Sites/Restoredsite -filename “target path” -overwrite, where target path is the location where you chose to save your Windows SharePoint Services backup. Include the quotation marks as part of the path. Press ENTER.

3.   Open Internet Explorer. In the address bar, type http://Companyweb/Sites/Restoredsite. The site that displays is your company’s Web site at the time of your last successful backup.

4.   In the restored site, navigate to the missing file.

5.   Right-click the file, select Save Target As, and then select a location to which to save the file.

6.   Repeat Steps 4 and 5 for all missing files.

7.   Open your company Web site, navigate to the location where the missing files should be, and then on the toolbar in Windows SharePoint Services, click Upload Document.

Note: You cannot upload multiple files at the same time using the remainder of the steps in this procedure. If you have a large number of files to restore to the same location, click Start, click Server Management, click Internal Web Site, click Import Files and complete the Import Files Wizard.

8.   Type the path or browse to the location where you saved the file, and then on the toolbar in Windows SharePoint Services, click Save and Close.

9.   After you have recovered the files that you need, delete the restored subsite as follows:

a.   Click Start, click Server Management, click Internal Web Site, and then click Central Administration.

b.   Under Virtual Server Configuration, click Configure Virtual Server Settings.

c.   Click companyweb.

d.   Under Virtual Server Management, click Delete site collection.

e.   Type http://Companyweb/Sites/Restoredsite, click OK, and then click Delete.

10.  After you have recovered the files that you need, delete the content database as follows:

a.   Click Start, click Server Management, click Internal Web Site, and then click Central Administration.

b.   Under Virtual Server Configuration, click Configure Virtual Server Settings.

c.   Click companyweb.

d.   Under Virtual Server Management, click Manage content databases.

e.   Click STS_RESTORE.

f.    Under Remove Content Database, select remove content database, and then click OK.

g.   Click Start, click Command Prompt, and then type osql -E -S SERVERNAME\SharePoint -Q “drop database sts_restore”, where SERVERNAME is the name of the server running Windows Small Business Server 2003. You must include the quotation marks. Press ENTER.
 

To restore list items in Windows SharePoint Services

1.   From the server , click Start, click Command Prompt, and then type “%SystemDrive%\Program files\Common files\Microsoft shared\Web server extensions\60\Bin\Stsadm.exe” -o createsiteinnewdb -url http://companyweb/sites/RestoredSite -ownerlogin DOMAIN\administrator -owneremail administrator@DOMAIN.local -databasename STS_RESTORE, where DOMAIN is your server domain and administrator@DOMAIN.local is your administrator’s e-mail address. Include the quotation marks as part of the path. Press ENTER.

2.   Type “%SystemDrive%\Program files\Common files\Microsoft shared\Web server extensions\60\Bin\Stsadm.exe” -o restore -url http://Companyweb/Sites/Restoredsite -filename target path -overwrite, where target path is the location where you chose to save your Windows SharePoint Services backup. Include the quotation marks as part of the path. Press ENTER.

3.   Open Internet Explorer. In the address bar, type http://Companyweb/Sites/Restoredsite. The site that appears is the same as your company Web site. This is your restored site.

4.   In the restored site, open the missing list item.

5.   In Internet Explorer, on the File menu, click New, and then click Window to open a new Internet Explorer window and navigate to the location to which you want to restore the list item.

6.   In the location to which you want to restore, copy line-by-line the contents of the list item from the restored site to the live site.

7.   Repeat Steps 4 through 6 for all missing list items.

8.   After you have recovered the files that you need, delete the restored subsite as follows:

a.   Click Start, click Server Management, click Internal Web Site, and then click Central Administration.

b.   Under Virtual Server Configuration, click Configure Virtual Server Settings.

c.   Click companyweb.

d.   Under Virtual Server Management, click Delete site collection.

e.   Type http://Companyweb/Sites/Restoredsite, click OK, and then click Delete.

9.   After you have recovered the files that you need, delete the content database:

a.   Click Start, click Server Management, click Internal Web Site, and then click Central Administration.

b.   Under Virtual Server Configuration, click Configure Virtual Server Settings.

c.   Click companyweb.

d.   Under Virtual Server Management, click Manage content databases.

e.   Click STS_RESTORE.

f.    Under Remove Content Database, select remove content database, and then click OK.

g.   Click Start, click Command Prompt, and then type osql -E -S SERVERNAME\SharePoint -Q “drop database sts_restore”, where SERVERNAME is the name of the server running Windows Small Business Server 2003. You must include the quotation marks. Press ENTER