Post reply

SQL Server 2014 side-by-side with earlier versions of SQL Server

  • May 27, 2014 at 3:58 am

    #307766

    Hi,

    We had a situation yesterday in which a member of the DBA team installed SQL 2014 on his Windows-7 desktop and that apparently "corrupted" the earlier-version installs on his machine, so that they became unusable and had to be re-installed.

    Has anyone had this issue?

    According to this, there should be no issues with a side-by-side install:

    http://msdn.microsoft.com/en-us/library/ms143694.aspx

    I saw a similar question posted here:

    http://www.sqlservercentral.com/Forums/Topic1566725-3411-1.aspx

    I have seen it suggested in the past that for the purposes of working with new versions of SQL Server it is safer to install those on a dedicated VM, but I don't know how to go about doing that.

    Any help/thoughts on the above would be appreciated.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • May 27, 2014 at 4:09 am

    #1716639

    I'm running 2014, 2012 and 2008 R2 on a Win 7 box. They all work fine.

    Could be he specified system DB files in the same place as the earlier version or something like that.

    VMs are recommended for CTP installs as they may not uninstall cleanly (they are beta software)

    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

  • May 30, 2014 at 1:23 am

    #1717673

    I have not heard about anyone having issues, nor have I. As with Gail though, CTPs are installed on VMs (or, better still, spun up in Azure).

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • May 30, 2014 at 3:05 am

    #1717692

    if you're prepared to flatten and re provision the server it doesnt matter where you install it, physical or virtual!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • May 30, 2014 at 10:34 pm

    #1717993

    We are running SQL server 2008 Enterprise, SQL server 2014 Enterprise and SQL server 2014 STD edition on the same test machine...

  • June 3, 2014 at 3:38 am

    #1718463

    Thank you all!

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • June 3, 2014 at 4:14 am

    #1718465

    I have SQL Server 2012 and SQL Server 2014 side by side on my windows 8 laptop. No problems at all.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • September 14, 2015 at 6:01 pm

    #1826585

    Question:

    So let's say I have a default instance myServer of 2008R2 and its named instances

    myServer\A

    myServer\B

    myServer\C

    and now I want to side-by-side install 2014 having the same structure of A/B/C - do I have to name them something like

    myServer\A2014

    myServer\B2014

    myServer\C2014

    or is there a way to still keep it as A/B/C somehow?

    Thanks!

  • September 15, 2015 at 1:18 am

    #1826609

    btio_3000 (9/14/2015)

    Question:

    So let's say I have a default instance myServer of 2008R2 and its named instances

    myServer\A

    myServer\B

    myServer\C

    and now I want to side-by-side install 2014 having the same structure of A/B/C - do I have to name them something like

    myServer\A2014

    myServer\B2014

    myServer\C2014

    or is there a way to still keep it as A/B/C somehow?

    Thanks!

    You have to give them different names.

    You can read more about it on the bottom of this page:

    Instance Configuration

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • September 15, 2015 at 10:30 am

    #1826813

    Thank you Koen

Viewing 10 posts - 1 through 9 (of 9 total)

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