Forum Replies Created

Viewing 15 posts - 29,431 through 29,445 (of 49,552 total)

  • RE: Data deleted - how to tell when? (using .bak and .trn)

    ps. (11/11/2010)

    Check out for 3rd party tools. Apex log reader allows you to read from transaction log backups.

    But costs around $1000 per licence.

    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 11, 2010 at 6:13 am

    #1249441

  • RE: Data deleted - how to tell when? (using .bak and .trn)

    nealhudson77 (11/11/2010)

    I would have thought a 'Transaction Log File' would give you this, seeing as by definition it should hold every transaction in the database?

    The transaction log is there for...

    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 11, 2010 at 6:01 am

    #1249430

  • RE: 2 processors, 4 cores but 8 threads

    It was true of the old hyperthreaded processors (the ones that were released prior to the true multi-core processors). It may not be true of the new hyperthreading that's in...

    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 11, 2010 at 5:41 am

    #1249413

  • RE: 2 processors, 4 cores but 8 threads

    2 quad core processors means that you have 8 physical cores in the server. Are they recent processors (i7 for eg) If so, they may have hyperthreading which means there...

    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 11, 2010 at 5:28 am

    #1249408

  • RE: Low Memory usage / Large Transaction Log

    It's a job. Check SQL Agent's running job list.

    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 11, 2010 at 5:15 am

    #1249405

  • RE: Low Memory usage / Large Transaction Log

    That means you have a long-running transaction open that's keeping the log large. You need to identify and fix that and whatever caused it before you decide what to do...

    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 11, 2010 at 4:04 am

    #1249396

  • RE: Low Memory usage / Large Transaction Log

    It did exactly as it was supposed to. Log backups do not shrink the file. Never have.

    If the log has grown excessively large, do a once off shrink. By excessively...

    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 11, 2010 at 3:55 am

    #1249394

  • RE: Low Memory usage / Large Transaction Log

    shutts318ci (11/11/2010)

    I have changed the mode to "simple" and managed to shrink the log, but now it is growing at an ever faster rate, it's 17gb after 20 mins. I...

    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 11, 2010 at 3:45 am

    #1249391

  • RE: Low Memory usage / Large Transaction Log

    shutts318ci (11/11/2010)

    I've set it back to full, running a full backup again. Then will try "BACKUP LOG dbname" is that the correct format? WITH TRUNCATE_ONLY no longer works as it's...

    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 11, 2010 at 3:42 am

    #1249390

  • RE: Low Memory usage / Large Transaction Log

    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

    November 11, 2010 at 2:33 am

    #1249353

  • RE: Help needed to make an identical copy of a db in SQL 2000

    Elliott Whitlow (11/11/2010)

    I'm going to make a simple really painful statement.. Your data will not all be recoverable.. Some may but not all. Tables that are 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

    November 11, 2010 at 2:28 am

    #1249347

  • RE: fork a process

    Service broker. Async messaging.

    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 11, 2010 at 12:22 am

    #1249281

  • RE: What is a passing score on 70-432?

    The pass mark is 700.

    There is no available in formation on how the exam is graded.

    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 11, 2010 at 12:21 am

    #1249280

  • RE: Model Database log file is full

    Steve Jones - SSC Editor (11/10/2010)

    If you're not sure, check the default trace for activity.

    Default trace won't have queries in it. Object create/drop yes, but not normal DML.

    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 10, 2010 at 9:22 am

    #1248987

  • RE: Why SHRINKFILE is a very bad thing, and what to do about it.

    satalaj (11/10/2010)

    Is there any better way to deal with such big log files.

    Yes. Stop shrinking it and find out why it's getting that size. It may be that it...

    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 10, 2010 at 8:43 am

    #1248938

Viewing 15 posts - 29,431 through 29,445 (of 49,552 total)