Home Forums SQL Server 2008 SQL Server 2008 Administration I think I already know the answer but... :unsure: RE: I think I already know the answer but... :unsure:

  • January 15, 2013 at 11:17 am

    #1577444

    So a workable process would be to:

    1. Take full backups of all User DBs and the Master, MSDB, and Model DB

    2. Completely uninstall SQL Server

    3. Re-install

    4. Restore all User DBs

    5. Restore Master, then model, then MSDB (does the order matter)

    6. Restart and pray everything comes back online

    * What about the Resource DB? Should I make a copy of this before the uninstall and replace the newly created one with the copy, or leave it alone (I do now know much about this)

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience