Recreate your SharePoint Foundation 2010 application and content database

  • Article

Published: March 10, 2011

Updated: May 26, 2011

Applies To: Windows Small Business Server 2011 Standard

Note

This topic describes the steps necessary to repair the Windows SBS SharePoint web application and content database. If you experience problems with a different SharePoint Foundation 2010 web application, you can follow the steps in this topic to repair the content database for that application. Simply substitute the names of databases, services, and application pools where appropriate.

Problem   SharePoint Foundation 2010 is still not working after you completed the procedures in the following topics:

  1. Repair the SharePoint Foundation 2010 Domain Name System

  2. Repair user access to the internal website

  3. Repair user access to SharePoint Foundation 2010

Solution   Perform the following procedures:

  1. Back up your website

  2. Back up the SharePoint content database files

  3. Clean up the existing settings

  4. Recreate the Windows SBS SharePoint web application

  5. Import the backup data into the newly created site

  6. Recreate the original internal website environment

Back up your website

To back up the existing data on your server

  1. Click Start; in Start Search, type cmd; in Programs, right-click cmd, and then click Run as administrator.

  2. Type CD C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN, and then press ENTER.

  3. Type stsadm -o export -url https://companyweb -filename companyweb.bak –includeusersecurity, and then press ENTER.

Note

This command exports the data by backing it up to companyweb.bak. For the command to work properly, your internal website must be functioning. If this step fails, verify that the Internet Information Services (IIS) and Domain Name System (DNS) settings are repaired. For more information about how to repair IIS and DNS, see Repair the Windows SharePoint Services Domain Name System.

  1. Do not exit the Command Prompt window. Proceed to the following procedures to clean up the settings.

Back up the SharePoint content database files

To back up the SharePoint content database files

  1. Click Start, click Administrative Tools, and then click Services.

  2. On the User Account Control page, click Continue.

  3. In Services, right-click SharePoint Foundation Search V4, and then click Stop.

  4. In Services, right-click SharePoint 2010 Timer, and then click Stop.

  5. In Services, right-click SQL Server (SHAREPOINT), and then click Stop.

  6. Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.

  7. In the Internet Information Services (IIS) Manager Connections pane, expand the node for your server, and then click the Application Pools node.

  8. In the Application Pools list, right click SBS Sharepoint AppPool, and then click Stop.

  9. In the Application Pools list, right click SharePoint Web Services Root, and then click Stop.

  10. In the Application Pools list, right click SharePoint Central Administration v4, and then click Stop.

  11. In the Internet Information Services (IIS) Manager Connections pane, expand the Sites node.

  12. In the Sites list, right click Companyweb, point to Manage Web Site, and then click Stop.

  13. In the Sites list, right click SBS SharePoint, point to Manage Web Site, and then click Stop.

  14. In the Sites list, right click SharePoint Central Administration v4, point to Manage Web Site, and then click Stop.

  15. In the Sites list, right click SharePoint Web Services, point to Manage Web Site, and then click Stop.

  16. Back up the following files or folders by copying them to your hard drive or to a removable storage device, such as a USB flash drive.

Note

The asterisks (*) in this list denote a randomly generated string, and C is the drive where you installed Windows SBS 2011 Standard. 

  - C:\\Program Files\\Microsoft SQL Server\\MSSQL10\_50.SHAREPOINT\\MSSQL\\DATA\\SharePoint\_AdminContent\_\*.mdf  
      
  - C:\\Program Files\\Microsoft SQL Server\\MSSQL10\_50.SHAREPOINT\\MSSQL\\DATA\\SharePoint\_AdminContent\_\*\_log.LDF  
      
  - C:\\Program Files\\Microsoft SQL Server\\MSSQL10\_50.SHAREPOINT\\MSSQL\\DATA\\SharePoint\_ConfigurationDatabase.mdf  
      
  - C:\\Program Files\\Microsoft SQL Server\\MSSQL10\_50.SHAREPOINT\\MSSQL\\DATA\\ SharePoint\_ConfigurationDatabase\_log.LDF  
      
  - C:\\Program Files\\Microsoft SQL Server\\MSSQL10\_50.SHAREPOINT\\MSSQL\\DATA\\ShareWebDb.mdf  
      
  - C:\\Program Files\\Microsoft SQL Server\\MSSQL10\_50.SHAREPOINT\\MSSQL\\DATA\\ShareWebDb\_log.LDF  
      
  - C:\\Program Files\\Microsoft SQL Server\\MSSQL10\_50.SHAREPOINT\\MSSQL\\DATA\\WSS\_Search\_\*.mdf  
      
  - C:\\Program Files\\Microsoft SQL Server\\MSSQL10\_50.SHAREPOINT\\MSSQL\\DATA\\WSS\_Search\_ \*\_log.LDF

  1. In the Internet Information Services (IIS) Manager Connections pane, expand the node for your server, and then expand the Sites node.

  2. In the Sites list, right click Companyweb, point to Manage Web Site, and then click Start.

  3. In the Sites list, right click SBS SharePoint, point to Manage Web Site, and then click Start.

  4. In the Sites list, right click SharePoint Central Administration v4, point to Manage Web Site, and then click Start.

  5. In the Sites list, right click SharePoint Web Services, point to Manage Web Site, and then click Start.

  6. In the Internet Information Services (IIS) Manager Connections pane, click the Application Pools node.

  7. In the Application Pools list, right click SBS Sharepoint AppPool, and then click Start.

  8. In the Application Pools list, right click SharePoint Web Services Root, and then click Start.

  9. In the Application Pools list, right click SharePoint Central Administration v4, and then click Start.

  10. Click Start, click Administrative Tools, and then click Services.

  11. On the User Account Control page, click Continue.

  12. In Services, right-click SharePoint Foundation Search V4, and then click Start.

  13. In Services, right-click SharePoint 2010 Timer, and then click Start.

  14. In Services, right-click SQL Server (SHAREPOINT), and then click Start.

Clean up the existing settings

To clean up the existing settings

  1. Click Start, click All Programs, click Microsoft SharePoint 2010 products, and then click SharePoint 2010 Central Administration.

  2. On the User Account Control page, click Continue.

  3. Click Application Management, and then click Manage Web Applications.

  4. Choose SBS SharePoint, and then click Delete Web application.

  5. On the Delete Web Application page, in Delete content databases, click Yes.

  6. In Delete IIS Web sites, click Yes.

  7. Click Delete, and then click OK to confirm.

  8. Do not close the SharePoint 2010 Central Administration tool.

Recreate the Windows SBS SharePoint web application

To create a SharePoint Foundation 2010 application in Windows SBS 2011 Standard

  1. Click New to create a new web application.

  2. Click Create a new IIS web site, and then enter the following values:

    • For the description, type SBS SharePoint.

    • For the Port, type 987.

    • For the Host header, type sites.

    • For the Path, type C:\Program Files\Windows Small Business Server\Bin\webapp\InternalWebsite.

    • For the Authentication provider, click NTLM.

    • For Allow Anonymous, click No.

    • For User Security Socket Layer(SSL), click Yes.

    • In Create new application pool, type SBS Sharepoint AppPool, and then choose <domain name>\spwebapp as the security account.

    • In Database Server, type <server name>\SharePoint.

    • In Database Name, type ShareWebDb.

  3. Choose <server name> as your Search Server.

  4. Click OK.

  5. Choose SBS SharePoint, and then click Extend.

  6. Click Create a new IIS web site, and then for the description, type Companyweb.

  7. Enter the following values:

    1. For the Port, type 80.

    2. For the Host header, type companyweb.

    3. For the Path, use default value.

    4. For the Authentication provider, click Negotiate(Kerberos).

    5. For Allow Anonymous, click No.

    6. For User SSL, click No.

  8. Click OK.

