Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  MSDE (2000)  msde db & log limitations

Author  Topic  Hernan Starting Member 2 Posts Posted - 2003-01-29 : 01:42:38 sorry to bore you with this newbie question but... Got an app at work that uses a sql 7.0 db using MSDE. The app is erroring out "Could not allocate space for object 'mytable' in db 'mydb' because the PRIMARY fileqroup is full." Was told by vendor that incoming data was not written to T-log due to 2GB db limitation. But they did write the unlogged transactions to a text file and will require custom programming ($$$) to transfer back to db. Here's the facts: Windows is reporting the file size of the MDF file to be 1,915MB. MDF is in PRIMARY filegroup, maxsize=unlimited, usage=data only. LDF is in NULL fileqroup, maxsize=unlimited, usage=log only. I ended up using the built-in purge in the app. After the purge, i looked at the file sizes and the MDF stayed the same while the LDF file grew to 2.1GB. Would I be correct to assume that if the log file logged all the DELETE transaction from the purge and grew to 2.1G, shouldn't the T-Log file log all the INSERTS and all I had to do then was clear up some space in the db and the INSERTS would have been written to the db? TIA