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 |
|
sasan_vm
Yak Posting Veteran
51 Posts |
 Posted - 2011-09-27 : 03:03:12
|
| HelloI have an sql 2000 database attached to sql 2008, now I get error on attaching it again to sql 2000,how can solve it ?Regards,sasan |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-09-27 : 03:09:46
|
You can't.When you attached the database to SQL Server 2008, the internal version number of database was changed.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-09-27 : 03:10:51
|
you can't attached it back. When you attached a lower version database to a higher version, SQL Server automatically convert it to that version. So now your database is in SQL 2008 version and SQL 2000 will not be able to recognize it.Hope you have a backup copy of it.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-09-27 : 05:45:23
|
| Script all objects, export all data, recreate the database on SQL 2000. Or restore an earlier backup.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
attach problem