Import the backup data into the newly created site

Follow the steps in this section to restore your original database and import your backup data. If you cannot repair your database, skip the steps in this section and continue with Recreate the original internal website environment.

To attach the copy of the content database from the Source Server

  1. Go to the Central Administration home page.

  2. Click Manage content databases, and then click ShareWebDb.

  3. Choose Remove content database, and then click OK.

  4. Use Microsoft SQL Server Management Studio to add the backup copy of ShareWebdb you created, as follows:

    1. Click Start, click All Programs, click Microsoft SQL Server 2008 R2, and then click SQL Server Management Studio.

    2. Connect to <ServerName>\SharePoint.

    3. Right-click ShareWebDb, click Delete, and confirm.

    4. Right-click Database and click Attach.

Note

We recommend that you back up the database before attaching it. To back up a database, in Microsoft SQL Server Management Studio, right-click the database, point to Tasks, and then click Back Up. 

5.  Click **Add**, locate and select your original SharedWebDb, and click **OK**.

  1. Click Attach Content database, and then in the Database Name text box, type ShareWebDb.

  2. For the SharePoint Foundation 2010 search server, select <server name>.

  3. Click OK.

  4. Try to access https://companyweb. If you still cannot access the site, continue with the following steps.

  5. Click Start, Click All Programs, click Microsoft SharePoint 2010 products, right-click SharePoint 2010 Management Shell, and then click Run as administrator.

  6. Type the following commands to restore companyweb:

    1. Restore-SPSite https://companyweb –Path <file> -Force

    2. Type the path of the file that you backed up in the previous step.

    3. Type A.

  7. Try to access https://companyweb. If you still cannot access the site, your data cannot be repaired. Perform the steps in the next section to create a new Companyweb.

Recreate the original internal website environment

If your original content database cannot be restored, follow the procedures in this section to create a new Companyweb in Windows SBS 2011 Standard.

Warning

After creating the new Companyweb, all the data in your original content database will be erased.

To create a new Companyweb

  1. Click Application Management, and then click Delete site collection. In Site Collection, choose the root site under https://sites:987, and then click Delete.

  2. Click Application Management, and then click Create site collections.

  3. Enter the following settings:

    • In Title, type Companyweb.

    • In Description, type Internal Website.

    • In Template Selection, click Team Site.

    • In Primary site collection administrator, type the user account name of a domain administrator.

    • Optional: Type the name of a secondary administrator.

  4. Click OK.

  5. Add https://computername and https://companyweb to the local intranet zone:

    1. Click Start, and then click Internet Explorer.

    2. Click Tools, and then click Internet Options. The Internet Options dialog box appears.

    3. Click Security, click Local Internet, and then click Sites.

    4. In Add this website to the zone, type https://<ComputerName>, where <ComputerName> is the host name of the server, and then click Add.

    5. Type https://companyweb, and then click Add.

