| Author |
Topic |
|
jooorj
Posting Yak Master
126 Posts |
 Posted - 2011-07-02 : 02:08:17
|
| I have a backup file backed on SQL Server 2008 R2.I need to restore that file into SQL Server 2008 Express.Thank You. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-07-02 : 03:17:45
|
You can't.They have different internal formats.What you can do, is to script out every object from R2 and run the script on 2008.Then you can use Import/Export Wizard to copy all the data (and keep identity values).
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-07-02 : 06:50:11
|
| wow. that is very complexhow can import data without loss of anythis is very bug in microsoft.how can't rebackup from new version to older version.I think this is logically possible ? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-02 : 09:18:35
|
| There has never been any way to downgrade databases ever. It's not a bug. A database has an internal database version that corresponds to the SQL version it's attached to. Each version of SQL has a max version number that it understands. SQL 2008 R2 has a higher database version than SQL 2008.You cannot backup-restore from higher version to lower, you cannot detach-attach higher version to lower. You will have to do what Peso says, script the DB structure then import the data--Gail ShawSQL Server MVP |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-07-02 : 22:33:25
|
Or upgrade your Express installation to 2008R2 Express?
N 56°04'39.26"E 12°55'05.63" |
|
|
|
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-07-05 : 07:07:28
|
| I can not,I Can Not, because I gave the software to the client,and he now work on SQL 2008,but I am in R2, very bad microsoft technology. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-07-05 : 07:34:08
|
Very bad research from your part, maybe?Do you think it's great idea to stick a nongrounded plug into a grounded socket too? Once grounded, you cannot go back.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-05 : 07:51:48
|
| Do you always blame your tools when something goes wrong?It's documented that you cannot downgrade databases. You should have checked.--Gail ShawSQL Server MVP |
|
|
|
rupertsland
Starting Member
9 Posts |
Posted - 2012-01-16 : 10:39:21
|
| I have to agree with GilaMonster.I ran into this same problem a number of months ago. Our client wanted to send back their copy of the database we were building. I told them that was impossible, since their version was newer than ours (they were late in their decision to purchase SQL Server and ended up getting R2). They suggested we try using Express (!?). No go, same problem.For those who are new to, or not too familiar with SQL Server, what GilaMonster has pointed out is correct. The thing to remember here is that one simply cannot bring a database back into a previous version of SQL Server. This is not because Microsoft is trying to be nasty. The reason is that with each new release, there are many changes made to the software (features deprecated, added, and so on). So if you used features in a newer version that did not exist in an earlier version, guess what? You would quickly run into problems. Just try going from SQL 2008 back to SQL 2000. It simply wouldn't work, because of the major changes made to the software after the 2000 version.Cheers,Rupertsland |
|
|
|
|
Convert SQL 2008 R2 To 2008 Express