Can Somebody Suggest?

  • http://www.sqlservercentral.com/Forums/Topic801373-5-1.aspx

    Thanks!

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • Only thing I aheav seen similiar

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89075

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • Silverfox (10/12/2009)


    Only thing I aheav seen similiar

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89075%5B/quote%5D

    yeah I saw to this post before but that situation is a little different.

    my master database is fine but the error message reads as:

    - B 0 0 1 4 0 9 7 00 2d 00 42 00 30 00 30 00 31 00 34 00 30 00 39 00 37

    7 5 ' , ' E A S T 00 37 00 35 00 27 00 2c 00 27 00 45 00 41 00 53 00 54

    T - B 0 0 1 4 0 9 00 54 00 2d 00 42 00 30 00 30 00 31 00 34 00 30 00 39

    9 7 4 ' , ' E A S 00 39 00 37 00 34 00 27 00 2c 00 27 00 45 00 41 00 53

    S T - B 0 0 1 4 0 00 53 00 54 00 2d 00 42 00 30 00 30 00 31 00 34 00 30

    7 6 8 9 ' , ' E A 00 37 00 36 00 38 00 39 00 27 00 2c 00 27 00 45 00 41

    A S T - B 0 0 1 4 00 41 00 53 00 54 00 2d 00 42 00 30 00 30 00 31 00 34

    5 6 1 2 5 ' , ' E 00 35 00 36 00 31 00 32 00 35 00 27 00 2c 00 27 00 45

    E A S T - B 0 0 1 00 45 00 41 00 53 00 54 00 2d 00 42 00 30 00 30 00 31

    1 5 6 1 2 4 ' , ' 00 31 00 35 00 36 00 31 00 32 00 34 00 27 00 2c 00 27

    ' E A S T - B 0 0 00 27 00 45 00 41 00 53 00 54 00 2d 00 42 00 30 00 30

    0 1 8 3 2 0 9 ' , 00 30 00 31 00 38 00 33 00 32 00 30 00 39 00 27 00 2c

    , ' E A S T - B 0 00 2c 00 27 00 45 00 41 00 53 00 54 00 2d 00 42 00 30

    0 0 1 8 5 0 5 6 ' 00 30 00 30 00 31 00 38 00 35 00 30 00 35 00 36 00 27

    ' , ' E A S T - B 00 27 00 2c 00 27 00 45 00 41 00 53 00 54 00 2d 00 42

    B 0 0 1 8 5 0 5 5 00 42 00 30 00 30 00 31 00 38 00 35 00 30 00 35 00 35

    4 ' , ' E A S T - 00 34 00 27 00 2c 00 27 00 45 00 41 00 53 00 54 00 2d

    and then after scrolling a bit

    20: Frame: 1805A13C Return Address 0070B2C5

    19: Frame: 1805A12C Return Address 0070B2C5

    18: Frame: 1805A11C Return Address 0070B2C5

    and so on

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • What version of sql are you running, you have 2 separate posts in 2 different forums. can you show more of the sql log

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • Silverfox (10/12/2009)


    What version of sql are you running, you have 2 separate posts in 2 different forums. can you show more of the sql log

    Yeah, since it is happening with my SQL Server 2000 box so earlier I posted it in SQL Server 2000 forum.

    I am running SQL Server 2000 EE with SP4 in a cluster environment with A/P/A kind of setup.

    The portion of the error log I have attached here..before and after this entries I just only have normal database backup events.

    The attached portion of error log is only the culprit.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • One another thing is that, from my SQL Server Exception Error Log, I have noticed this entry:

    02/29/08 08:53:29 spid 685 Exception 0xc00000fd EXCEPTION_STACK_OVERFLOW at 0x00402074

    08/15/08 15:28:20 spid 0 Exception 0x400042ac PRINTSTACK at 0x77E55DEA

    08/15/08 15:28:24 spid 0 Exception 0xc000001d EXCEPTION_ILLEGAL_INSTRUCTION at 0x77E55DEA

    08/15/08 15:28:25 spid 0 Exception 0xc000001d EXCEPTION_ILLEGAL_INSTRUCTION at 0x77E55DEA

    10/11/09 00:32:54 spid 366 Exception 0xc00000fd EXCEPTION_STACK_OVERFLOW at 0x0070B281

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • is sharepoint on that cluster ?

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • Silverfox (10/12/2009)


    is sharepoint on that cluster ?

    No. Its just a dedicated Production SQL Box.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • I can only suggest that you go throught all the window logs for that time period and check that any jobs and all backups have been verified as succesfully completed. unless this is a regular occurrance, until something becomes apparent, you might have to wait and see if it happens again.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • Silverfox (10/12/2009)


    I can only suggest that you go throught all the window logs for that time period and check that any jobs and all backups have been verified as succesfully completed. unless this is a regular occurrance, until something becomes apparent, you might have to wait and see if it happens again.

    Yeah! Actually, window's log is not complaining anything for that time period (even before and after 12 hours).

    Backup for all the databases have been verified.

    I am currently running a sanity check on this production box to check any possible corruption anywhere. I actually have 180 databases on this server.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

  • Good luck with that, not an easy thing to troubleshoot. let us know if you fix it 🙂

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • I raised it in connect. Lets see if they support it there.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply