Page 2 Database is full and has crashed the site -- need person to help

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

Home

Using DNN Platf...

Administration ...

Database is full and has crashed the site -- need person to help me

7/18/2010 1:39 PM

Monte Comeau

Joined: 12/28/2009

Posts: 10

Re: Database is full and has crashed the site -- need person to help me

Will Strohl wrote:
@Sebastian: Nice. Thanks.

@Monte: Yes you can. Be aware of both what Sebastian said, and also that my script examples do not leave any records in those tables at all. If you'd like to have the last 1-2 day in those tables or something, you will need to adjust the scripts.

Thanks for your help. Much appreciated.

Is there a problem with deleting ALL records? I just want to be careful I don't cause problems.

7/18/2010 1:44 PM

Sebastian Leupold

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

Posts: 46212

Re: Database is full and has crashed the site -- need person to help me

Will Strohl wrote
First, clear out the EventLog and the SiteLog:

DELETE FROM {databaseOwner}[{objectQualifier}EventLog]
DELETE FROM {databaseOwner}[{objectQualifier}SiteLog]

If the database is at its limit, those SQL statements will not work, because DELETE adds records to the transaction log, which usually is included in database quota. please use the following commands instead:
TRUNCATE TABLE {databaseOwner}[{objectQualifier}EventLog] TRUNCATE TABLE {databaseOwner}[{objectQualifier}ScheduleHistory] TRUNCATE TABLE {databaseOwner}[{objectQualifier}SearchItemWordPosition] and if you can live without sitelog: TRUNCATE TABLE {databaseOwner}[{objectQualifier}SiteLog] Next database and database files need to be compacted, before you may continue clearing the search tables and reindex.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

7/18/2010 1:45 PM

Sebastian Leupold

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

Posts: 46212

Re: Database is full and has crashed the site -- need person to help me

PS: if you are limited with database space, check whether you need site log inside DNN at all. if not, turn it off or switch to file based log and a log analyser.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

7/19/2010 2:01 AM

Sebastian Leupold

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

Posts: 46212

Re: Database is full and has crashed the site -- need person to help me

if you delete all rows in sitelog, you will not be able to review recent visits in Admin :: SiteLog, this will be repopulated afterwards.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

Page 2 of 2

Database is full and has crashed the site -- need person to help me

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)