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