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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-12-20 : 17:01:25
|
| Hi,I have backup file taken on sql server 2008 R2 enterprise edition. I have another server which have sql server 2008 express edition. What is possible way to restore data on this server? Can we restore enterprise edition backup on express, developer or standard edition?Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-12-20 : 17:05:28
|
| It's not the edition that's going to hurt you, but if the express edition is SQL 2008, not SQL 2008 R2, then restoring the backup will not be possible because it's a lower version of SQL.Regarding editions, a backup of a database from Enterprise edition can be restored to Express providing it has no persistent enterprise features and it's small enough to fit into the Express limit (4GB on 2005 and 2008, 10GB on 2008 R2), but you can only restore to the same version or a higher version (2005->2008 is OK, reverse is not, 2008 -> 2008 R2 is ok, reverse is not)--Gail ShawSQL Server MVP |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-12-20 : 17:37:32
|
| Thanks Gail. |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-12-20 : 17:42:20
|
| Which method is better to move data from SQL 2008 R2 Enterprise Edition to SQL 2008 Express Edition.1. Script full db on enterprise and run script on express, then import data with imp/exp wizard.2. copy database wizard to copy database from 2008 r2 to 2008.Please suggest.Thanks |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-12-21 : 03:07:04
|
| Either will work, use what you're more comfortable with.--Gail ShawSQL Server MVP |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-12-21 : 10:44:08
|
| Thanks |
|
|
|
|
|
|
|
|
restore