hi, I have one DB in SQL Server 2005.When I was creating it takes 7813 MB.Now the databse size almost full.Now I want to extend the DB Size.At my HDD has more space(near by 160 GB).But I don't know how to extend the Size.More over I had one doubt.Am executing the exec sp_helpdb command.It shows the Datafile maxsize is Unlimited.I want to know when the data is full,whether it automatically takes the size from the HDD or not. Please Help me out to this Problem.

When it reaches the maximum capacity, it will be increased automatically. Check whether the Autogrowth enabled or not.

check this sp_helpdb this give the information of the database size dbcc sqlperf(logspace) this give the log (ldf) file size of the databases, if ldf file has huge size then check the recovey model of the database using the below query select name,recovery_model_desc from sys.databases is the database is in FULL REcovery mode . then set the database in SIMPLE recovery mode using USE [master] GO ALTER DATABASE [dbname] SET RECOVERY SIMPLE WITH NO_WAIT GO in the above same dbname is the sample database name used by me. by default when u set UNlimited file growth ,database increases its size