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