none
Windows SharePoint Services v3.0 Database Error

    Question

  • Hi Below is the error from event viewer on the server based on the Above

    Event Type:     Error

    Event Source:  Windows SharePoint Services 3

    Event Category:          Database

    Event ID:         3758

    Date:               3/18/2009

    Time:               4:38:40 PM

    User:                N/A

    Computer:       FIB-PORTAL

    Description:

    Database full error on SQL Server instance 'FIB-PORTAL\OfficeServers' in database 'WSS_Content'. Additional error information from SQL Server is included below.

     

    Could not allocate space for object 'dbo.EventCache'.'EventCache_Id' in database 'WSS_Content' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

     

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

     

    Event Type:     Error

    Event Source:  MSSQL$OFFICESERVERS

    Event Category:          (2)

    Event ID:         1827

    Date:               3/18/2009

    Time:               4:38:40 PM

    User:                FIRSTINLAND\sharepointadmin

    Computer:       FIB-PORTAL

    Description:

    CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database.

    Any ideas on the Solution to the Above Issue...

    Best Regards,

    Adeoye...

    Wednesday, March 18, 2009 3:51 PM

Answers

  • Are you really using WSS 3.0 and not MOSS 2007 ?

    The reason I ask is because the database system installed by the Basic Installation of WSS 3.0 ("Windows Internal Database") does NOT have the 4GB limit. But the  database system installed by the Basic Installation of MOSS 2007 does  have the 4GB limit.

    The only way you could with WSS 3.0 have a 4GB limit would be - as Lu Zou wrote - if you had installed the downloadable SQL Server 2005 Express and then used the WSS 3.0 Advanced Installation to say that WSS 3.0 should use that. This is a very unusual way to do things ...

    If you have MOSS 2007, your only alternative is to use SQL Server 2005 or 2008 full editions.

    If you have WSS 3.0 and you are happy to use only one server for everything then you should install again and run the Basic installation. That will give you an (empty) database that is unlimited in size.

    If you want WSS 3.0 with the db system on a separate server, again, only full SQL Server 2005 or 2008 is possible.

    WSS FAQ sites: WSS 2.0: http://wssv2faq.mindsharp.com WSS 3.0 and MOSS 2007: http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 and MOSS 2007 Books (including foreign language titles) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/V%20Books.aspx
    • Marked as answer by Lu Zou-MSFT Friday, March 27, 2009 9:38 AM
    Friday, March 20, 2009 8:17 AM
  •  

    Hi

     

    It is possible to move all the databases on a stand-alone installation running SQL Server express to another server running full version of SQL Server. The steps are not quite complicated, however you need to pay attention to the operation as it will be done manually. Before you try this migration of database on your production environment, I strongly suggest you try all the operations on a test environment. What's more,  to avoid any data loss please backup your database before you do the migration.

     

    The article below gave the detailed steps of database migration:


    http://technet.microsoft.com/en-us/library/cc287634.aspx
    http://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-and-configuration-databases/

     

    Hope this helps

     

    Lu Zou

    • Marked as answer by Lu Zou-MSFT Friday, March 27, 2009 9:38 AM
    Monday, March 23, 2009 1:45 AM

