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 |
|
feejaz
Yak Posting Veteran
68 Posts |
 Posted - 2008-02-06 : 07:22:39
|
| Hi,I m going to attach my databse file to newly installed sqlserver 2000 personel eddition. But when I click the ok button (right click on the database> alltasks> attachdatabase> ). I found the error likeError 602: Could not find row in sysindexes for database ID 7, Object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.Can anyone tell me how can I do this to attach database.Navi |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-06 : 10:22:47
|
| Have you checked DBCC CHECKDB on the originator DB and see whether there was any corruption related to that db?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
feejaz
Yak Posting Veteran
68 Posts |
Posted - 2008-02-06 : 10:28:38
|
| I m true biggner to sqlserver. Plz explain how I can do thisNavi |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-06 : 23:22:55
|
| Run 'dbcc checkdb(db_name)' on source server. |
|
|
|
|
|
|
attaching database to sql 2000 personel eddition