Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Database growth spurt		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Astralis
Senior Member

USA
1218 Posts
Posted - 12 February 2005 :  15:55:30  Show Profile  Send Astralis a Yahoo! Message
My database just shot up from 117MB to 140MB in only three days! I'm new to SQL Server and don't know what might have caused this - it wasn't any growth on my site - nor ways to prevent it. Is compacting safe? Also, how do people here back up their database?

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 12 February 2005 :  18:22:58  Show Profile  Send ruirib a Yahoo! Message
Hmmmm... what file has grown? The .mdf or the .ldf?

If it was the .ldf, make sure you set the Recovery Model to simple. That will decrease the size of your log file.

Snitz 3.4 Readme | Like the support? Support Snitz too
Edited by - ruirib on 12 February 2005 18:33:31
Go to Top of Page

Astralis
Senior Member

USA
1218 Posts
Posted - 12 February 2005 :  18:51:15  Show Profile  Send Astralis a Yahoo! Message
On a shared server, I don't think I can see the .mdf nor the .ldf, right?
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 12 February 2005 :  19:20:46  Show Profile  Send ruirib a Yahoo! Message
You can, with EM, if you right click the database and choose Properties.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Astralis
Senior Member

USA
1218 Posts
Posted - 12 February 2005 :  19:28:06  Show Profile  Send Astralis a Yahoo! Message
mdf: 134
ldf: 47

So, it has grown by 40MB since last night.
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts
Posted - 12 February 2005 :  19:41:24  Show Profile  Visit Gremlin's Homepage
It's not really all that unusual to see SQL Databases increase in size like that, SQL Reserves space for inserts etc, you can compress out the space but it's only going to reclaim it again eventually. What Rui suggested will help keep the log file size down most people dont need full transactional logging anyway so the Simple recovery mode is generally more appropriate to use.
Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page

Astralis
Senior Member

USA
1218 Posts
Posted - 12 February 2005 :  19:46:52  Show Profile  Send Astralis a Yahoo! Message
So, I should expect 40MB of growth every day? Or even on a weekly basis? This is going to get expensive! Wow...

Anyhow, the recovery model is already set to "Simple".
Edited by - Astralis on 12 February 2005 19:48:56
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 13 February 2005 :  00:41:55  Show Profile
There are sp's you can run to identify size by tables. I know there is one such script at www.sqlteam.com
======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts
Posted - 13 February 2005 :  03:09:30  Show Profile  Visit Gremlin's Homepage
It's unlikely to grow that much every day.
Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07