Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2010-10-22 : 05:48:33
|
| Hi All,I took backup on SQL Server 2008 R2(RTM) with Standard edition 64 bit;when i am trying to restore it on SQL Server 2008 32 bit edition its raising error.Is there any alternative?TIA. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-10-22 : 10:47:57
|
| Databases cannot be downgraded. A database on SQL 2008 R2 can only be restored to SQL 2008 R2, not to SQL 2008 (it has nothing to do with the 32 bit/64 bit)If you need to move the DB down versions, you will need to script all objects, export all data and then recreate the database on the lower version.--Gail ShawSQL Server MVP |
 |
|
|
learntsql
524 Posts |
Posted - 2010-10-25 : 01:02:45
|
| ThanQ... |
|
|
|
|
|
|
Restore on SQL Server 2008 failure