All replies

  •  

    Hi,

     

    It seems that you are using SQL Server 2005 Express. As 4GB is the maximum database size in SQL Server 2005 Express Edition, as a workaround you need to shrink the database to reduce the file. Please refer to the document below:

    How to: Shrink a File (SQL Server Management Studio)
    http://msdn2.microsoft.com/en-us/library/ms190757.aspx

    For more reference, please refer to:

    SQL Server 2005 Express Edition Features
    http://www.microsoft.com/sql/editions/express/features.mspx

     

    Hope this helps.

     

    Lu Zou

     

    Friday, March 20, 2009 7:29 AM
  • Thanks

    Do i need to upgade the database to Enterprise/Standard Editions Then

    Regards,

    Adeoye...
    Friday, March 20, 2009 7:53 AM
  • Are you really using WSS 3.0 and not MOSS 2007 ?

    The reason I ask is because the database system installed by the Basic Installation of WSS 3.0 ("Windows Internal Database") does NOT have the 4GB limit. But the  database system installed by the Basic Installation of MOSS 2007 does  have the 4GB limit.

    The only way you could with WSS 3.0 have a 4GB limit would be - as Lu Zou wrote - if you had installed the downloadable SQL Server 2005 Express and then used the WSS 3.0 Advanced Installation to say that WSS 3.0 should use that. This is a very unusual way to do things ...

    If you have MOSS 2007, your only alternative is to use SQL Server 2005 or 2008 full editions.

    If you have WSS 3.0 and you are happy to use only one server for everything then you should install again and run the Basic installation. That will give you an (empty) database that is unlimited in size.

    If you want WSS 3.0 with the db system on a separate server, again, only full SQL Server 2005 or 2008 is possible.

    WSS FAQ sites: WSS 2.0: http://wssv2faq.mindsharp.com WSS 3.0 and MOSS 2007: http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 and MOSS 2007 Books (including foreign language titles) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/V%20Books.aspx
    • Marked as answer by Lu Zou-MSFT Friday, March 27, 2009 9:38 AM
    Friday, March 20, 2009 8:17 AM
  • Hi,

    Is is possible to move all the databases on a stand-alone installation(sharepoint) running sql server express to another server running full version of SQL Server

    If it is

    How do i achieve this
    Friday, March 20, 2009 12:41 PM
  •  

    Hi

     

    It is possible to move all the databases on a stand-alone installation running SQL Server express to another server running full version of SQL Server. The steps are not quite complicated, however you need to pay attention to the operation as it will be done manually. Before you try this migration of database on your production environment, I strongly suggest you try all the operations on a test environment. What's more,  to avoid any data loss please backup your database before you do the migration.

     

    The article below gave the detailed steps of database migration:


    http://technet.microsoft.com/en-us/library/cc287634.aspx
    http://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-and-configuration-databases/

     

    Hope this helps

     

    Lu Zou

    • Marked as answer by Lu Zou-MSFT Friday, March 27, 2009 9:38 AM
    Monday, March 23, 2009 1:45 AM
  • Thanks

    I'll give it a try!!!

    Is It Possible to Uninstall the SQL Server Express Version that came with a stand-alone installation after migrating the databases to another Server on the network running Full Version of SQL Server 2005

    Best Regards,

    Adeoye..
    Friday, March 27, 2009 2:39 PM
  • Hi How do i move all databases sitting on sql server express to another server running SQL Server enterprise edition database
    Friday, April 24, 2009 11:17 AM
  • Hi,

    is it possible to move a MOSS 2007 stand-alone express database installation to another server running sql server 2005 enterprise/standard 

    Regards,

    Adeoye... 
    Monday, May 04, 2009 3:47 PM
  • Did you ever get this problem sorted?

    I have the exact same problem, where I am using MOSS 2007 and the databse has reached the 4096 size-limit and I can't write any further information to it.

    Can this database be moved to a server with a full version of SQL 2005 and connected to MOSS 2007?

    It seems to be a terrible drawback in Sharepoint 2007.

    Regards,

    Dan
    Tuesday, May 19, 2009 3:25 PM
  • Hi i have also same problem, and i have backup some database and deleted unwanted database.now the database size is 2GB only (D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data).

    but the error is again and again coming. the following error is

    1. CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database

    2. Database full error on SQL Server instance 'mps\OfficeServers' in database 'WSS_Content'. Additional error information from SQL Server is included below.
    Could not allocate space for object 'dbo.EventCache'.'EventCache_Id' in database 'WSS_Content' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

    How to resolve this?Thanks in advance,Vel
    Friday, July 02, 2010 7:08 AM
  • Hi,
     
    We are using sharepoint server 2007 and if i create any files and folders the sharepoint site is throwing some error "Exception from HRESULT: 0x80040E14"
     
    and i checked event viewer.here also some error showing "
     
    1. CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database
     
    2. Database full error on SQL Server instance 'mps\OfficeServers' in database 'WSS_Content'. Additional error information from SQL Server is included below.
    Could not allocate space for object 'dbo.EventCache'.'EventCache_Id' in database 'WSS_Content' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
    i have backup some database and deleted unwanted database.now the database size is 2GB only (D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data).

    http://social.technet.microsoft.com/Forums/en/sharepointadmin/thread/9b3259cc-2bf6-4127-bd57-df3b866f6d8f
     
    i have shrink the database also using below the URL

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

    But the 4GB error is again and again coming. 

    How to resolve this?Thanks in advance,Velmurugan
    Sunday, July 04, 2010 1:22 PM
  • Seriously! How can I take down an entire SharePoint site by simply copying files to it? SharePoint 2007 has been out for over 3 years and there is no solution? If they are going to put in a hard limit because they want more $, can they at least provide a solution if we go over our hard limit?
    Friday, August 20, 2010 1:06 AM
  • In conclusion,

    Stand-alone Installation of MOSS is not recommended in an enterprise sharepoint deployment.

    Basically can be used for Poc only. SQL Server express has a 4GB database size limit and u it does not have analysis & reporting services

     

    So, this is not a best practice deployment reccommendation by Microsoft

     

    Thanks

    Tuesday, August 31, 2010 5:39 PM