February 18, 2009 at 7:15 pm
Hi To All SQL DB Admin,
I am a newbie in SQL and I hope the community can help me with my problem... I need your kind assistance.
We are maintaining 2 production database. We always encounter hanging of the system whenver we are accessing this one database. This happened since last Friday, February 13 until now. When this happened, we cannot anymore access the DB through Enterprise Manager and we are left with no choice but to restart the system. After restart the system and DB is already ok. The last time we encountered it is just yesterday and when we access the tables in DB, it displays a message that it is in a suspect mode and when we restart it, then its ok. Also, when we run scheduled shrink and backup of this DB, it always failed since that date. Below is the usual error we encounter:
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17052
Date:02/18/2009
Time:6:43:30 PM
User:N/A
Computer:RETAILIGENCE
Description:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Data:
0000: 00 00 00 00 13 00 00 00 ........
0008: 0d 00 00 00 52 00 45 00 ....R.E.
0010: 54 00 41 00 49 00 4c 00 T.A.I.L.
0018: 49 00 47 00 45 00 4e 00 I.G.E.N.
0020: 43 00 45 00 00 00 0d 00 C.E.....
0028: 00 00 52 00 65 00 74 00 ..R.e.t.
0030: 61 00 69 00 6c 00 69 00 a.i.l.i.
0038: 67 00 65 00 6e 00 63 00 g.e.n.c.
0040: 65 00 00 00 e...
===================================================
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17052
Date:02/18/2009
Time:6:43:38 PM
User:N/A
Computer:RETAILIGENCE
Description:
Error: 3314, Severity: 21, State: 4
Error while undoing logged operation in database 'Retailigence'. Error at log record ID (1090042:35957:77).
Data:
0000: f2 0c 00 00 15 00 00 00 ò.......
0008: 0d 00 00 00 52 00 45 00 ....R.E.
0010: 54 00 41 00 49 00 4c 00 T.A.I.L.
0018: 49 00 47 00 45 00 4e 00 I.G.E.N.
0020: 43 00 45 00 00 00 0d 00 C.E.....
0028: 00 00 52 00 65 00 74 00 ..R.e.t.
0030: 61 00 69 00 6c 00 69 00 a.i.l.i.
0038: 67 00 65 00 6e 00 63 00 g.e.n.c.
0040: 65 00 00 00 e...
====================================================
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17052
Date:02/18/2009
Time:6:43:38 PM
User:N/A
Computer:RETAILIGENCE
Description:
Error: 9001, Severity: 21, State: 1
The log for database 'Retailigence' is not available.
Data:
0000: 29 23 00 00 15 00 00 00 )#......
0008: 0d 00 00 00 52 00 45 00 ....R.E.
0010: 54 00 41 00 49 00 4c 00 T.A.I.L.
0018: 49 00 47 00 45 00 4e 00 I.G.E.N.
0020: 43 00 45 00 00 00 0d 00 C.E.....
0028: 00 00 52 00 65 00 74 00 ..R.e.t.
0030: 61 00 69 00 6c 00 69 00 a.i.l.i.
0038: 67 00 65 00 6e 00 63 00 g.e.n.c.
0040: 65 00 00 00 e...
==================================================
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17052
Date:02/18/2009
Time:6:43:38 PM
User:N/A
Computer:RETAILIGENCE
Description:
Error: 3314, Severity: 21, State: 4
Error while undoing logged operation in database 'Retailigence'. Error at log record ID (1090042:35957:77).
Data:
0000: f2 0c 00 00 15 00 00 00 ò.......
0008: 0d 00 00 00 52 00 45 00 ....R.E.
0010: 54 00 41 00 49 00 4c 00 T.A.I.L.
0018: 49 00 47 00 45 00 4e 00 I.G.E.N.
0020: 43 00 45 00 00 00 0d 00 C.E.....
0028: 00 00 52 00 65 00 74 00 ..R.e.t.
0030: 61 00 69 00 6c 00 69 00 a.i.l.i.
0038: 67 00 65 00 6e 00 63 00 g.e.n.c.
0040: 65 00 00 00 e...
==================================================
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17052
Date:02/18/2009
Time:6:43:38 PM
User:N/A
Computer:RETAILIGENCE
Description:
Error: 3314, Severity: 21, State: 5
Error while undoing logged operation in database 'Retailigence'. Error at log record ID (1090042:5722:1).
Data:
0000: f2 0c 00 00 15 00 00 00 ò.......
0008: 0d 00 00 00 52 00 45 00 ....R.E.
0010: 54 00 41 00 49 00 4c 00 T.A.I.L.
0018: 49 00 47 00 45 00 4e 00 I.G.E.N.
0020: 43 00 45 00 00 00 0d 00 C.E.....
0028: 00 00 52 00 65 00 74 00 ..R.e.t.
0030: 61 00 69 00 6c 00 69 00 a.i.l.i.
0038: 67 00 65 00 6e 00 63 00 g.e.n.c.
0040: 65 00 00 00 e...
==================================================
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17052
Date:02/18/2009
Time:5:14:37 PM
User:N/A
Computer:RETAILIGENCE
Description:
Error: 644, Severity: 21, State: 3
Could not find the index entry for RID '164c3035393435365748495445333620202020202020202020202020202020202043444220205245300' in index page (1:1623472), index ID 0, database 'Retailigence'.
Data:
0000: 84 02 00 00 15 00 00 00 ?.......
0008: 0d 00 00 00 52 00 45 00 ....R.E.
0010: 54 00 41 00 49 00 4c 00 T.A.I.L.
0018: 49 00 47 00 45 00 4e 00 I.G.E.N.
0020: 43 00 45 00 00 00 0d 00 C.E.....
0028: 00 00 52 00 65 00 74 00 ..R.e.t.
0030: 61 00 69 00 6c 00 69 00 a.i.l.i.
0038: 67 00 65 00 6e 00 63 00 g.e.n.c.
0040: 65 00 00 00 e...
===================================================
I really hope someone can here can assist me. I am not a DB Admin Pro. I am only beginner. Thank you so much in advance!!!!
February 19, 2009 at 1:47 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic660010-146-1.aspx
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
February 19, 2009 at 4:02 am
Hello,
So the updgrade exam 2005 to 2008, 453, is out to do already, but there is no material to read from yet?
Regards,
D.
February 19, 2009 at 6:21 am
Duran (2/19/2009)
So the updgrade exam 2005 to 2008, 453, is out to do already, but there is no material to read from yet?
Please post unrelated questions in a new thread. The certification forum would be a good place.
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
February 19, 2009 at 6:10 pm
To GilaMonster
My apology sir. Sorry, it will not happen again.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply