| Author |
 Topic Search  Topic Options
|
iSec 
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: wwf SQL database size
Posted: 20 September 2007 at 10:35pm |
My forum's MS SQL database size is at 312 MB. Currently, my forum has 20,625 Posts in 2,031 Topics, is this a normal database size for that amount of posts? It was 45 MB two months ago  P.S. This is a MS SQL 2000 server.
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
 |
Nick-V
Senior Member
Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 September 2007 at 10:46pm |
SQL 2005: Our users have posted 29,538 Posts in 8,678 Topics in 9 Forum(s). We have 13,613 Forum Members. Its 91MB.
Weekly we do a reindex, shrinkdatabase (truncate only to avoid index fragmentation), updatestats.
|
|
javi712
Senior Member
Joined: 22 May 2003
Location: United States
Status: Offline
Points: 488
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 September 2007 at 11:41pm |
|
It shouldn't be. I have 700 members and 210,000 posts and my db is only 289MB.
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 September 2007 at 12:56am |
right that's what i mean... in 2 months the db size increased from 45 mb to 312 
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
Nick-V
Senior Member
Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 September 2007 at 1:00am |
Do a shrink database and see what happens. But remember to reindex. If you happened to add and then delete a lot of data this is exactly what you will get.
Edited by Nick-V - 21 September 2007 at 1:01am
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 September 2007 at 1:05am |
|
Well,
I just went in and looked up the db properties and discovered that the db size is only around 47 MB. But the backup that is done daily is 312 MB, isn;t that weird? The backup is done daily every couple of hours...
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
Nick-V
Senior Member
Joined: 26 October 2002
Location: United Kingdom
Status: Offline
Points: 319
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 September 2007 at 1:13am |
|
What recovery model are you using and is it the best choice for you? Look at the sizes of the data and transaction log backups. How often do you do a full backup reset the transaction logs....or are they just continuing to grow?
Edited by Nick-V - 21 September 2007 at 1:15am
|
|
iSec
Senior Member
Joined: 13 February 2005
Status: Offline
Points: 1140
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 September 2007 at 1:22am |
|
I use the Enterprise Manager tool to schedule the backup... it's the simplest way.
The size continues to grow when the differential backup is done every couple of hours...
now i changed it from hourly back to daily, and complete backup instead of differential. The first back will be done tonight so let's see how it will be.
|
|
"When it gets dark enough, you can see the stars"
-Charles A. Beard
|
|
