Database Size is not Expanding

Question

Post reply

Database Size is not Expanding

dstyles

Old Hand

Points: 391
More actions
August 24, 2011 at 6:25 am

#256074

I have a DB that is presently 4gb and it says in the proerties that the spce available is only 20MB so I cannot add anything else to it. The poerties of the DB have been set to autogrow and by 1000MB at a time. Why is the space not being allocated. I have 1TB of space free too.

Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

You mean that if you add data it fails because of "Could not allocate a new page for database" error?

-- Gianluca Sartori

dstyles Old Hand Points: 391 More actions · Answer 2

I am trying to add data to my Share Point server and I get the following error.

Database full error on SQL Server instance 'SHAREPOINT\SharePoint' in database 'WSS_Content_81dba106-e5f6-4ba5-8660-cc6099ecc80f'. Additional error information from SQL Server is included below. Could not allocate space for object 'dbo.AllDocStreams'.'AllDocStreams_CI' in database 'WSS_Content_81dba106-e5f6-4ba5-8660-cc6099ecc80f' 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.

The issue with this is that I have loads of space on the drive.

I have loads of disk space. SQL 2008 R2

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

select @@version

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 4

dstyles (8/24/2011)
I am trying to add data to my Share Point server and I get the following error.
Database full error on SQL Server instance 'SHAREPOINT\SharePoint' in database 'WSS_Content_81dba106-e5f6-4ba5-8660-cc6099ecc80f'. Additional error information from SQL Server is included below. Could not allocate space for object 'dbo.AllDocStreams'.'AllDocStreams_CI' in database 'WSS_Content_81dba106-e5f6-4ba5-8660-cc6099ecc80f' 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.
The issue with this is that I have loads of space on the drive.
I have loads of disk space. SQL 2008 R2

What happens when you try to increase the size of the Data File?

My blog

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 5

dstyles (8/24/2011)
I have a DB that is presently 4gb and it says in the proerties that the spce available is only 20MB so I cannot add anything else to it. The poerties of the DB have been set to autogrow and by 1000MB at a time. Why is the space not being allocated. I have 1TB of space free too.

Are you using unrestricted File growth for the data file?

My blog

dstyles Old Hand Points: 391 More actions · Answer 6

dstyles

Old Hand

Points: 391

August 24, 2011 at 7:03 am

#1372523

Here are two screen shot for you

dstyles Old Hand Points: 391 More actions · Answer 7

How do I increase the DB size I thought it would do it automatically

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

GilaMonster (8/24/2011)
select @@version

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

dstyles Old Hand Points: 391 More actions · Answer 9

dstyles

Old Hand

Points: 391

August 24, 2011 at 7:15 am

#1372533

What are you asking?

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 10

dstyles (8/24/2011)
Here are two screen shot for you

You have indeed set it to unrestricted. To increase the size follow these steps . Good luck! 🙂

My blog

dstyles Old Hand Points: 391 More actions · Answer 11

I ran your querry

I have both installed but the DB I am working with is using the first one.

Bex SSCrazy Points: 2437 More actions · Answer 12

4gb limit on Express edition (changed in 2008 R2)

dstyles Old Hand Points: 391 More actions · Answer 13

Here is what I get. How do I move it from SQL express then.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 14

Exactly what I thought...

You have Express edition, the free edition of SQL. Databases are limited to 4GB in SQL Express 2008 and 10GB in SQL Express 2008 R2.

You're probably going to need to buy a licence for a higher edition of SQL, one that doesn't have a size limit.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass