Event ID 5762 (Windows SharePoint Services health model)

Applies To: Windows SharePoint Services 3.0

 

Warning

Windows SharePoint Services 3.0 uses SQL Server databases to store most of the content for the Web site and configuration settings. For example, all pages in the site, files in document libraries, files attached to lists, and information in lists are stored in the content database, and security and permission settings along with other configuration settings are stored in the configuration database in SQL Server.

Windows SharePoint Services 3.0 uses a service account to communicate with the database on behalf of a user request. This service account can be either a specific user name and password (domain name and password) or a predefined system account, such as Local System or Network Service. When a SQL Server database is created, a value for the maximum database size is set. Each database has a separate database size setting. Note that a Web application might be associated with one or many databases.

Event Details

Product:

Windows SharePoint Services

ID:

5762

Source:

Windows SharePoint Services 3

Version:

12.0

Symbolic Name:

ULSEvtTag_5762

Message:

Duplicate unique index on SQL Server instance '%1' in database '%2'. Additional error information from SQL Server is included below.

%3

Resolve

Restore database from backup

The SQL Server database is not present or accessible on the computer running SQL Server. Confirm that the database is online. If it is not, you will need restore the database from a backup, and re-connect it to Windows SharePoint Services 3.0. For information about restoring the database see the Windows SharePoint Services 3.0 documentation.

You must be a member of the SharePoint Administrators group to perform these tasks.

To restore the database from a previous backup

  1. In Central Administration, on the left navigation pane, click Operations.

  2. On the Operations page, in the Backup and Restore section, click Restore from backup.

  3. On the Restore from Backup page, type the backup share path in the Backup location box, and then click OK.

  4. Select the backup from the list.

    Important

    The backup must be of at least the database and the accompanying Web application.

  5. Click Continue Restore Process.

  6. Select the check box next to the database and click Continue Restore Process.

  7. Under Restore Options, select the Same configuration option. This will overwrite the existing database.

  8. Click OK.

To reconnect the database in Central Administration

  1. In Central Administration, on the left navigation pane, click Application Management.

  2. On the Application Management page, in the SharePoint Web Application Management section, click Content databases.

  3. On the Manage Content Databases page, click Add a content database.

  4. On the Add Content Database page, in the Web Application section, select the Web application from the Web application drop-down list.

  5. Under Database Name and Authentication, type the name of the server in the Database Server box and the database name in the Database Name box.

  6. Click OK to save the changes.

Verify

You must be a member of the SharePoint Administrators group to perform this task.

To ensure that any database issues have been resolved

  1. Use the command Stsadm.exe -o enumsites to list the sites for each Web application to list all sites in the various databases, and locate one site in each database.

  2. Browse to that site, and ensure that the appropriate page rendered. If you get an access denied page with an option to request access, or the option to sign in as a different user, the operation completed successfully.

  3. In Central Administration, on the left-hand navigation pane, click Application Management.

  4. On the Application Management page, in the SharePoint Site Management section, click Quota templates.

  5. On the Quota Templates page, create a new quota template. The specific settings are not relevant to this verification test. You are creating the template to see if it can be accessed in step 7.

  6. Click OK to save the quota template.

  7. Refresh the browser window, and then return to the quota templates page. If the quota template that you created can be selected, then access to the Windows SharePoint Services 3.0 Configuration database has been restored.

  8. Click Delete to delete the quota template.

Databases (Health model)

Windows SharePoint Services 3.0 health model