Forum Replies Created

Viewing 15 posts - 151 through 165 (of 286 total)

  • RE: MSDB is having logical consistency-based I/O error

    Paul Randal (3/31/2010)

    I was the second opinion Gail was talking about. I monitor this forum but only usually jump in on the really nasty/obscure problems.

    Thanks

    Thanks Paul ! Also I saw...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 31, 2010 at 3:55 pm

    #1143528

  • RE: MSDB is having logical consistency-based I/O error

    Paul Randal (3/31/2010)

    I was the second opinion Gail was talking about. I monitor this forum but only usually jump in on the really nasty/obscure problems.

    Thanks

    Thanks Paul ! Also I saw...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 31, 2010 at 3:55 pm

    #1143527

  • RE: MSDB is having logical consistency-based I/O error

    Hello All,

    Just to update the post, I have restored msdb from previous backup and its working fine 🙂

    How ?

    stop sql agent --> as this will be accessing msdb

    restore msdb with...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 31, 2010 at 3:26 pm

    #1143516

  • RE: MSDB is having logical consistency-based I/O error

    Hello All,

    Just to update the post, I have restored msdb from previous backup and its working fine 🙂

    How ?

    stop sql agent --> as this will be accessing msdb

    restore msdb with...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 31, 2010 at 3:26 pm

    #1143515

  • RE: MSDB is having logical consistency-based I/O error

    Paul Randal (3/30/2010)

    Regardless of what the h/w diagnostics show, you do have a transient corruption problem with your I/O subsystem. That's the only these errors can occur, and to prove...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 30, 2010 at 12:07 pm

    #1142541

  • RE: MSDB is having logical consistency-based I/O error

    Paul Randal (3/30/2010)

    Regardless of what the h/w diagnostics show, you do have a transient corruption problem with your I/O subsystem. That's the only these errors can occur, and to prove...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 30, 2010 at 12:07 pm

    #1142540

  • RE: MSDB is having logical consistency-based I/O error

    Paul Randal (3/30/2010)

    Consistency error on the snapshot file itself doesn't in any way mean the actual database itself has corruptions - but it does mean the I/O subsystem that msdb...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 30, 2010 at 10:53 am

    #1142462

  • RE: MSDB is having logical consistency-based I/O error

    Paul Randal (3/30/2010)

    Consistency error on the snapshot file itself doesn't in any way mean the actual database itself has corruptions - but it does mean the I/O subsystem that msdb...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 30, 2010 at 10:53 am

    #1142461

  • RE: MSDB is having logical consistency-based I/O error

    GilaMonster (3/30/2010)

    Interesting... The error is in the snapshot that checkDB creates and uses...

    I've referred this to a corruption expert for assistance. It may be necessary to restore from your...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 30, 2010 at 9:33 am

    #1142364

  • RE: MSDB is having logical consistency-based I/O error

    Mistake ! ... double post please disregard this !

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 30, 2010 at 7:26 am

    #1142189

  • RE: Finding rows count in a table without Select...

    Hello,

    The script is fine but using MS_foreach is undocumented ! :hehe:

    I prefer to use:

    SELECT table_name,table_rows FROM (

    select so.name as table_name, si.rowcnt as table_rows,ROW_NUMBER() OVER (PARTITION BY SO.NAME ORDER BY si.rowcnt...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 26, 2010 at 7:33 am

    #1140329

  • RE: Finding rows count in a table without Select...

    Hello,

    The script is fine but using MS_foreach is undocumented ! :hehe:

    I prefer to use:

    SELECT table_name,table_rows FROM (

    select so.name as table_name, si.rowcnt as table_rows,ROW_NUMBER() OVER (PARTITION BY SO.NAME ORDER BY si.rowcnt...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 26, 2010 at 7:33 am

    #1140330

  • RE: TempDB Shrinking

    dpsahu30 (3/11/2010)

    Hi,

    If there is huge growth in tempdb size then,i suggest rebooting the server wont help much..so i think,we should findout why tempdb is growing so much and important is...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 12, 2010 at 7:21 pm

    #1133092

  • RE: Copy Files from one server to another

    Hello,

    I like powershell to do the job. Below is the code that I use: (modify as per your usage)

    $file = "F:\temp\Job_logs" ## this will be your backup file...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 5, 2010 at 9:55 am

    #1129281

  • RE: Database Corruption problems

    TheSQLGuru (3/4/2010)

    Sometimes just reading forums regularly helps to gain knowledge !

    Actually you didn't need to read this forum to gain knowledge. That stuff you watched has been on the...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

    March 4, 2010 at 6:02 pm

    #1128906

Viewing 15 posts - 151 through 165 (of 286 total)