Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MSSQL 2008 vs 2008R2

Posted on 2011-02-28
5
Medium Priority
?
430 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:donhannam
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 35

Accepted Solution

by:
David Todd earned 2000 total points
ID: 35002148
Hi,

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.

HTH
  David
0
 
LVL 35

Expert Comment

by:David Todd
ID: 35002153
ps I'm suggesting option 4 upgrade 2008 to 2008R2
0
 

Author Comment

by:donhannam
ID: 35002210
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?.
0
 
LVL 35

Expert Comment

by:David Todd
ID: 35002378
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.
0
 

Author Closing Comment

by:donhannam
ID: 35021077
Thanks David.

Will go with just 2008R2 on server - Still need 2005
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

671 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question