SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


get a SQL alert


get a SQL alert

Author
Message
sqlfriends
sqlfriends
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3945 Visits: 4025
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...
Attachments
Capture.GIF (13 views, 40.00 KB)
Lynn Pettis
Lynn Pettis
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40800 Visits: 38567
Contact Customer Support at Microsoft.

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: General Forum Members
Points: 41761 Visits: 32666
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

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
sqlfriends
sqlfriends
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3945 Visits: 4025
It turns out everything works fine.
We did a DBCC check on each database, there is no error.

So not sure what happened.

Thanks,
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search