Preliminaries
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?
Which file is considered the Content database and what is it responsible for?
STS_servername_instance
Troubleshooting Logs
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”
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 http://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 http://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