I have a server that is running SQL Server 2005 Express.
It currently has 2 instances of SQL Server running.
- Instance 1 runs some old legacy software that is not supported by me.
- Instance 2 runs my software.
Is it possible to upgrade instance 2 to SQL Server 2008 R2 Express independently of instance 1, i.e. keeping instance 1 on 2005 while instance 2 is upgraded?