I have a collection of other DB stuff that's related:

This will show you the recovery mode and if autoshrink is on for the DB

    sp_helpdb @dbname = databasename

You can also set the recovery mode using SQL

    ALTER DATABASE databasename SET RECOVERY FULL
or
    ALTER DATABASE databasename SET RECOVERY SIMPLE

And you can even set the autoshrink option for the DB

    ALTER DATABASE databasename AUTO_SHRINK ON

On a shared hosting env. with limited DB size you should set the Recovery Mode to Simple and Autoshrink = On or you could get some into serious trouble.

Some of my clients have had problems logging in or even the site crashing when the DB was "Full".

If your data is so critical you can't use the Simple Recovery mode I guess you won't (shouldn't) use a Shared Hosting plan, but a dedicated server...

Related Gemini issue

---

I am not aware of an easy way of doing this without creating a new scheduled task...

---

-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