suppose we allocated 4 GB to a database and 3.5 GB is given to datafile and .5 GB is given to log file...and due to the increase in the database size we end up being eaten up all the space and only 1 mb is remaing left over in the allocated space that we can increase the database data file size to be...in this scenario how can we handle the situation...and also the total is 5 GB on the drive where the data file resides in the server...

 both for sql 2005 and sql2000

please help me out with this situation...

Hi

I take it you have either switched off the autogrowth for both data and log, or missed this feature when creating the database.  Anyway at any time you can change the size  of the data and log files manually.  Failing that you can add new data/log files to the database.  These data/log files can even be on another hard disk on the same server, as long as they are installed in the same file group you should not have to change any of the existing schema.

Regards

Richard...

You have to get more disk or move data file to other disk.

Hi,

You have to analyse and foresee the growth of the database for the next 5 years (atleast) and based on that you have to keep hard disk space available for database.  When you configure database growth option its always recommended that you set it for fix mb refer http://www.extremeexperts.com/SQL/Articles/AutoGrowth.aspx

Coming to the growth of the T-Log file, here is a link you can refer http://technet.microsoft.com/en-us/library/ms365418.aspx and http://hemantgirisgoswami.blogspot.com/2006/03/cause-for-t-log-become-full-and-how-to.html

hth

 too...........

 Also, take into account autogrow of tempdb database.

Although it is initialized at startup of the server , it may reach large size (or out of space), based on the activities on your server.

You must add extra storage for your server , move log file to other storage.