Increasing the size of an existing database

[web4fun]

For SQL Server 2005, what is the preferred method for increasing the size of a database; i.e. we currently have allocated 20GB for some databases, but we misallocated and should have set the initial size to 50GB for each database, we are trying to mitigate performance problems involving automatic growth and thus we want to get the initial sizes correct. Some of the databases are currently being accessed while others are not as we are in the testing phase of our applications. I assume whichever method I use, will require some downtime.

Thanks in advance. Apologies if this is too trivial.

 

[ptheriault]

There is no down time required at all. Just select database properties from SSMS and set the size on the db files page.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[web4fun]

Thanks Paul, I saw that in SSMS but didn't know if it could be done while the dbs were online.

Thanks again.

 

[ptheriault]

yup. It will cause a dip in performance but you don't have to kick out your users.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[web4fun]

Thanks again Paul