• RSS
  • Twitter
  • FaceBook

Security Forums

Log in

FAQ | Search | Usergroups | Profile | Register | RSS | Posting Guidelines | Recent Posts

sql database size

Users browsing this topic:0 Security Fans, 0 Stealth Security Fans
Registered Security Fans: None
Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> General Software

View previous topic :: View next topic  
Author Message
duster
Just Arrived
Just Arrived


Joined: 06 May 2005
Posts: 0


Offline

PostPosted: Fri Sep 12, 2008 6:24 pm    Post subject: sql database size Reply with quote

Im in studio manager for sql 2005 viewing my database properties how to i change the size to autogrowth?
Back to top
View user's profile Send private message
larsmhansen
Trusted SF Member
Trusted SF Member


Joined: 11 Jan 2003
Posts: 0
Location: Boston, MA, USA

Offline

PostPosted: Sat Sep 13, 2008 1:23 am    Post subject: Reply with quote

You shouldn't. Make the initial size big enough so that it doesn't need to grow. But if you have to, it doesn't take long to find. I don't recall where it is of the top of my head. Just make sure you don't have autogrow and autoshrink on at the same time, and make sure the autogrow is set to a fixes size (like 5MB) rather than a precentage.
Back to top
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
Display posts from previous:   

Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> General Software All times are GMT + 2 Hours
Page 1 of 1


 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Community Area

Log in | Register