Backup MSSQL R2 for R1

Question

0.00/5 (No votes)

See more:

Hi,
if i have create backup for Microsoft SQL Server 2008 R1 from Microsoft SQL Server 2008 R2? Can i only convert a bak file? Please do not provide a solution to create a script.

Thanks!

Posted 7-Jul-14 4:47am

vezo11

Add a Solution

3 solutions

Solution 3

Only way is to create scripts (you can create script for 2008 or older version). During the generation of scripts you can choose between only schema, schema+data, only data...

Posted 14-Jul-14 6:45am

vezo11

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sankarsan parida · Accepted Answer · 2014-07-07T08:17:00

No, In this particular case, SQL Server Management Studio is telling me that when SQL Server attempted to restore the backup, it realized that the backup was from SQL Server 2008R2 but I was restoring to SQL Server 2008. As a result, the restore failed.

You can’t restore a backup from a newer version of SQL Server to an older one.  Attach and detach will also fail.

OriginalGriff · Accepted Answer · 2014-07-07T08:18:00

No. If you cretae a "proper backup" file for R2, then you can't restore it to R1 - you can go the other way, but you can't "downgrade" the data as R1 doesn't know anything about R2 (understandably)

So despite this: "Please do not provide a solution to create a script." I'm going to: your only option is to create a script.

Backup MSSQL R2 for R1

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0