How to Reattached database in SQL 2000 server after upgrading with SQL 2005
-
Dear Friends, I attached sql 2000 database in sql 2005 server and deattaching from 2005 again try to attached with sql 2000 then give error (could not find sysindexes for database id 9 Run dbcc chack table on sysindexes) Please help me Thanks and Regards Azad Yadav
-
Dear Friends, I attached sql 2000 database in sql 2005 server and deattaching from 2005 again try to attached with sql 2000 then give error (could not find sysindexes for database id 9 Run dbcc chack table on sysindexes) Please help me Thanks and Regards Azad Yadav
I will be astonished if you can do this. The idea that you can take a 05 db back to 2000 seems unlikely in the extreme.
Never underestimate the power of human stupidity RAH
-
Dear Friends, I attached sql 2000 database in sql 2005 server and deattaching from 2005 again try to attached with sql 2000 then give error (could not find sysindexes for database id 9 Run dbcc chack table on sysindexes) Please help me Thanks and Regards Azad Yadav
use Integration Service and transfer your database from 2005 to 2000.because you can not restore 2005 on 2000 on usual ways
Human knowledge belongs to the world http://www.rad.pasfu.com/index.php
-
use Integration Service and transfer your database from 2005 to 2000.because you can not restore 2005 on 2000 on usual ways
Human knowledge belongs to the world http://www.rad.pasfu.com/index.php
Hello, If you have modified the structure of your database or introduced features specific to SQL Server 2005 like PIVOT in a view or stored procedure, bad luck. Try to reattach your database to your SQL Server 2005 , check if the compatibility level of your database is always 80 ( SQL Server 2000 ). If yes, bad luck, if it is 90, try to modify it to 80. Detach it properly and try to reattach it to your SQL Server 2000. You have a little hope of success ( except if you have introduced features specific to 2005 )