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 |
|
GMANAFIP
Starting Member
13 Posts |
 Posted - 2009-07-13 : 07:59:54
|
| HelloI have a .BAK backup file in 2005 from a database that was migrated into 2005 under the 2000 compatibility mode. I now want to take that .BAK file and restore it to a development box in 2000. However, I getting errors "cannot process this media family". Does 2005 change the database so that it is now not backwards compatible? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-13 : 08:36:02
|
| I would have thought so as they are two different engines and the compatibility mode just adds a few extra .dlls into the mix. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-07-13 : 10:12:56
|
| You cannot restore a database backup from a SQL 2005 database server to a SQL 2000 server.CODO ERGO SUM |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-13 : 11:10:35
|
| Sorry, should have made myself clear, I was answering OPs last sentence. |
|
|
|
|
|
|
database restoring problem