Hi, all masters here, please help me for attaching database to the SQL Server 2005 then. I cant attach any database to my SQL Server 2005! Error as below always happened!
could not find row in sysindexes for database ID 21, object ID 1, index ID 1, Run DBCC CHECKTABLE on sysindexes
So what is indeed the problem tho? please help me then. Thanks a lot.
Hi,
seems that your data is corrupt in any way, did you try to attach the database via
sp_attach_single_file_db, this normally ignores some checks but could leave your database inconsistent (maybe), so better use a copy to try that.
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
|||Hi,Jens,
Thanks a lot. I tried to attach the database files with sql scripts then but only those database files which are created on the SQL Server could be attached. Those database files created outside of my local computer wont work tho (even the sample databases installed from SQL Server CD!). The error occured as I posted above. So what is exactly the problem tho? What can I try to fix it? Really need help and thanks a lot.
Kind regards,
No comments:
Post a Comment