Export (0) Print
Expand All

Recreate your SharePoint Foundation 2010 application and content database

Published: March 10, 2011

Updated: May 26, 2011

Applies To: Windows Small Business Server 2011 Standard

noteNote
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 http://companyweb -filename companyweb.bak –includeusersecurity, and then press ENTER.

    noteNote
    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.

  4. 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.

    noteNote
    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

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

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

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

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

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

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

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

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

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

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

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

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

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

  30. 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.

      noteNote
      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.

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

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

  7. Click OK.

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

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

  10. Type the following commands to restore companyweb:

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

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

    3. Type A.

  11. Try to access http://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.

CautionCaution
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 http://computername and http://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 http://<ComputerName>, where <ComputerName> is the host name of the server, and then click Add.

    5. Type http://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 http://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 http://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:

    noteNote
    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:

      noteNote
      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.

  16. 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 http://Sites/webhelp/webhelp.html.

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

    3. Click Save.

  17. 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 http://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.

  18. 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 http://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.

        noteNote
        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.

  19. 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft