Post reply

Can a database come to single user mode itself?

  • November 13, 2008 at 7:01 am

    #383373

    Hi,

    During a change in dr activity, i had restored the transaction log after bringinng the db into single user mode and then i brought all the db online and ran a script to sync all the users on the db.

    It was ok by that time, but when i logged in back, i found the same dbs in single user mode. Id it possible, it can happen? Did i do any mistake that dbs are coming back in single user mode??

    Any idea??

  • November 13, 2008 at 7:44 am

    #898089

    Did you set it to multi-user after syncing the logins and users?

    SQL won't just set a DB to single-user, Someone would have had to run a command to do so.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 13, 2008 at 8:40 am

    #898144

    Yes, i did that. Yes i was thinkin that hows that done if i haven't done.

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

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