Forum Replies Created

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

  • RE: Transaction log SHRINK

    Vedran Kesegic (1/12/2013)

    But there is one more thing that checkpoint does to the log in regard of log truncation.

    Checkpoint is one of several prerequisites for log clearing.

    Yes, I'm well...

    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

    January 13, 2013 at 1:09 am

    #1576668

  • RE: Recovering to a Marked Transaction

    From Books Online:

    logmarkhistory

    Contains one row for each marked transaction that has been committed. This table is stored in the msdb 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

    January 12, 2013 at 2:24 pm

    #1576632

  • RE: Recovering to a Marked Transaction

    GilaMonster (1/12/2013)

    Use T-SQL. I gave you the restore outline.

    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

    January 12, 2013 at 11:21 am

    #1576619

  • RE: Transaction log SHRINK

    muthukkumaran Kaliyamoorthy (1/12/2013)

    Have a look Truncating and shrinking the transaction log file[/url]

    Also take a look @ http://www.sqlserverblogforum.com/2011/06/sql-server-recovery-models-and-backup-types/

    There's a bunch of errors in both of those, just beware (but that should...

    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

    January 12, 2013 at 11:18 am

    #1576618

  • RE: DBCC CheckDB errors after export from SQL 2000 and import into SQL 2008R2

    As I said, in SQL 2000 incorrect page usage stats was acceptable, in 2005 and above it's considered an error.

    Since you're upgrading from SQL 2000, you have gone from a...

    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

    January 12, 2013 at 10:03 am

    #1576612

  • RE: Transaction log SHRINK

    Vedran Kesegic (1/12/2013)

    You may benefit a little from that checkpoint step becase there is certain amount of time passed between implicit checkpoint that happens within tran log backup command and...

    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

    January 12, 2013 at 9:57 am

    #1576609

  • RE: Recovering to a Marked Transaction

    Is the mark within the selected log backup? For that matter, have you selected a log backup to restore?

    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

    January 12, 2013 at 9:56 am

    #1576608

  • RE: DBCC CheckDB errors after export from SQL 2000 and import into SQL 2008R2

    Just do what the messages tell you to. In SQL 2000 incorrect page usage stats was acceptable, in 2005 and above it's considered an error.

    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

    January 12, 2013 at 9:55 am

    #1576606

  • RE: IO Errors

    SQLSACT (1/12/2013)

    Where do you draw the line between this, when does code become "bad code".

    When testing shows that it performs badly.

    Performance tuning is based on testing, not guesswork. Find...

    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

    January 12, 2013 at 8:46 am

    #1576588

  • RE: Recovering to a Marked Transaction

    Err... wild guess... simple recovery model?

    No log 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

    January 12, 2013 at 8:43 am

    #1576587

  • RE: Transaction log SHRINK

    jonathanforster (1/12/2013)

    1) I've already run the first 80GB tlog backup and was under the impression that every subsequent tlog backup would be the same size until I used a SHRINK...

    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

    January 12, 2013 at 7:56 am

    #1576573

  • RE: 70-467 BI exam - how do I prepare for this?

    Nasreenm (1/12/2013)

    Thanks. I think Microsoft should provide an official training kit if it doesn't want people using brain dumps...

    Sorry, think that a lack of hand-holding training guides is a...

    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

    January 12, 2013 at 7:51 am

    #1576572

  • RE: Recovering to a Marked Transaction

    zi (1/12/2013)

    I made a tran mark , and I cant find it in the GUI SSMS to restor the log at this point

    What should I do

    Use T-SQL. I gave 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

    January 12, 2013 at 7:48 am

    #1576571

  • RE: Recovering to a Marked Transaction

    zi (1/12/2013)

    -what about this message when I write the transaction mark for the second time

    The WITH MARK option only applies to the first BEGIN TRAN WITH MARK statement. The option...

    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

    January 12, 2013 at 6:03 am

    #1576565

  • RE: IO Errors

    SQLSACT (1/12/2013)

    In your opinion, what's a better approach: Changing the T-SQL Code or adding indexes to accomodate the code ?

    Yes.

    Adding indexes is useless if the problem is in the code....

    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

    January 12, 2013 at 6:01 am

    #1576564

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