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.
Who is Participating?
David ToddConnect With a Mentor Senior DBACommented:

It depends on the level of support that you need to give your clients. If you need to replicate their environment to OS/SQL/Edition then I'd suggest you need some kind of virtual environment where you can start and stop virtual machines at will, and maintain each customers virtual machine in line with their upgrades.

Otherwise I'd consider 2008R2 an large service pack on 2008. In fact I'd suggest for most 2005 issues you could use 2008R2.

David ToddSenior DBACommented:
ps I'm suggesting option 4 upgrade 2008 to 2008R2
donhannamAuthor Commented:
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?.
David ToddSenior DBACommented:

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.


PS Dont forget to upgrade the client databases as necessary.
donhannamAuthor Commented:
Thanks David.

Will go with just 2008R2 on server - Still need 2005
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.