Monday, March 16, 2009

Sharepoint 2003 on MSDE

-----------------------------------------------------

CASE RESOLUTION AGREEMENT:

-----------------------------------------------------

- We are trying to upload multiple documents on the document library of the SharePoint site .

- It is failing with an error – “Form Validation error. The web server is too busy. Please try again”

- This issue is happening with this site only.

- Once we will be able to successfully upload multiple documents to this SharePoint site, we should consider this case as resolved/closed.

-----------------------------------------------------

CURRENT ACTION PLAN:

-----------------------------------------------------

- We have found that we are using SQL MSDE database with SharePoint.

- MSDE database has a limit of 2 GB as per http://msdn.microsoft.com/en-us/library/ms811304.aspx.

- It also mentions the statement – “Applications may grow beyond the MSDE 2000 2-GB data limit or the application's user base may grow beyond the workload limitation in SQL Server Desktop Engine. If this occurs, Microsoft recommends migrating the MSDE 2000 solution to a SQL Server based solution. SQL Server 2000 Desktop Engine (MSDE 2000) can be upgraded to SQL Server 2000 Personal and Standard Editions”

- We confirmed that we have crossed the 2 GB limit for the database.

- We also confirmed that the SITE database upgraded successfully to the proper level.

- We will migrate the databases to Microsoft SQL server tomorrow at 09:00 P PST.

----------------------------------------------------

Important Articles

----------------------------------------------------

SQL MSDE has 2 GB limit

http://msdn.microsoft.com/en-us/library/ms811304.aspx

http://support.microsoft.com/kb/324992

How to move SharePoint Portal Server 2003 from SQL MSDE databases to Microsoft SQL Server

http://support.microsoft.com/kb/837848

http://support.microsoft.com/kb/894164/en-us

No comments:

Post a Comment