SQL Server 2008 Express – Install on Same Machine as SQL Server 2008

sql-server-2008sql-server-express

When setting up a server, we installed SQL Server 2008. Now it turns out we don't need it, and we want to use the free Express version instead. Ideally without much interruption to things using the database. Is it possible to install Express side by side with the full version without disrupting things?

The tables are small and the load is relatively light. As in, there are maybe 30 rows in each table, and a few aspx pages that use them to keep track of state. We're not doing anything other than simple queries on a few tables in our current setup. I could get by using SQLite, if I wanted to rewrite some ASP.NET pages to use it.

Best Answer

As Shark already pointed out install or downgrade are distinct actions:

  • install side by side means to have a new session of Express edition installed WHILE the current running edition is working (btw, what is the version of the current instance?);
  • DOWNGRADE/UPGRADE means running the installation option over the currently running instance;

Any operation involving the live instance means it will interact and stop with the current instance. Some planning questions are in order now:

  • What are the dimensions of the database(s) that are in work? (Express edition can handle small dbs only);
  • What hardware necessities do you have for your current load? (Express edition has some strict limitations in CPU, RAM, hdd space);
  • What features do you need from the current set? (eg: you won't have SQL Agent jobs with Express Edition);

At first you need to answer all these questions and only then see what your options is.

EDIT: after all your details specified, I'd suggest you to install a new version along with the current working one. Then stop the working instance service, ATTACH the database files to the Express Edition, then move on with the uninstall of the other instance. This will make the database unavailable only for the attach operation.

Related Question