Error attaching a Database from another server

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

General SQL Server Forums

New to SQL Server Programming

Error attaching a Database from another server

Author

Topic

ann06
Posting Yak Master

171 Posts

Posted - 2008-11-10 : 07:33:11

hi there,
iam trying to attach a database where the .mdf and .ldf files were directly copied from the folders without the detach option,he made this because he didnt find interface for the sql to do the detach/ or backup thing
iam trying to attach to another server to do some testing but its failing to attach the db
error 602: could not find row in sysindexes for database id 12, object id 1, index id 1, run dbcc checktable on sysindexes

how to attach this iam using sql 2000
thanks

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2008-11-10 : 08:10:29

Run the db checks. Hope, the 2 versions of sql server are the same. Are they ?

ann06
Posting Yak Master

171 Posts

Posted - 2008-11-10 : 08:32:49

i don't think they are the same, also how can i run the db check without knowing the table names its a closed box for me, what to use in case there is no interface and how to do?

malaytech2008
Yak Posting Veteran

95 Posts

Posted - 2008-11-10 : 08:35:05

This can be happend if the file corrupted.

malay

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2008-11-10 : 08:36:11

Is the source version sql2005 or 2008 ? I know 2000 is where you are tring to restore it.

ann06
Posting Yak Master

171 Posts

Posted - 2008-11-10 : 08:46:37

as source sql 2005 express