August 16, 2012 at 3:22 pm
I just got a SQL alert:
What does it mean, I see it generates some errors in sql log, see attachment.
It looks it is related with sharepoint serach account. But I see our sharepoint server runs OK.
It did not tell me what database name though, this is going to be hard for me to troubleshoot, because we have quite a few sharepoit databases on the server.
What to do to troubleshoot this?
It looks like the
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:5243
Date:8/16/2012
Time:1:21:50 PM
User:mydomain\sys$searchshptportal
Computer:SQL1
Description:
An inconsistency was detected during an internal operation. Please contact technical support. Reference number 8.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 14 00 00 16 00 00 00 {.......
0008: 09 00 00 00 53 00 4e 00 ....S.N.
0010: 4f 00 43 00 53 00 51 00 O.C.S.Q.
0018: 32 00 30 00 00 00 1a 00 2.0.....
0020: 00 00 53 00 68 00 61 00 ..S.h.a.
0028: 72 00 65 00 64 00 53 00 r.e.d.S.
0030: 65 00 72 00 76 00 69 00 e.r.v.i.
0038: 63 00 65 00 73 00 32 00 c.e.s.2.
0040: 5f 00 53 00 65 00 61 00 _.S.e.a.
0048: 72 00 63 00 68 00 5f 00 r.c.h._.
0050: 44 00 42 00 00 00 D.B...
August 16, 2012 at 4:25 pm
Contact Customer Support at Microsoft.
August 17, 2012 at 4:13 am
And make sure your backups have been running for the last several days. Make a copy of the backups. If you have log backups prior to the error, make sure you have a copy of those too. You may be going into a DR scenario soon.
Personal choice, I'd run DBCC on the database to see if I can spot an error or a problem even before I'd call Microsoft.
"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
August 19, 2012 at 6:30 pm
It turns out everything works fine.
We did a DBCC check on each database, there is no error.
So not sure what happened.
Thanks,
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply