Solved

SQL Server 2008 R2 backup to SQL Server 2008

Posted on 2013-06-12
4
240 Views
Last Modified: 2013-06-14
We are purchasing a company that uses the same software system as we do. I have been tasked to retrieve that data and get it into our database. I figured it's the same software so this will be easy. They have sent me a backup of their database (SQL Server 2008 R2). I thought I would simply be able to restore their database to a new database on our server until I realized we are on SQL Server 2008 standard and I cannot restore their R2 Database. Is there anyway for me to extract the data from the R2 Backup? It's not a very large DB so even if I can get it into some sort of csv file I would be happy.
0
Comment
Question by:clifford_m71
  • 2
4 Comments
 
LVL 15

Accepted Solution

by:
achaldave earned 500 total points
ID: 39241998
You need to either upgrade your version to 2008 r2 or install temporary sql 2008 r2 server, restore data on the temporary server and export / import data from the temp server to your production server. Also you can ask them to export data and send it to you so you can import it on your server.
http://msdn.microsoft.com/en-us/library/ms140052%28v=SQL.100%29.aspx
0
 

Author Comment

by:clifford_m71
ID: 39242038
Thank  you for the quick response. Can I download SQL Server 2008 R2 Express and restore the backup to that? Or do I need the regular R2 version?
0
 
LVL 8

Expert Comment

by:didnthaveaname
ID: 39242113
I don't see why you couldn't use R2 Express.  As long as their database is under 10GB (src: http://msdn.microsoft.com/en-us/library/cc645993%28v=sql.105%29.aspx).
0
 

Author Closing Comment

by:clifford_m71
ID: 39247582
Thanks for the help. I installed a 180 day trial version of R2 on another server. Thanks for the help.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

867 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now