increasing the size of a database of SQL 2005

[steelcoyot]

Anyone know how to safely increase the size of a database. One option I have is to create a new larger database but want to see if there are other options out there.

 

[onpnt]

Not sure why you would change the size of the database. You should simply manage the growth of it.

You can use the ALTER DATABASE statement to alter the growth of the database or right click the db in studio management and select properties-->Files and alter the growth range there.



_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}

 

[steelcoyot]

Going to the properties of the database and increasing the size there is what I did. The reason I had to do this was that Sharepoint Services created the database at a defualt size of 10 megs.

 

[mrdenny]

Don't forget to change the growth rate from 10% to something more realistic.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com