Post reply

Database sporadically going into single user mode

  • September 13, 2007 at 11:22 am

    #118265

    I have an installation of SQL Server 2005 SP1 where occasionally I will come in the next day to find it has been placed into single user mode...no one else had touched it (administratively) but there were applications using it after hours but this don't seem to be related.

    Has anyone else had this issue.....does SP2 address this?

  • September 13, 2007 at 11:48 am

    #733570

    I am sure you have some sort of "maintenace" script that is leaving your db in single-user. This by the way is not an expected behaviour in *any* of the releases RTM-to-SP2


    * Noel

  • September 13, 2007 at 11:58 am

    #733573

    Yeah I already went that route and looked into those. The only maintenance tasks I perform on this database are a few LiteSpeed maintenance plans to do full, differential and trans log backups. Nothing else. It's a very basic installation which is why i'm a little worried.

  • September 13, 2007 at 12:24 pm

    #733584

    Run a profiler trace for a 24hr period (if you can) and you should be able to catch the culprit.


    * Noel

  • September 14, 2007 at 5:50 pm

    #733927

    Have you checked the System Logs?  Perhaps the system is re-starting for some reason.  Also what about the service itself, did someone add some options to start it in single user mode.

Viewing 5 posts - 1 through 4 (of 4 total)

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