can we takes database backup of sql express 2008 R2 to SQL Express 2008

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

I have a database backup in "SQL Server 2008 R2", Can i store this database backup in "SQL 2008 Express" ?

Anyone who have knowledge about SQL-2008 kindly share to me.

Posted 8-Aug-12 19:07pm

Mas11

Updated 8-Aug-12 19:34pm

Mehdi Gholam

v4

Add a Solution

1 solution

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)

Philip Stuyck · Answer 1 · 2012-08-08T20:57:00

Solution 1

Yes this is possible without any problem whatsoever.
I recommend you also install the express version of management studio because via the user interface it is very easy to do.

Posted 8-Aug-12 20:57pm

Philip Stuyck

Comments

Mas11 9-Aug-12 4:27am

But "SQL Server 2008 R2" is higher version than "SQL Express-2008". And in MS-SQL we can't get data from Higher version to Lower. I search over this & get the same answer.

But Philip are you confirm that a .BAK file from SQL-2008 R2 is accepted by
SQL Express 2008.

Philip Stuyck 9-Aug-12 4:47am

I think it is possible but why would you not simply upgrade your database to R2 too. It's free anyway. To be honest I misread your title, I thought you wanted to move a backup from an enterprise edition to express and that for sure is possible. I think what you try to do should also work because the database structure is probably not changed.

Mas11 9-Aug-12 4:54am

Okk Thanks.. I suggest to my client that he upgrade his database to SQl 2008-R2. thanks a lot for your valuable answer.