Frozen, it  is an options in the properties of the database itself. If you have SSMS (Management Studio) one way to change this setting is in the Object Explorer pane.

Right-click on the database, and then select "Properties" in the context menu.

Now go to the "Options" page and set the first setting .... "Auto Close" ... to "False" and save your changes.


You can do it via T-sql as

alter <databaseName> set auto_close off

you can check to see if auto_close is on or off by executing the following

exec sp_dboption <databaseName>

If you see "autoclose" in the list of results, then you know that auto close is set to ON

if you don't see it listed, then you know that auto close is set to OFF


You can do these things with dbo privilges, and this will mean that you can do it from the Host SQL window.

When you run the "alter database ..." statement, have the "execute as script" checkbox ticked.

When you run the "exec sp_dboption <databaseName>" then have the "execute as script" checkbox unticked so that you can see the results.

It goes without saying, though I'll say it, that one should take care when altering database properties.

---

pmgerholdt

hi there, i had this problem with one of my website database that log size was increasing enormously witch seems to be a dotnetnuke common problem so any way i have downloaded database file to my local machine and shrink it with sql manager then i have uploaded back where it was with the same name and everything but dotnetnuke keeps showing this under cunstruction page FYI i have auto upgrade = "true" in web config
1- what can i do to run this website?
2- is there any other way form dotnetnuke it self to do instead of shrinking the database?

Hi,

Be carefull that modifying the web.config make the application pool  will recycle itself on the next request. When you modify the debug value or when you rename the web.config, IIS will consider that the file is modified.

I don't know if the debug mode can crash a DNN Website.

---

Stéphane TETARD ARICIE - Member of DotNetNuke France