MSSQL 2008 vs 2008R2
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
Options are:-
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.
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
Options are:-
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
David Todd
ps I'm suggesting option 4 upgrade 2008 to 2008R2
ASKER
Thanks for comments - makes sense to replace 2008 with 2008R2
In this case I was intending to uninstall 2008 and install 2008R2 rather than upgrade. I'm always a bit nervous with upgrades.
Was there a specific reason to upgrade?.
In this case I was intending to uninstall 2008 and install 2008R2 rather than upgrade. I'm always a bit nervous with upgrades.
Was there a specific reason to upgrade?.
Hi,
Installing 2008r2 will do an upgrade. I haven't seen how to do a side-by-side of 2008 & 2008r2.
I just thought that an upgrade might be easier.
Regards
David
PS Dont forget to upgrade the client databases as necessary.
Installing 2008r2 will do an upgrade. I haven't seen how to do a side-by-side of 2008 & 2008r2.
I just thought that an upgrade might be easier.
Regards
David
PS Dont forget to upgrade the client databases as necessary.
ASKER
Thanks David.
Will go with just 2008R2 on server - Still need 2005
Will go with just 2008R2 on server - Still need 2005