Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server 2008 R2 backup to SQL Server 2008

Posted on 2013-06-12
4
Medium Priority
?
251 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 2000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Screencast - Getting to Know the Pipeline

886 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