Forum Replies Created

Viewing 15 posts - 22,066 through 22,080 (of 49,552 total)

  • RE: Error message - dbcc checkdb and error in log file

    The errors in that DB are the cause of the log errors.

    As for 'take care of it later', that DB is not repairable. If you don't have a clean...

    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

    November 21, 2011 at 9:15 am

    #1410814

  • RE: Error message - dbcc checkdb and error in log file

    Is KLSite30 the database you ran the CheckDB on?

    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

    November 21, 2011 at 8:57 am

    #1410787

  • RE: Error message - dbcc checkdb and error in log file

    Restore from backup.

    If you're in full recovery with log backups, take a tail-log backup first then restore full and all log backups since then. You'll restore with no data loss....

    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

    November 21, 2011 at 8:35 am

    #1410771

  • RE: Perfmon Numbers INTERPRET THESE NUMBERS - NEED OPINION\SUGGESTIONS

    Read through the articles I posted, or read through chapters 1 and 3 (at least) of this: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Or both.

    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

    November 21, 2011 at 8:32 am

    #1410765

  • RE: Helpful Advice?

    Oh don't even get me started.

    The latest thing that really gets me is people writing blog posts recommending things like this (or deleting transaction logs, detaching suspect databases, etc, etc)...

    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

    November 21, 2011 at 8:27 am

    #1410763

  • RE: MCDBA certification

    Dev (11/21/2011)

    Sometimes I feel it's a formality only.

    MCM: US$3,000

    $2500, assuming you pass both exams (which are very far from mere formalities) first time. That excludes training or study...

    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

    November 21, 2011 at 7:17 am

    #1410706

  • RE: Shrink and backup

    imilikic (11/21/2011)

    What you should know is that on a daily basis I need to work automatically back up but before that to reduce the log file that grows quite every...

    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

    November 21, 2011 at 7:10 am

    #1410698

  • RE: Perfmon Numbers INTERPRET THESE NUMBERS - NEED OPINION\SUGGESTIONS

    NM

    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

    November 21, 2011 at 7:02 am

    #1410688

  • RE: Shrink and backup

    3rd party monitoring tools are typically how people do things, but I get yelled at by posters when I refer them to solutions that require money instead of built-in T-SQL...

    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

    November 21, 2011 at 1:05 am

    #1410515

  • RE: Shrink and backup

    sys.databases, sys.database_files, sp_spaceused

    First 2 for one instance, last is per-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

    November 21, 2011 at 12:42 am

    #1410508

  • RE: How can we resolve Log full message in SQL Server 2008

    jnuqui (11/21/2011)

    switch to simple recovery model. Backup database then shrink the log.

    Sample below:

    USE testdatabase

    DBCC shrinkfile ( Employees_log, 1)

    DO BACK UP FIRST!

    mind you that if your using FULL...

    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

    November 21, 2011 at 12:33 am

    #1410505

  • RE: SQLServer restart History

    It's not going to be in any table or DMV.

    You can use the error logs for the most recent. Unless cycled, a new error log is started each time SQL...

    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

    November 21, 2011 at 12:29 am

    #1410503

  • RE: suspect_pages => pageID => what's next?

    p.s. DO NOT restart the server. DO NOT detach the DB. Do not try any repair techniques that you may find for now. CheckDB results first, then a decision on...

    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

    November 21, 2011 at 12:25 am

    #1410502

  • RE: suspect_pages => pageID => what's next?

    No, that doesn't look good at all. Post the CheckDB results (exactly what it returns) and I'll let you know how bad it is.

    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

    November 21, 2011 at 12:22 am

    #1410500

  • RE: Shrink and backup

    Chris Metzger (11/20/2011)

    That's what we do in our environment - backup trans logs every two hrs with a rolling 24 hr retention period (to cover time between full backups). ...

    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

    November 21, 2011 at 12:20 am

    #1410499

Viewing 15 posts - 22,066 through 22,080 (of 49,552 total)