DB is too large - Administration and Configuration

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

8/13/2007 3:52 PM

Aaron Tarvin

Joined: 5/6/2006

Posts: 117

DB is too large

I am in the process of copying our DNN 4.5.4 site from GoDaddy to 3Essentials.

I got a backup of the DB on GoDaddy and had them restore it at 3Essentials. However, the restored database is 190MB and the limit for the Deluxe Business plan at 3Essentials is only 100MB. I've already cleared the site log, schedule history log, and error log.

Any advice on how I can prune my DB down? I don't want to just start removing records without knowing the consequences.

I was surprised 3Essentials has such a low limit.. before I removed the log records the DB was well over 250MB on GoDaddy with a cheap shared hosting account without a limit problem. Perhaps 3Essentials isn't right for us. Our site doesn't have an unusual amount of data.

Thanks!

8/13/2007 5:45 PM

Mitchel Sellers

www.mitchelsellers.com
Joined: 1/24/2007

Posts: 7846

Re: DB is too large

Ensure that you do a backup and truncate the database transaction log.

Providers such as godaddy NEVER seem to truncate that log and the database grows to VERY large proportions.

-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services

8/13/2007 11:43 PM

Aaron Tarvin

Joined: 5/6/2006

Posts: 117

Re: DB is too large

Thanks Mitchel. I did try this and the size didn't change.

I tried these commands:

BACKUP LOG <database name> WITH TRUNCATE_ONLY

DBCC SHRINKDATABASE (<database name>, 10)

8/13/2007 11:51 PM

Mitchel Sellers

www.mitchelsellers.com
Joined: 1/24/2007

Posts: 7846

Re: DB is too large

Intersting,

Now, I guess I would use something like this Determining SQL Server Table Sizes to determine exactly where all of your space is being eaten. I would also try just using the sp_spaceused command to see what the utlization is for the data and logs.

Even with a large bloating due to external data that I have in my database for http://www.icgposrtals.com and http://www.mitchelsellers.com I am only at a hair over 30Mb in database size..

-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services

8/15/2007 2:19 AM

Aaron Tarvin

Joined: 5/6/2006

Posts: 117

Re: DB is too large

Thanks again Mitchel, great info. I was able to create the proc, but for some reason don't get any results on "myLittleAdmin", tried the same query at another location with Query Analyzer and it works great, not sure what the deal is.

Anyhow, today the DB is showing 25MB! I guess it hadn't updated the size on their status pages yet.

You've been a huge help, thanks again.

Page 1 of 2

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)