meirulexite
asked on
Fatal error 7105 in SQL
Hello,
I get "Warning: Fatal error 7105 occurred at Jun 28 2007 7:35AM. Note the error and time, and contact your system administrator." when trying to read from one of my tables,
If I try to read another part of a table I can, it seems there are some lines that are corrupt.
I'm using SQL 2005
I get "Warning: Fatal error 7105 occurred at Jun 28 2007 7:35AM. Note the error and time, and contact your system administrator." when trying to read from one of my tables,
If I try to read another part of a table I can, it seems there are some lines that are corrupt.
I'm using SQL 2005
Run DBCC CHECKDB to check the concistency of your database.
ASKER
I got a bunch of these:
"Msg 8929, Level 16, State 1, Line 1
Object ID 1189579276, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046054400 (type In-row data): Errors found in off-row data with ID 6494945280 owned by data record identified by RID = (1:3941:5)"
"There are 3434 rows in 29 pages for object "PNR".
CHECKTABLE found 0 allocation errors and 28 consistency errors in table 'PNR' (object ID 1189579276).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (airkenya.dbo.PNR).
DBCC execution completed. If DBCC printed error messages, contact your system administrator."
My SQL is on a hosted service and they are not replying to me, should I ask them to restart the serivce?
How can I solve this on my own without data loss?
"Msg 8929, Level 16, State 1, Line 1
Object ID 1189579276, index ID 1, partition ID 72057594040877056, alloc unit ID 72057594046054400 (type In-row data): Errors found in off-row data with ID 6494945280 owned by data record identified by RID = (1:3941:5)"
"There are 3434 rows in 29 pages for object "PNR".
CHECKTABLE found 0 allocation errors and 28 consistency errors in table 'PNR' (object ID 1189579276).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (airkenya.dbo.PNR).
DBCC execution completed. If DBCC printed error messages, contact your system administrator."
My SQL is on a hosted service and they are not replying to me, should I ask them to restart the serivce?
How can I solve this on my own without data loss?
ASKER
Can this be a lock only? and not a problem with the DB?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.