SQL database cleanup - 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

1
2
3
4
5

3/29/2011 12:37 AM

Joel Hokanson

Joined: 8/31/2007

Posts: 166

SQL database cleanup Modified By Sebastian Leupold on 3/30/2011 4:19:08 AM

The SQL database on my DNN site is growing very very fast. I would guess it is logs that keep growing. Even when I delete modules, the database stays large.

Is there a utility to cleanup the SQL database?

Are there any articles that tell me what tables in SQL I can occasionally truncate?

Thanks
Joel in Houston

3/29/2011 2:53 AM

Sergiy Velychko

forDNN.com
Joined: 7/10/2005

Posts: 376

Re: SQL databse cleanup

Joel

Very common problem is fast growing of SiteLog or EventLog table. You need to check how many records in each table and to truncate them. More detailed description can be found here.

Sergey

3/30/2011 4:18 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: SQL databse cleanup

I blogged about this subject a while ago: http://www.dotnetnuke.com/Resources/Blogs/tabid/825/EntryId/2903/DotNetNuke-Database-Performance-Tips.aspx

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

3/30/2011 4:36 AM

Sergiy Velychko

forDNN.com
Joined: 7/10/2005

Posts: 376

Re: SQL databse cleanup

Sebastian

This is great post! Sorry i did not see it before :(

Also about this backup with no_log. It was fine in SQL 2000, but 2005 and 2008 requires Simple recovery mode. But after small research i found ever in Full or Bulk-logged recovery mode you can use SHRINK without BACKUP WITH no_log. It does log truncation then. So client does not need to switch to Simple recovery mode.

Sergey

3/30/2011 8:05 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: SQL database cleanup

Sergey.
thanks for the addition, but from my experience, it happens sometimes that shrink is unable to truncate the transaction log and I only succeeded by switching recovering mode.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

Page 1 of 2

1

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)