Post reply

reinstall SQL Server 2008 R2 but uninstall first

  • November 27, 2014 at 5:09 am

    #312806

    Hi, I am looking to reinstall SQL Server 2008 R2 ent x64. It was installed with the incorrect collation for the application it will use in production. I know I can perform this by rebuilding the master db, however there are a few other things not done properly during original install (by a non DBA :rolleyes: ) so I would like to start afresh.

    My question is after backing up all DBs should I do control panel, remove SQL Server (and associated apps) or just run the SQL binaries installer and install over the top?

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

  • November 27, 2014 at 5:14 am

    #1761278

    If you just run the installer, you'll only be allowed to install a new instance (different name). If you want to replace an installation, uninstall then reinstall.

    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

  • November 27, 2014 at 6:41 am

    #1761302

    Cheers Gail, I had forgotten about the named/default instance setup.

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

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

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