Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Suspect
Message
From
07/06/2001 06:48:40
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Recovery
Title:
Suspect
Miscellaneous
Thread ID:
00516204
Message ID:
00516204
Views:
49
Hi I was wondering if anyone could help me,

Overnight my database server hung. On restarting I have discovereds that one of my larger databases is suspect. Looking through the error logs there are 3 messages, the first of which being:

Error 8941, severity 22, state 101
Table Corrupt: ObjectID 1881972 IndexID 1 Page (0:885578193), Test(offset+Len < PAGESIZE) failed slot 1, offset 0x1180 is invalid

second being
Error 3313, Severity 21, state 2
Error while redoing logged operation in database OSIS error at log record ID 5256:5935:2

and finally
Error 3414, severity 21, state1
Database OSIS (datbaseID 7) could not recover contact tech support


I have looked for help in BOL, the SQL Server WW user group and Microsoft product support and can find no details on error 8941, I think I now which table is corrupt but canbnot get into the database to do anything about it. Also, due to the tardiness of myt software supplier, have not got a back up of this new database (over 18 million records imported over the last fortnight, awaiting SQL Agent for veritas backup)

Is there anything I can do or is it a start from scratch job?

Any help/Advice would be greatly appreciated.

Regards,

Ben Sugden
Ben Sugden

"Remember to enjoy hunting - and that means relishing the search for the product that has never been advertised or placed handily at the front of the shop; Life begins on the uppermost shelf, avoid guide books and top 10's like the plague." - Ramsey Dukes
Next
Reply
Map
View

Click here to load this message in the networking platform