Restore SharePoint files

  • Article

Your company Web site is based on Windows SharePoint Services. If you have enabled the recovery of SharePoint files, you can recover a file or list item by restoring the entire site from a backup to a subsite of https://companyweb, selecting the file or list item that you want to restore, extracting it, and uploading it to its original location. To enable the recovery of individual SharePoint files, see Enable recovery of individual SharePoint files.

To restore SharePoint files

From the server:

  1. 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 https://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 https://Companyweb/Sites/Restoredsite -filename target path -overwrite, where target path is the location where you chose to save your SharePoint backup. Include the quotation marks as part of the path. Press ENTER.
  3. Open Internet Explorer, and in the address bar, type https://Companyweb/Sites/Restoredsite. The site that appears is the same as your company Web site.
  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 SharePoint toolbar, 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, and then click Import Files.

  1. Type the path or browse to the location where you saved the file, and then on the SharePoint toolbar, click Save and Close.
  2. To delete the restored subsite:
    1. In Server Management, click Internal Web Site, and then click Central Administration.
    2. Under Virtual Server Configuration, click Configure Virtual Server Settings.
    3. Click companyweb.
    4. Under Virtual Server Management, click Delete site collection.
    5. Type https://companyweb/sites/Restoredsite, click OK, and then click Delete.
  3. To delete the content database:
    1. Under Virtual Server Management, click Manage content databases.
    2. Click STS_RESTORE.
    3. Under Remove Content Database, select remove content database, and then click OK.
  4. 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.

To restore list items

From the server:

  1. 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 https://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 https://Companyweb/Sites/Restoredsite -filename target path -overwrite, where target path is the location where you chose to save your SharePoint backup. Include the quotation marks as part of the path. Press ENTER.
  3. Open Internet Explorer, and in the address bar, type https://Companyweb/Sites/Restoredsite. The site that appears is the same as your company Web site.
  4. In the restored site, navigate to the missing list item.
  5. Select the text of the list item that you want to restore.
  6. Right-click the selected text, and then select Copy.
  7. Open your company Web site, navigate to the location where the missing list item should be, right-click, and then click Paste.
  8. Repeat steps 4-7 for all missing list items.
  9. To delete the restored subsite:
    1. In Server Management, click Internal Web Site, and then click Central Administration.
    2. Under Virtual Server Configuration, click Configure Virtual Server Settings.
    3. Click companyweb.
    4. Under Virtual Server Management, click Delete site collection.
    5. Type https://companyweb/sites/Restoredsite, click OK, and then click Delete.
  10. To delete the content database:
    1. Under Virtual Server Management, click Manage content databases.
    2. Click STS_RESTORE.
    3. Under Remove Content Database, select remove content database, and then click OK.
  11. 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.