Help and Support
 

powered byLive Search

Support for changes to the databases that are used by Office server products and by Windows SharePoint Services

Article ID:841057
Last Review:June 19, 2008
Revision:8.0

INTRODUCTION

The Microsoft Office server products that are listed in the "Applies to" section store data in Microsoft SQL Server databases. These products use various stored procedures for regular processing. Therefore, the Microsoft SQL Server databases are important to the successful operation of these products.

Back to the top

MORE INFORMATION

The products that are listed in the "Applies to" section were tested by using the existing structure and were approved for release based on that structure. Unless Microsoft protocol documentation is followed precisely, Microsoft cannot reliably predict the effect to the typical operation of these products when parties other than Microsoft support change the database or run stored procedures. Parties other than Microsoft support would include, but not be limited to, changes that are made by customers, by third-party vendors, or by consultants.

Examples of such database changes include, but are not limited to, the following:
Adding database triggers
Adding new indexes or changing existing indexes within tables
Adding, changing, or deleting any primary or foreign key relationships
Changing or deleting existing stored procedures
Adding new stored procedures
Adding, changing, or deleting any data in any table of any of the databases for the products that are listed in the "Applies to" section unless Microsoft protocol documentation is followed exactly
Adding, changing, or deleting any columns in any table of any of the databases for the products that are listed in the "Applies to" section
Making any modification to the database schema
Adding tables to any of the databases for the products that are listed in the "Applies to" section
If an unsupported database modification is discovered during a support call, the customer must perform one of the following procedures:
Perform a database restoration from the last known good backup that did not include the database modifications
Roll back all the database modifications
If a good backup that does not include the database modifications does not exist, or if the customer is unable to roll back the database modifications, the customer must recover the data manually. The customer must do this before the customer opens a disaster recovery case to obtain help to migrate any recovered data to a new, unmodified database to return to a supportable database environment.

If it is determined that a database change is necessary, a support case should be opened to determine whether a product defect exists and should be addressed. In rare circumstances and during a support incident, support may provide customers with a script that makes modifications to the databases that are used by the products that are listed in the "Applies to" section. In these cases, all modifications are reviewed by the development team to make sure that the operations being performed will not result in an unstable or unsupported database state.

Database changes that are made with the guidance of support during a support incident will not result in an unsupported database state. However, these support-guided actions do not negate the previous statements about customer modifications to these databases.

Additionally, customers must not make support-guided changes outside a support incident or provide such changes to other customers for use outside a support incident. In addition to the items previously mentioned, customers are strongly advised against direct access in a read-only manner to these databases unless Microsoft protocol documentation is followed exactly. Accessing these databases programmatically or manually could cause unexpected locking within Microsoft SQL Server that can result in overall performance problems. To view the SharePoint Products and Technologies protocol documentation, visit the following Microsoft Web site:
http://go.microsoft.com/fwlink/?LinkID=119903 (http://go.microsoft.com/fwlink/?LinkID=119903)
This documentation is intended to facilitate the development of solutions that implement the described protocols. These implementations should be thoroughly tested before deployment on production Microsoft Office SharePoint Server systems.

Developers are encouraged to use the Open Protocol forums to address issues about the documentation that occur during implementation. To view the Open Protocol forums, visit the following Microsoft Web site:
http://go.microsoft.com/fwlink/?LinkId=115477 (http://go.microsoft.com/fwlink/?LinkId=115477)
We recommend opening a paid support case if one the following is true:
There is a concern that a particular use of the protocols does not follow the guidelines.
The guidelines are not clear, and additional clarification is needed to make sure of supportability.
For more information about how to open a paid support case, visit the following Microsoft Web site:
http://support.microsoft.com/?LN=en-us&scid=fh%3Ben-us%3Bofferprophone&x=11&y=9 (http://support.microsoft.com/?ln=en-us&scid=fh%3ben-us%3bofferprophone&x=11&y=9)
Unrecoverable data loss or corruption of data can occur when database operations that are described in the documentation are used outside a tested protocol implementation. Administrators of production SharePoint systems are encouraged to test any back-end protocol implementations thoroughly before using these protocols on important data.

Back to the top

REFERENCES

For more information about support for changes to the databases that are used by Microsoft Office server products and by Windows SharePoint Services, click the following article numbers to view the articles in the Microsoft Knowledge Base:
932744 (http://support.microsoft.com/kb/932744/) Information about the Maintenance Plan Wizard in SQL Server 2005 and about tasks that administrators can perform against SharePoint databases
930887 (http://support.microsoft.com/kb/930887/) You experience issues with portal alerts in SharePoint Portal Server 2003 or with search performance in SharePoint Server 2007 after you create SQL Server 2005 maintenance plans

Back to the top


APPLIES TO
Microsoft Windows SharePoint Services 2.0
Microsoft Windows SharePoint Services 3.0
Microsoft Office SharePoint Portal Server 2003
Microsoft Office SharePoint Server 2007
Microsoft Office Forms Server 2007
Microsoft Office Groove Server 2007
Microsoft Content Management Server 2001 Enterprise Edition
Microsoft Content Management Server 2002

Back to the top

Keywords: 
kbinfo KB841057

Back to the top

Article Translations

 

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.