To recreate the internal website environment

  1. Create groups and assign the appropriate rights:

    1. Click Start, click Internet Explorer, and then browse to https://companyweb.

    2. Click Site Actions, and then click Site Settings.

    3. In Users and Permissions, click Site Permissions.

    4. Select the check box next to Companyweb Members.

    5. In Edit User Permissions, click Design – Can view, add, update, delete, approve, and customize, and then clear the Contribute check box.

    6. Click OK to apply the settings.

    7. On the Advanced Permissions page, click New, and then click Add Users.

    8. Set the following, and then click OK to apply the settings:

      • In Users/Groups, type <Domain Name>\Windows SBS SharePoint_MembersGroup, where <Domain Name> is the name of the domain for your server that is running Windows SBS 2011 Standard.

      • In Give Permission, click Add users to SharePoint group, and then click Companyweb Members [Design].

      • If you want to send the users in your network an email message that welcomes them to the network, click Send welcome e-mail to the new users, and then type the Subject and the Personal Message.

  2. Click Companyweb Members, click New, and then click Add Users.

  3. In Users/Groups, type <Domain Name>\Windows SBS SharePoint_MembersGroup, where <Domain Name> is the name of the domain for your server that is running Windows SBS 2011 Standard, and then click OK to apply the settings.

  4. Click Companyweb Owners, click New, and then click Add Users.

  5. In Users/Groups, type <Domain Name>\ Windows SBS SharePoint_OwnersGroup, and then click OK to apply the settings.

  6. Click Companyweb Visitors, click New, then click Add Users.

  7. In Users/Groups, type Windows SBS SharePoint_VisitorsGroup, and then click OK to apply the settings.

  8. Click Site Actions, and then click Site Settings.

  9. In Site Administration, click Sites and workspaces, and then click Site Creation Permissions.

  10. Choose Design, and then click OK.

  11. To verify that the domain administrators are listed in the appropriate groups:

    1. Open the Windows SBS 2011 Standard Console.

    2. Click Users and Groups, and then click Groups.

    3. Click the group that you want to check, and then in the tasks pane, click Edit group properties.

    4. Verify that the domain administrators are listed in the Windows SBS SharePoint_OwnersGroup and that the domain users are listed in the Windows SharePoint_MembersGroup.

  12. Upload the customized master page:

    1. On the home page of the internal website, click Site Actions, and then click Site Settings.

    2. In Galleries, click Master pages.

    3. Click Document., and then click Upload Document.

    4. In Name, browse to C:\Program Files\Windows Small Business Server\data, click the file default.master, and then click Open.

      browse to C:\Program Files\Windows Small Business Server\data\default.master.

    5. Click OK, and then click Save.

  13. Optional: Create the Picture Library.

    1. On the home page of the internal website, click Site Actions, and then click More Options.

    2. In Libraries, click Picture Library.

    3. In the Name text box, type Pictures.

    4. In the Description text box, type a description.

    5. In Navigation, click Yes for Display this picture library on the Quick Launch?.

    6. In Picture Version History, click No for Create a version each time you edit a file in this picture library?

    7. Click Create.

    8. Open Pictures, click New, and then click New Folder.

    9. Type Photos, and then click Save.

  14. Optional: Upload the Windows SBS 2011 Standard logo to the library:

    1. Navigate to the Photos folder, and then click Upload.

    2. Browse to C:\Program Files\Windows Small Business Server\Data\sbs_logo.png, then click OK.

    3. Enter information about the logo, and then click Save.

    4. Optional: Set the site image for the logo:

      1. In Microsoft Internet Explorer, browse to https://companyweb.

      2. In the ribbon, click Page, and then click Edit.

      3. Click the website image on the right. In the ribbon under Picture Tools, click Design.

      4. In the Address text box, type /Pictures/Photos/SBS_Logo.png, and then press ENTER.

      5. In the ribbon, click Page, and then click Save and close.

  15. Verify and create the Fax folders:

Note

This step is required only if you are planning to install or you already installed the Fax service. 

1.  On the home page of the internal website, click **Site Actions**, and then click **Create**.

2.  In **Libraries**, click **Document Library**.

3.  In the **Name** text box, type **Fax Center**.

4.  In the **Description** text box, type a description, and then click **OK**.

5.  On the home page of the internal website, click **Fax Center**, click **Library** in the ribbon, and then click **Create Column**.

6.  Create the following columns:
Type Click

Name of sender

Single line of text

Caller ID

Single line of text

Time received

Date and Time

Pages

Number
7. Click **OK**. 8. Click **Modify View**. 9. In **Columns**, select the following columns, and then click **Position from left** to sort them: 1. **Type (icon linked to document)** 2. **Name (linked to document with edit menu)** 3. **Name of sender** 4. **Caller ID** 5. **Time received** 6. **Pages** 10. Click **OK**. 11. On the **Fax Center** page, click **Documents** in the ribbon, click **New Folder**, and then create the following folders: - Cover pages - Incoming faxes - Saved faxes - Sent faxes 12. Click **Start**, in **Start Search**, type **regedit**, and then press ENTER. 13. In Registry Editor, navigate to HKEY\_LOCAL\_MACHINE\\Software\\Microsoft\\SmallBusinessServer\\InternalWebsite. 14. Right-click **InternalWebSite**, click **New**, click **String Value**, and then set the following values:

Note

The names in the following list are the values that you typed in previous steps. If you changed the names in any previous step, type the names in the table as you typed them previously.

Value name Value data

FaxCenterName

Fax Center

FaxCenterSenderNameFieldName

Name of sender

FaxCenterCallerIdFieldName

Caller ID

FaxCenterTimeReceivedFieldName

Time received

FaxCenterPagesFieldName

Pages

FaxCenterCoverPagesFolderName

Cover pages

FaxCenterIncomingFaxesFolderName

Incoming faxes

FaxCenterSavedFaxesFolderName

Saved faxes

FaxCenterSentFaxesFolderName

Sent faxes
15. Close Regedit.

  1. Optional: Add the Client Help link:

    1. On the home page of the internal website, click View All Site Content.

    2. Click Links, click Add new link, and then type the following information:

      1. In the Web address text box, type https://Sites/webhelp/webhelp.html.

      2. In the Description text box, type Windows Small Business Server 2011 Standard Client Computer Help.

    3. Click Save.

  2. Optional: Create the “Welcome to your internal website” announcement:

    1. Click Start, click All Programs, click Internet Explorer, and then, in the Internet Explorer Address bar, type https://companyweb.

    2. On the home page of the internal website, click Site Actions, and then View All Site Content.

    3. On the home page, click Announcements, then click Add new announcement.

    4. On the Announcements: New Item page:

      • For the title, type: Welcome to your internal website

      • For the body text, type: Windows Small Business Server provides your organization with this internal website. You can use your internal website to share documents, pictures, and other information with co-workers. You can also use features that enable e-mail and fax. For more information, click Windows Small Business Server 2011 Standard Client Computer Help.

    5. Click Save.

  3. Optional: Create the “Install the security certificate for the server on your remote computer” announcement:

    1. Click Start, click All Programs, click Internet Explorer, and then in the Internet Explorer Address bar, type https://companyweb.

    2. On the home page, click Announcements, click New, and then click New Item.

    3. On the Announcements: New Item page:

      • For the announcement title, type: Install the server's security certificate on your remote computer.

      • For the body, type: You can configure remote computers to trust the server that is running Windows Small Business Server 2011 Standard by installing the security certificate for the server. This enables your Internet browser to connect to Remote Web Workplace without security warnings. To install the security certificate for the server on your remote computer, do the following:

      Append your announcement with the following procedure for installing the security certificate:

      1. From a computer that is in the Windows SBS network, open an Internet browser, and then type the following address into the Address bar: \\<ServerName>\public\downloads, where <ServerName> is the name of your server.

      2. Copy the file Install Certificate Package.zip to a removable storage device, such as a USB flash drive.

      3. Insert the storage device into the computer that is not joined to the Windows SBS domain and from which you want to access Remote Web Workplace.

      4. In Windows Explorer, navigate to where you copied Install Certificate Package.zip, right-click Install Certificate Package.zip, and then click Extract All.

      5. Open the folder where the extracted files are located, and then double-click InstallCertificate.

      6. Select Install the certificate on my computer, and then click Install.

      7. Browse to the Remote Web Access website.

Note

Download the certificate installer package only from a computer that is directly connected to your organization's network. Do not download this package over the Internet.

  1. Mark the setup as successful:

    1. Click Start, in Start Search, type regedit, and then press ENTER.

    2. In Regedit, navigate to HKEY_LOCAL_MACHINE\Software\Microsoft\SmallBusinessServer\Components.

    3. Double-click CompanyWeb, change Value Data to 1, and then click OK.