sql database size

Networking/Security Forums -> General Software

Author: duster PostPosted: Fri Sep 12, 2008 6:24 pm    Post subject: sql database size
    ----
Im in studio manager for sql 2005 viewing my database properties how to i change the size to autogrowth?

Author: larsmhansenLocation: Boston, MA, USA PostPosted: Sat Sep 13, 2008 1:23 am    Post subject:
    ----
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.



Networking/Security Forums -> General Software


output generated using printer-friendly topic mod, All times are GMT + 2 Hours

Page 1 of 1

Powered by phpBB 2.0.x © 2001 phpBB Group