Recovering WSS Databases Using Windows Server Backup

If full system backups have been run on systems running Windows SharePoint Services, because SharePoint and Windows Server Backup are both support and use the Volume Shadow Copy Service (VSS), the databases files can be used for restore purposes. To restore a Windows Internal Database for Windows SharePoint Services from a Windows Server full system backup, perform the following steps:

1. Log on to the Windows Server 2008 R2 system with an account with administrator privileges.

2. Click Start, click All Programs, click Administrative Tools, and select Internet Information Services (IIS manager).

3. Double-click on the server in the tree pane, and double-click on Sites.

4. Locate the WSS site that will be restored, right-click the site, choose Manage Web
Site, and click Stop. This stops the website. Leave IIS Manager open.

5. Click Start, click All Programs, click Administrative Tools, and select Services.

6. Locate the Windows SharePoint Services Timer Service, right-click the service, and select Stop.

7. Scroll up and locate the Windows Internal Database (MICROSOFT##SSEE) service, right-click the service, and select Stop. Leave the services console open.

8. Click Start, click All Programs, click Administrative Tools, and select Windows Server Backup.

9. In the Actions pane, select Recover to start the Recovery Wizard.

10. On the Getting Started page, select either to restore data previously backed up from the local computer or a different computer. For this example, select This Server (Servername), and click Next to continue.

11. On the next page, select the date of the backup by selecting the correct month and click on the particular day.

12. After the month and day are selected, if multiple backups were run in a single day, click the Time drop-down list arrow, and select the correct backup.

13. On the Select Recovery Type page, select the Files and Folders option button and click Next to continue.

14. On the Select Items to Recover page, expand the server node; select the disks, folders, and files to be restored; and click Next to continue. For example, select the c:\windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\WSS_Content.MDF and WSS_Content_log.LDF, as shown in Figure 31.11.

15. On the Specify Recovery Options page, specify whether the files will be restored to the original location or an alternate location. Do not click Next.

16. On the Specify Recovery Options page, choose to recover the files to the original location and choose to overwrite the existing versions with the recovered versions. Ensure that the check box to restore access control list permissions is checked and click Next to continue.

17. On the Confirmation page, verify the restore selections and options. If everything is
correct, click the Recover button to start the recovery process.

18. On the Recovery Progress page, verify the success of the recovery or troubleshoot the errors if the recovery fails.

19. Click Close to complete the recovery and close Windows Server Backup.

20. Open the Services window and start the Windows Internal Database Service and start the Windows SharePoint Services Timer Service. Close the Services console.

21. Open the IIS Manager console, locate the SharePoint site, right-click the site, choose Manage Web Site, and click Start to start the website.

22. Open a web browser and connect to the SharePoint site. If everything looks okay, perform a full backup of the system.

Source of Information : Sams - Windows Server 2008 R2 Unleashed

0 comments:

Subscribe to Computing Tech

Enter your email address:

Delivered by FeedBurner

Add to Technorati Favorites Top Blogs