bertrandkis
Programmer
Hi all, I am restoring a database from a backup file and everything goes well right until the end but instead of getting the confirmation message,I get this Error Message:
COULD NOT FIND ROW IN SYSINDEXES FOR DATABASE ID 8,OBJECT ID 1,INDEX ID 1.RUN DBCC CHECKTABLE ON SYSINDEXES
When I click OK, the restore database dialog box does not go away and give the OK and Cancel option.If I click OK, the restore process restarts, if I click cancel, the database is left in Loading State and no database object is restored. Is there a way to tell SQL server to ignore the message and complete the restore, so that I can fix the Index problem?
COULD NOT FIND ROW IN SYSINDEXES FOR DATABASE ID 8,OBJECT ID 1,INDEX ID 1.RUN DBCC CHECKTABLE ON SYSINDEXES
When I click OK, the restore database dialog box does not go away and give the OK and Cancel option.If I click OK, the restore process restarts, if I click cancel, the database is left in Loading State and no database object is restored. Is there a way to tell SQL server to ignore the message and complete the restore, so that I can fix the Index problem?