Post reply

Lock for upgrade

  • December 10, 2009 at 12:39 am

    #139973

    HI,

    Have a problem. Need to upgrade a database. On that server i have other databases that cant be down. How do i set just one instance to be "locked" for users? The server this time is running SQL2000

  • December 10, 2009 at 2:06 am

    #1090408

    Check this link : http://msdn.microsoft.com/en-us/library/aa275464(SQL.80).aspx

    You can set the database to single user mode, whcih will lock the database for other users. Only one connection can be made to it, adn the upgrade can be performed.

  • December 10, 2009 at 2:22 am

    #1090414

    Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.

    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

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

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