<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
allocate space
allocate space
Rate Topic
Display Mode
Topic Options
Author
Message
bellw
bellw
Posted Saturday, January 16, 2010 6:56 AM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, January 17, 2010 12:46 PM
Points: 9,
Visits: 12
How do i increase the size of space that the database can use after it runs out of the initial space.
Post #848726
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Saturday, January 16, 2010 9:55 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 6:14 PM
Points: 31,421,
Visits: 13,734
You can use the ALTER DATABASE command or right click the database, choose properties, change the file sizes.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #848745
Ninja's_RGR'us
Ninja's_RGR'us
Posted Saturday, January 16, 2010 10:32 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 6:43 PM
Points: 21,357,
Visits: 9,536
Are you also running out of space on the HD?.. or just in the DB file with error messages cropping up when trying to change some data?
Post #848752
bellw
bellw
Posted Sunday, January 17, 2010 5:15 AM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, January 17, 2010 12:46 PM
Points: 9,
Visits: 12
Not running out of space on HD. Just want to allocate a larger chunk when the database uses all it's alolcated space.
Post #848854
bellw
bellw
Posted Sunday, January 17, 2010 5:23 AM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, January 17, 2010 12:46 PM
Points: 9,
Visits: 12
I want to increase the free space allocation. Whne I highlight the database and right click to properties. I can't enter anything in the free space field ot the database size field???
Post #848855
Ninja's_RGR'us
Ninja's_RGR'us
Posted Sunday, January 17, 2010 9:20 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 6:43 PM
Points: 21,357,
Visits: 9,536
Check out alter database in books online. You can change the size from those command options.
In the GUI you must change the size of the files (free spaces is computed data from space used and file size).
Post #848872
george sibbald
george sibbald
Posted Sunday, January 17, 2010 9:35 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 4:02 PM
Points: 5,269,
Visits: 11,203
by default database are usually set to autogrow anyway. you may want to check this setting and confirm the growth factors are something sensible (50 - 100Mb usually good but is dependant on current database size).
If you know the size you want the database to be then growing it to that size in one chunk is the best way, but if you have the disk capacity and there is a chance of sudden unexpected growth then leaving autogrowth turned on is a good idea. Better to have the database grow a bit then run out of space.
---------------------------------------------------------------------
Post #848874
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Sunday, January 17, 2010 9:59 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 6:14 PM
Points: 31,421,
Visits: 13,734
Autogrow ought to be turned on. You don't want your database failing because you can't respond or you're asleep.
However, you want to grow in large chunks, and minimize growths as it can create physical fragmentation on the disk. Grow enough space for 3-4 months. Keep watching, grow again as needed.
And as mentioned, you change the total size, not the free space.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #848878
bellw
bellw
Posted Sunday, January 17, 2010 1:02 PM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, January 17, 2010 12:46 PM
Points: 9,
Visits: 12
Got it!! Thanks for all your cooments!
Post #848895
bellw
bellw
Posted Sunday, January 17, 2010 1:03 PM
Forum Newbie
Group: General Forum Members
Last Login: Sunday, January 17, 2010 12:46 PM
Points: 9,
Visits: 12
Got it!! Thanks for all your comments!
Post #848896
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
