October 12, 2009 at 8:35 am
Hey everyone,
I always see the forums stating that you should never allow the database to auto grow. Rather you should grow it yourself.
My question is how do you grow it yourself?
I finally have a database that it matters on and I can't seem to find the documenation on how to do this.
Thanks,
Fraggle
October 12, 2009 at 8:39 am
change the file sizes in the database properties in SSMS, or you can use the ALTER DATABASE command (http://msdn.microsoft.com/en-us/library/aa275464%28SQL.80%29.aspx) modify the file size.
October 12, 2009 at 8:41 am
Really? So I all have to do is to increase the file size and it will automatically do it?
Wow, if that is the case, that was significantly easier than I thought it would be.
Fraggle
October 12, 2009 at 8:43 am
ALTER DATABASE [DatabaseName] MODIFY FILE ( NAME = N'databasefilename', SIZE = 3072000KB )
just an example if you dont do it though the GUI
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 12, 2009 at 8:48 am
Yes, that's all you do. Monitor the size and free space, and keep enough space to last you 3-6 months. Increase it in one large chunk for the next 3-6 months.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply