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:30 am

    #1577448

    MyDoggieJessie (1/15/2013)

    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

    Easier might be to backup the user databases (just in case), backup the system databases, uninstall SQL, reinstall SQL. Restore master, that will recreate all the user DBs that the old instance had (providing you left the files exactly where they were), then restore model and masb.

    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