Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We've just provisioned a second dedicated server so we can use database mirroring for high availability.

The existing server uses MSSQL Express 2005. We have MSSQL Web 2008 and want to minimise the downtime to get mirroring set up. Can I install MSSQL Web 2008 while the production server still runs without any conflicts?

Any ideas on the best way to do this?

PS these boxes run IIS + MSSQL and I'm setting up NLB too, although thats another post

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

You'll need to use Named Instances, but yes you can do this easilly. We have a server running SQL 2005 Express, 2008 Express and 2008 R2 Standard all happily.

share|improve this answer
    
Thanks. The current 2005 Express is not using a named instance, ie we connect to "SERVERNAME", so just specify a named instance during the installation? Won't have to take the server down or anyting? –  user59135 Nov 3 '10 at 23:46
    
@Tom - correct, just enter an instance name when you install the next version of SQL and they will live quite happily. No need to take server down, reboot anything or restart any services. –  Mark Henderson Nov 3 '10 at 23:48
    
Fantastic. So the downtime would be detaching the db's from Express 2005, attaching them to 2008 and setting up the mirroring? –  user59135 Nov 3 '10 at 23:49
    
If you're installing a named instance of SQL Server 2005 Express, you need to select the Advanced installation options during the install. If you don't, a default instance will be installed. –  joeqwerty Nov 4 '10 at 0:05
    
@joeqwerty SQL Express is already on the server, putting on SQL 2008 (i guess as a named instance so it will live happily beside the existing SQL Express) –  user59135 Nov 4 '10 at 0:11
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.