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 |
|
Abhinavsmoudgil
Starting Member
2 Posts |
 Posted - 2011-07-05 : 14:27:23
|
| Hello,I have a database made in SQL Server 2008 R2 Version. Please let me know is it possible for me to restore the backup of this database on the SQL server Enterprise Edition.Best RegardsAbhinav Moudgil |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-05 : 14:29:54
|
| Not following.... You talk about a version that the backup was taken on and an edition that you want to restore to.What version of SQL are you trying to restore to (edition doesn't matter in most cases)--Gail ShawSQL Server MVP |
 |
|
|
Abhinavsmoudgil
Starting Member
2 Posts |
Posted - 2011-07-05 : 14:38:26
|
| Sorry if I am not clear. The source database is made in SQl Serever 2008 R2 The the Destination server is SQL Server 2008 (Enterprise Edition)Please let me know is this possible. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-05 : 14:46:15
|
| No. It has nothing to do with the edition (Enterprise). It solely has to do with the versions.SQL 2008 R2 is a higher version than SQL 2008 and downgrades of a database are not possible.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
sql 2008 R2 Database backup on Enterprise Edition