Friday, March 23, 2012

How to Increase the DB Size

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.sql

No comments:

Post a Comment