|
| Hello!
I have SQL Server 6.5 on Windows 2000 Server.
Having problem with the database all of a sudden. Database went into
Suspect Mode & users could not connect. I looked up the blogs on google
& i saw that changing the status of database in sysdatabases will fix
the problem. It did but i have another problem now. I am having an
error:
"Attempt to fetch logical page 22883844 in database 'abc' belongs to
object '-18317505', not to object 'Conflicts'"
I did the following:
1) I ran rebuild indexes on all the tables. All the tables were rebuilt
successfully except for the above table 'Conflicts'
2) I ran update statistics on all the tables. Command ran successfully
on all tables except for the above table 'Conflicts'
I now thought the data in the conflicts table is corrupt and i went
added with
3) I ran CheckTable on Conflicts.
In all the cases above, it gave me the same error.
I cannot take restore as i dont have a backup. But i do have data
device files which are on tape. I dont know how i can use the data
device files on SQL Server to retrieve the database.
Any ideas!
Please help me. Need to fix this asap as this happened on production
server.
Thanks a lot!
Vijay.
|
|