July 15, 2010 at 2:58 pm
We have SQL Server 2005 (SP3) EE 64-Bit running on Windows Server 2003 (64-Bit). We have a 3 GB DB that is showing zero MB for Space Available in the Database Properties Page. How may I add some space to the Database. There is a lot of space on the disk drive. I do not see a need to add another data file.
Thanks in advance, Kevin
July 15, 2010 at 3:03 pm
If auto grow is not turned on, then you need to add space to the existing data file.
The easy way is turn auto grow on.
July 15, 2010 at 4:23 pm
Use the Alter database modify file command (see BOL) or you can use the GUI, right click on the database, select properties, go to the files and just overwrite the size with the new higher size you want it to be. Do this at a quite time and back your database up first.
If you turn autogrow on set the growth factors to something sensible (not the default 1MB). For a 3GB database say 50MB.
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply