| Author |
 Topic  |
|
|
David
Starting Member
25 Posts |
 Posted - 08 March 2001 : 02:52:30
|
I am trying to figure out how large the MS SQL db should get on a fairly busy snitz site. Can anyone give me a good range, such as size gain per month on a busy one? How about on snitz.com? Thanks.
David
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 08 March 2001 : 03:03:53
|
th current data size of the Snitz forum here is about 45Mb, it has about 30000 posts.
Do not take any notice of the post count on default.asp, this is only live posts, I am currently archiving the db
|
 |
|
|
misjuff
Starting Member
USA
41 Posts |
Posted - 08 March 2001 : 04:43:31
|
In that case what is a good way to config your database so it can be endless
|
|
|
|
cevans
Junior Member
Canada
101 Posts |
Posted - 08 March 2001 : 12:56:51
|
I believe the default option is to automatically grow both the data and the transaction log files by 10% and to allow unlimited growth. You can change this during the creation process. As well, you can edit the database properties (in Enterprise Manager, right click on the database and choose Properties) and change the option(s) at any time.
Clark |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 08 March 2001 : 14:30:26
|
quote:
I believe the default option is to automatically grow both the data and the transaction log files by 10% and to allow unlimited growth. You can change this during the creation process. As well, you can edit the database properties (in Enterprise Manager, right click on the database and choose Properties) and change the option(s) at any time.
Clark
You can only do this if you have administrator rights, in general if you are buying space from a Host, you will have a limit on the size your database can be.
If it is your own server or notgiven a limit then yes, by default it will grow by 10% chunks.
One important thing to remember, if your SQL db is not backed up using the dbbackup command, your log file will grow unchecked and surpass the size of your actual data very rapidly.
When purchasing SQL DB space, make sure that they set the option on your db to truncate log on checkpoint, this will prevent your log file from becoming overly large, unless of course they backup your SQL db, this does not mean do they backup their servers regularly, but an actual SQL backup.
|
|
|
| |
Topic |
|
Topic Locked
