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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 attach problem

Author  Topic 

sasan_vm
Yak Posting Veteran

51 Posts

Posted - 2011-09-27 : 03:03:12
Hello

I 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"
Go to Top of Page

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]

Go to Top of Page

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 Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -