Forum Replies Created

Viewing 15 posts - 32,821 through 32,835 (of 49,552 total)

  • RE: GHOST CLEANUP locked up my system

    Might be time to contact CSS at this point. Those look nasty.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 18, 2010 at 11:10 pm

    #1169228

  • RE: GHOST CLEANUP locked up my system

    Dan Guzman - Not the MVP (5/18/2010)

    Restores just tell me the db is in Recovery, wait until it's finished.

    What does the error log say about msdb?

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 18, 2010 at 10:49 pm

    #1169221

  • RE: DBCC CHECKDB Consistency Error

    cos_ta393 (5/18/2010)

    Gail, thanks for your time and input. I have a meeting with my boss on Friday and I will present both recommendations - I will keep you posted. Mainwhile...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 18, 2010 at 10:49 pm

    #1169220

  • RE: Shrinking Log Files -Best Practice

    Please read through this - Managing Transaction Logs[/url]

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 18, 2010 at 8:37 am

    #1168863

  • RE: Backup successful but can't write to msdb - due to space issues backups of msdb limited

    Please post new questions in a new thread. Thank you.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 18, 2010 at 6:45 am

    #1168773

  • RE: Reporting Spam

    Reported that one already.

    I just report and trust that Steve (or whoever else picks up the report) will check it out

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 18, 2010 at 6:44 am

    #1168772

  • RE: Transaction Log

    There's no documented way to read the transaction log.

    If you're feeling like a challenge, you can use fn_dblog

    SELECT * FROM fn_dblog(null, null)

    however it's not the easiest to understand, the...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 18, 2010 at 6:38 am

    #1168762

  • RE: Incorrect PageID while attaching MDF?

    Just a word of warning. There's no guarantee that this will be repairable, that the database will be attachable at all. Depends on where that corruption is within the file....

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 18, 2010 at 1:04 am

    #1168610

  • RE: SQL Server 2000 Datbase Crash

    Definitely game over. Error indicates that there's damage to the structures that identify the files within the database, it thinks it has a file that it cannot have. That's not...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 18, 2010 at 1:02 am

    #1168609

  • RE: Incorrect PageID while attaching MDF?

    If it's a SQL 2000 database and it's damaged, I would strongly suggest that you install SQL 2000 and get it attached there (may need hacking in).

    By attaching to 2008,...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 17, 2010 at 6:40 pm

    #1168542

  • RE: DBCC CHECKDB Consistency Error

    Sounds like someone may have messed with the system tables back on SQL 2000 and no one caught it. Odd, syskeys isn't even in any of my SQL 2005 database,...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 17, 2010 at 6:36 pm

    #1168541

  • RE: Procedure Stats

    rdouglas66 (5/17/2010)

    Microsoft have replied to the Connect Issue and have confirmed that they will be changing the documentation about this DMV.

    Thanks for the feedback.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 17, 2010 at 6:28 pm

    #1168540

  • RE: SQL Server 2000 Datbase Crash

    Wesley Brown (5/17/2010)

    If the physical log is corrupt it is corrupt.

    I don't think it's the log that's corrupt (or at least not just the log). If it was only the...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 17, 2010 at 8:52 am

    #1168308

  • RE: Are the posted questions getting worse?

    jcrawf02 (5/17/2010)

    GilaMonster (5/17/2010)

    If that is plagiarised, MS needs to be informed (I know a couple people I can speak to there), seeing as that is an MSDN blog.

    Note that...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 17, 2010 at 7:54 am

    #1168268

  • RE: Are the posted questions getting worse?

    If that is plagiarised, MS needs to be informed (I know a couple people I can speak to there), seeing as that is an MSDN blog.

    Note that there's some...

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 17, 2010 at 7:29 am

    #1168255

Viewing 15 posts - 32,821 through 32,835 (of 49,552 total)