Post reply

Autoclose property changes automatically?

  • February 23, 2013 at 4:58 am

    #270782

    I have set autoclose property to off for all database in my server. After some days i found that some databases had autoclose on again for which i had set off. So is there any chance of database automatically changing autoclose property? Or is there situation which may cause change in autoclose property?

  • February 23, 2013 at 5:28 am

    #1590597

    nothing happens automatically, so something is changing the setting.

    if you restore a database, the property for autoclose is stored inside it, so that's one possibility....restore it,and since the last setting was autoclose=true, it's seen again.

    the other thing i would do is check you jobs; you might have something that is changing the property.

    the change of the property, if it was a command and not the restore, is stored in the default trace i think, so look there as well...you can see if it's being done and by who.

    • This reply was modified 5 years, 7 months ago by  Lowell.
    • This reply was modified 4 years, 4 months ago by  Dave Convery.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply