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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-05-07 : 22:19:53
|
| Hi,Can we restore a SQL 2000 Standard Edition database backup onto SQL Server 2000 Developer Edition?? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-05-07 : 23:39:44
|
yes. You can.You can do that for same version across edition.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2010-05-08 : 23:03:08
|
| Hi,But as per my knowledge we cannot restore a Enterprise Backup on Standard Edition. Meanning, on Higher edition we can restore any lower edition backup but might not be true for vice-versa.Pl coreect me if am wrong. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-05-09 : 22:19:03
|
You are probably got it confused with Version. As Tara said, for same version, you can restore from Enterprise to Standard.For different version, you can restore earlier version to later. But not from later version to earlier.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
Edition compatibiltiy