Install 2016 Instance next to SQL 2005 ??

  • To prepare for upgrading to SQL 2016, I'm thinking of installing a developer version of 2016 on a test server, already running SQL 2005.

    Are there any "gotchas", or special considerations I need to consider ?? TIA

  • There are some limitations and such listed here:

    SQL Server 2016 Support for SQL Server 2005

    ------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]

  • This was removed by the editor as SPAM

  • homebrew01 (11/18/2016)


    Are there any "gotchas", or special considerations I need to consider ?? TIA

    The main one is whether SQL 2016 will install on the OS that you have. The earliest OS that SQL 2016 will install on is Server 2012, and it has to be x64, there's no x86 version for SQL 2016.

    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 4 posts - 1 through 3 (of 3 total)

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