September 3, 2007 at 10:30 am
Hi Experts,
Today,I have faced a new problem. How to solve this problem ?
------------------------------------------------------------------------Server: Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object 'AcctEntry1' in database 'ICASE' because the 'PRIMARY' filegroup is full.
-------------------------------------------------------------------------
Inputs are Welcome !
Regards
Karthik
karthik
September 3, 2007 at 12:00 pm
In Management Studio right click on the database and go to files click on Primary and increase the size and you may want to adjust the percent of auto file growth. If you are in 2000 these are in the Taskpad which is context sensitive so your database must be open before you click on Taskpad and you can adjust your file sizes. If you are DBA of production server you have to spend time with this wizard so you will not run out of space because it is not practical to expect SQL Server to manage your files for you. Hope this helps.
Kind regards,
Gift Peddie
September 4, 2007 at 12:30 am
Giff,
I am using Sqlserver2000. I have only DBO access not DBA access permission. I dont have Management Studio , i am having Enterprise Manager in my PC.
How to handle those types of error ?
Regards
Karthik
karthik
September 4, 2007 at 1:09 am
If you don't have DBA permissions, you should contact someone who has.
Also, you can consider dropping some old tables you don't need, or at least deleting unneeded rows. This could especially help if you are working in a testing DB... in production you have to be very careful about dropping objects and deleting data.
Enterprise Manager and Management Studio is basically the same - a utility to manage servers and databases, one for 2000 and one for 2005. If you have SQLS 2000, then Enterprise Manager is what you should use. How, that has been already described by Gift.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply