Solved

Sharepoint and MS SQL Services Error

Posted on 2008-10-29
6
1,328 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
  • 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
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Join & Write a Comment

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now