Home Forums SQL Server 2005 Administering Getting SQL Server 2005 Database out of Single-User Mode RE: Getting SQL Server 2005 Database out of Single-User Mode

  • This works a lot smoother if you do it all in one fell swoop. Like so:

    Use MyDatabase

    Alter Database MyDatabase Set Singel_User With Rollback Immediate

    Restore Database MyDatabase ......... blah blah blah

    Alter Database MyDatabase Set Multi_User


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]