[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 737
  • Last Modified:

Microsoft sql server

Hi Experts,
could not allocate space for object 'sys.sysobjvalues'.'clst'
Could not allocate space for object 'cnv.LoggedUnpreparedSpos'.'PK_LoggedUnpreparedSpos' in database 'travelgateway' 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.

There is enough space and i have put on unrestricted growth.
Could you please help.
0
Sandeepiii
Asked:
Sandeepiii
  • 2
  • 2
1 Solution
 
Kent DyerCommented:
First thing you are going to want to do is get some monitoring in place..  Even a simple VBScript can do this with an SMTP mailer.

Next, you are going to have to probably bring up a second box with SQL Server installed.  Do a restore from say two days ago..  Change your growth from unrestricted to say 10%.  Clear out records that you don't need - archive like log tables off.  Take the time to clean up whitespace..

Then, point your app to the new SQL Box or change it's IP to the old IP..

This should get you going..

Good luck!

HTH,

Kent
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
if this is a sql server express edition, despite having set "unlimited growth" and "plenty of disk space", there IS a max size limit to your database(s).
please double-check your edition and the limits with it...
0
 
SandeepiiiAuthor Commented:
Thanks ,this is enterprise edition 64bit.The database size is 141046.00 MB
unallocated size is :40210.03 MB.There are lots of space on the drive still the error comes ..
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
how many data files in the primary filegroup?
what sizes are they?
0
 
SandeepiiiAuthor Commented:
Answer was precise.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now