SQL Server 2005 and SQL Server 2008 Express on Same Machine

Posted on 2009-02-19
Last Modified: 2012-05-06
Can I install SQL Server 2005 Developer Edition and SQL Server 2008 Express on the same machine?

I have a 2.8GB backup file from a production SQL Server 2005 Database that I am trying to do some work on remotely.  RDP is really a bit slow unfortunately.  My development machine has 2008 Express installed.  I was thinking that I would install the SQL Server 2005 Developer Edition and load the database against that but I am not sure if the two will coexist.

Can I load the backup database into SQL Express 2008?  The size of the database is 4.4GB according to SSMS Properties (So I am sort of predicting that it will not fit into SQL Express.


Question by:rowansmith
    LVL 42

    Expert Comment

    >Can I load the backup database into SQL Express 2008?

    Even if you could, does that make sense?  If your product migrates to production on 2005, I would not think it wise to do development on 2008.

    >Can I install SQL Server 2005 Developer Edition and SQL Server 2008 Express on the same machine?

    That seems like the better approach.

    LVL 35

    Accepted Solution


    My workstation has SQL 200 dev, SQL 2005 dev, SQL 2005 express, SQL 2008 trial all running at same time. I generally have SQL 2000 and SQL 2005 express switched off though.

    So yes it can be done.

    I do prefer to use SSMS from SQL 2008, just like most moved to the SQL 2000 tools when working with SQL 7


    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now