Recovering Companyweb from Database Files only.

Preliminaries

1. Must be able to mount a new Companyweb site with empty databases.
   1.  Kb 829114 - How to remove and how to install the Windows Small Business Server 2003 SharePoint Services companyweb Web site
2. 3. Server must be fully patched
3. Make sure you have good copies of the old databases and they are accessible.
4. Server must have the same domain name as the server the databases originated from.

Default Database file locations

\Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data

Database files in question:

STS_Config.mdf

STS_Config_log.ldf

STS_%computername%_1.mdf

STS _%computername %_1_log.ldf

Which file is considered the “Configuration” database and what is it responsible for?

STS_Config.mdf

1. Maintains the connection between Servers and Content Databases.
2. Stores server settings and site content.
3. Site mapping Information.
4. Holds Virtual Server and Global Settings for Windows Sharepoint Services <WSS>

 

Which file is considered the Content database and what is it responsible for?

STS_servername_instance

1. Responsible for storing Data from the sites
2. Stores User Names and Permissions
3. Stores Content – such as list data and documents from document libraries

Troubleshooting Logs

1. Program files\Microsoft Windows Small Business Server\Support\STSProvision.txt
2. Documents and Settings\Administrator\Local Settings\Temp\Stsadm.log
3. Microsoft Windows SharePoint Services 2.0 Setup_task(0001).txt - Installation log file for WSS
4. Microsoft Windows SharePoint Services 2.0 Setup_task(0002).txt - Installation log file for MSDE
5. Eventviewer - Application Log

Steps to complete the Disaster Recovery Process.

1. Detach the blank SharePoint Databases.

Commands to detach Blank Databases

C:\>osql -E –S %computername%\sharepoint

1>sp_detach_db 'STS_Config'

2>go <Enter>

 

1>sp_detach_db 'STS_servername_1'

2>go

2. Restore the old SharePoint Services Databases.

Remove the 4 "new" database files listed above - Copy the "old" database files into the database path.

 

3. Attach the old databases to SharePoint.

To attach the old database follow this:

C:\>osql –E –S %computername%\sharepoint <enter>

1>sp_attach_db @dbname = 'STS_Config', @filename1= “C:\Program Files\Microsoft SQL Server\MSSQL$Sharepoint\Data\STS_config.mdf”, @filename2 = “C:\Program Files\Microsoft SQL Server\MSSQL$Sharepoint\ Data\ STS_Config_log.ldf”

Go

sp_attach_db @dbname = 'STS_%computername%_1', @filename1= “C:\Program Files\Microsoft SQL Server\MSSQL$Sharepoint\Data \STS_ %computername%_ _1.mdf”, @filename2 = “C:\Program Files\Microsoft SQL Server\MSSQL$Sharepoint\Data \STS_ %computername%_ 1_log.ldf”

Go

IISRESET

4. Remove the SharePoint Services from Companyweb.

Open SharePoint administration

Under Virtual Server Configuration - select Configure Virtual Server Settings

On the Virtual Server list page – select Companyweb

Under Virtual Server Management – select Remove Windows SharePoint services from Virtual Server

Remove Windows SharePoint Services from Virtual Server page, click Remove without deleting content databases.

ok

5. Extend the Companyweb Virtual Server to SharePoint Services.

Central Administration page click Extend or upgrade virtual server under Virtual Server Configuration.

On the Virtual Server List page, click companyweb.

On the Extend Virtual Server page, click Extend and map to another virtual server in the Provisioning Options section.

In the Server Mapping section, click companyweb.

In the Application Pool section, click Use an existing application pool, click DefaultAppPool (NT AUTHORITY\ NETWORK SERVICE),

click OK.

6. Create a second Administrator account.

Start - Server Management.

In Server Management, click Users.

Under Manage Users, click Add a User.

On the first page of the Add User Wizard, click Next.

Type a name for the account, and then click Next.

Type and then confirm a password for the new account, and then click Next.

In the Templates box, click Administrator Template, and then click Next.

Click Do not set up a computer, and then click Next.

Click Finish to complete the wizard.

7. Change the Site Collection Owner account.

Click Start, point to Administrative Tools, and then click SharePoint Central Administration

Under Security Configuration, click Manage site collection owners.

In the Web Site URL box, type https://companyweb , and then click View.

In the User name box that is next to Site Collection Owner, change the username to be the new domain administrator account, and then click Check name.

Click OK.

8. Remove old user accts.

Open https://companyweb

On the Companyweb home page - Site Settings.

Under Administration, click Site Administration.

Under Site Collection Administration, click View site collection user information.

On the Manage Site Collection Users page, write down all the user accounts. You will use this information to re-create the user accounts.

Select all accounts except the domain administrator account that you created in step 1,

Click Remove Selected Users, and then click OK to confirm. Make sure to remove the following template accounts: •Administrator Tmpl •Mobile User Tmpl •Power User Tmpl •User Tmpl

9. Re-create the SharePoint Services user accounts.

Open companyweb ,

On the Companyweb home page, click Site Settings.

Under Administration, click Manage Users

On the Manage Users page, click Add Users.

Choose Users, type the following accounts in the Users box:

      administrator@ domain.local; Administrator Tmpl@ domain.local;

                                Power User Tmpl@ domain.local

Choose Site Groups, click to select the Administrator check box, and then click Next.

Confirm Users, verify that the User Name and the Display Name are correct.

click to clear the Send the following e-mail to let these users know they’ve been added check box, and then click - Finish.

10. Change the Site Collection Owner back to administrator.

Follow Step 7.

Thanks,

>edwalt

Comments

• Anonymous
  January 01, 2003
  PingBack from http://www.keyongtech.com/4213483-restore-sharepoint-services-from-mdf

• Anonymous
  January 01, 2003
  PingBack from http://www.keyongtech.com/4211760-sbs2003-and-sharepoint

• Anonymous
  January 23, 2008
  The comment has been removed

• Anonymous
  February 29, 2008
  A9MuYX r u crazzy? I told u! I can't read!

• Anonymous
  March 01, 2008
  nI8yHb r u crazzy? I told u! I can't read!

• Anonymous
  March 06, 2008
  BcSHSa r u crazzy? I told u! I can't read, man!

• Anonymous
  March 06, 2008
  JkSn4q r u crazzy? I told u! I can't read!

• Anonymous
  March 07, 2008
  mMnbya r u crazzy? I told u! I can't read!

• Anonymous
  March 07, 2008
  Tdz1vG r u crazzy? I told u! I can't read!

• Anonymous
  March 07, 2008
  enFgKn r u crazzy? I told u! I can't read!

• Anonymous
  March 07, 2008
  9N99zT r u crazzy? I told u! I can't read!

• Anonymous
  March 08, 2008
  AGCKSU r u crazzy? I told u! I can't read!

• Anonymous
  March 08, 2008
  bvlz24 r u crazzy? I told u! I can't read!