detach user dbs during sql2005 in-place upgrade

Last post 10-24-2008 12:55 AM by madhuottapalam. 1 replies.
Page 1 of 1 (2 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 10-23-2008 6:57 PM

    detach user dbs during sql2005 in-place upgrade

    Is it best practice to detach user dbs during sql2005 IN-PLACE upgrade from sql2000?  If it is, after upgrade (setup.exe) is successfully done, will re-attach the user dbs to the newly in-place upgraded server then act like the side-by-side upgrade where we restore/attach user dbs? except that we don't worry about instance name, jobs, login..etc.

     

    Filed under:
  • 10-24-2008 12:55 AM In reply to

    Re: detach user dbs during sql2005 in-place upgrade

     

    In anycase you have to keep a backup as a rollback strategy whether it is backup file or detached file does not matter. So detaching DB and then attaching should also work.

     

    Madhu

    Madhu K Nair
    http://madhuottapalam.blogspot.com/
    http://experiencing-sql-server-2008.blogspot.com/
Page 1 of 1 (2 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.