I support clients running different versions of MSSQL - I develop in access and link via a ade.
I have 3 versions of SQL (2000, 2005, 2008) on our 64 bit server running SBS 2008. only 2 users.
This all works well and I restore databases from clients to appropriate server instance to test.
Now have a client with 2008 R2 and deciding what is best to do.
Main issue is that I cannot restore 2008R2 database to 2008
Install another instance of MSSQL - 2008R2 (if I can)
Uninstall current 2008 and replace with 2008R2 - Depends on how different the MSSQL version of 2008 is to 2008R2.
Use Hyper V to create a separate environment.
Appreciate any comments.