February 27, 2007 at 6:32 am
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.
February 27, 2007 at 7:44 am
Yes it will. However one of the best practices states that it is best to set the DB file size to the max size you think it will ever need. Or let's say the size of the db 1 year from now. Then reevaluate the size 11 months from that point. That way the db won't auto-grow which will eventually cause a file fragmentation on the drive.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply