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 |
|
wateyz
Starting Member
1 Post |
 Posted - 2005-09-11 : 21:46:37
|
| Hi,I have a problem with the database that I created using MSDE 2000 SP4. I tried to attached the database into the new SQL Express using the sp_attach_db and it worked. The message mentioned is that the DB has been upgraded. When I tried to attach back the DB back to my MSDE, it can't be done.My PC is XP pro SP2. Before I reattach the DB back to MSDE, I detach the DB from my SQL express.Is it because once the SQL express upgraded the DB, it cannot be supported by MSDE or SQL 2000 ?Thanks. Any help is greatly appreciated. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-09-11 : 21:53:50
|
| That's correct, once a database is converted to a new version, it cannot be re-attached to a previous one. It is better to make backups of a database if you need to preserve or restore it to its original version number. |
 |
|
|
|
|
|
MSDE2000 and SQL ExpressCTP