April 15, 2015 at 2:50 am
hi,
Below 2 Error has been written in event viewer.please let me know the cause of below error.
1) 7105, Severity: 22, State: 6
Page (1:3638570), slot 62 for text, ntext, or image node does not exist..
2) Error -2147467259: Warning: Fatal error 7105 occurred at Apr 2 2015 3:05PM
i don't know at what action is causing this error
Minal
April 15, 2015 at 2:57 am
You have a corrupt database.
When did you last run a successful database consistency check?
What backups do you have?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 15, 2015 at 4:35 am
You need to do this now. Run DBCC CHECKDB. Identify the objects that have allocation issues. You might get lucky. If it's a nonclustered index you can just drop and recreate it. If not, as Gail says, you'd best have good backups ready to go.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply