Solved

Sharepoint and MS SQL Services Error

Posted on 2008-10-29
6
1,337 Views
Last Modified: 2008-12-06
We have Microsoft Sharepoint Services running on a Windows 2003 SP 2 server with 80 gb c partition and a 800 gb D partition.  We are getting the following error in the application event log.  We are not able to upload any additional documents to our Sharepoint Services sites.

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

Followed by the error
Database full error on SQL Server instance 'STARSTREAM\OfficeServers' in database 'WSS_CONTENT_F07383FF-A588-4988-A7F4-EF67A774BC62'. Additional error information from SQL Server is included below.

Could not allocate space for object 'dbo.AllDocStreams'.'AllDocStreams_CK' in database 'WSS_Content_f07383ff-a588-4988-a7f4-ef67a774bc62' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the

Here are the software versions on our server

Microsoft SQL Server Management Studio                                    9.00.3042.00
Microsoft Analysis Services Client Tools                                    2005.090.3042.00
Microsoft Data Access Components (MDAC)                                    2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML                                    2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer                                    7.0.5730.13
Microsoft .NET Framework                                    2.0.50727.1433
Operating System                                    5.2.3790

I can see the file sizes indicated in the event logs in the management studio.  I have also set the autogrowth on the WSS_content database described in the second event error.  However, we are still getting the error message after rebooting the server to apply the autogrowth configuration.
0
Comment
Question by:PeterfromDenmark
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 25

Accepted Solution

by:
Robbie_Leggett earned 500 total points
ID: 22833275
Is this SQL 2005 Express? If so there is a 4GB limit on the DB size, no matter what the autogrowth is set to.
 
:-)
0
 
LVL 25

Expert Comment

by:Robbie_Leggett
ID: 22833288
I suggest purchasing a full version of SQL, then moving the db's to the new instance.
 
:-)
0
 
LVL 4

Expert Comment

by:sunilrepale
ID: 22836128
hello
SQL 2005 has the the databasesize limitation of 4Gb using , migrate to full version of SQL 2005

http://www.microsoft.com/technet/prodtechnol/sql/70/proddocs/diag/part3/75528c12.mspx?mfr=true 
http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx 
0
 
LVL 25

Expert Comment

by:Robbie_Leggett
ID: 23068970
sunilrepale repeated the answer I gave, I therefore don't understand the split??
 
:-)
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question