Depending on how you do things, I would expect a 900 meg data file to have less than 100 meg of log file. In fact, your data file is only 900 megs.
I see that your log file is nearly as big as your data file. Tell them that if they cannot do this, you will begin looking at other host providers. Tell them you want more storage space and you don't want to pay any more money for it. I would encourage you to call your 'host'. Storage space is dirt cheap so having such a small limit does not make sense. I see some things that may be your problem.įirst, let me say that having a 2GB limit is ridiculous. ~S~ RE: Could not allocate space for object gmmastros (Programmer) 11 Nov 14 08:23 So basically I need to know how to increase the allowed size for this table/index (through script and bearing in mind my access is completely locked down) or if this really is a disk-size restriction is there a way of reducing the size of my table.?Īny help or advice appreciated but please try to keep it simple as I'm fairly new to SQL Server Configuration! I've tried recreating the table (and index) from scratch and dropping the old one. Rows: 108600 (this is where it stops out of the 640000) Now, the weird thing is that the XX_Import table is actually one of the smaller tables really and there are History tables that take up much more space.Ģ x BIGINT fields (required as numeric data for these columns is often greater than 4bn) 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. It is whilst I'm importing this table I'm getting the error:Ĭould not allocate space for object 'dbo.PK_XX_Imp_xxxxxxxx' in database 'MyDB' because the 'PRIMARY' filegroup is full. I have an import routine which simply dumps around 640k rows into an "import" table for the rest of the routine to manipulate before truncating the table for the next import. There is a size restriction on the DB of 2GB - currently my DB stands at 1500 MB. I have a 'hosted' MS SQL Server (meaning I can't access the DB directly in Management Studio, I use RazorSQL and/or MyLittleAdmin). Hoping someone may be able to help me out as I'm stumped with this one.
0 kommentar(er)
