Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Database out of control! HELPDatabase out of control! HELP
Previous
 
Next
New Post
5/21/2006 4:59 PM
 

Hello guys,

My MSSQL database just keeps growing and growing even though I make little changes in the site / people register every few days. I am using a shared host and they charge 60 bucks a year everytime my database crosses 50 MB.

Does anyone know how to bring this database under control? I am using DNN 4.0.2. My hypothesis is there are processes running in the background that are useless and maybe someone here can tell me how to identify and delete them. I have Plesk 7.5 and do have access to the DB WebAdmin tool.

Thanks alot,

Salman

goinsaf.org

 
New Post
5/21/2006 6:14 PM
 
Sorry, I've no idea what options you have under Plesk, but here are some things to check:
  1. are your backups running?
  2. are you shrinking the data and the log files?
  3. is the database in full recovery mode or simple?
 
New Post
5/22/2006 12:27 AM
 

Hi Barry:

Thanks for those pointers. I was completely clueless before but you have given me some direction.

Since I have a shared host it seems to me I have very few options under the ASP.Net Enterprise Manager. But I CAN run queries on my database, so my question is: the things that you mentioned, in your knowledge can they be done through queries?

Again, thanks alot.

Salman

goinsaf.org

 
New Post
5/22/2006 8:29 AM
 
Here are some commands you can run as queries that might help:
select databasepropertyex('yourdatabasename','recovery') 
tells you what recovery model the database is using,
select databasepropertyex('yourdatabasename','isautoshrink')

tells you if AutoShrink is on, '1' is yes.  I can't find a command that will tell you if backups are being taken, or when the last backup was, sorry, maybe someone else here will know.

I'm also fairly inexperienced at doing the backup thing, but my log database is the bit that grows fast and setting the recovery to simple with autoshrink drops the log file to a reasonable size,  I am aware though that this means that I can only restore to the last backup and therefore any changes I make in between backups may be lost, hence I backup to disk every night and transfer to another machine when I remember.

 
New Post
5/22/2006 5:10 PM
 

Hey Barry:

Thanks alot for those useful queries. You have opened up a whole new universe (or pandora's box) to me :P

I used the queries you mentioned, and found that my database is set to FULL recovery, and AutoShrink is OFF '0' .

So, do you know the queries to set recovery to Simple and AutoShrink to '1' ? Otherwise I must go googlin' ...

Thanks ALOT Barry...

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Database out of control! HELPDatabase out of control! HELP


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:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. 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.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out