Trace Flag

  • Chandra Sekhara Vyas Dhara

    SSChampion

    Points: 10207

    Comments posted to this topic are about the item Trace Flag

  • Hany Helmy

    SSChampion

    Points: 13291

    Nice question & a good feature will think to get use of it.

  • Koen Verbeeck

    SSC Guru

    Points: 258859

    Great question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • This was removed by the editor as SPAM

  • RKaram

    SSCommitted

    Points: 1518

    Very nice question!:-)

    rabih

    rkaram

  • Toreador

    SSChampion

    Points: 11220

    I'm never very good at these historical questions 🙁

  • TomThomson

    SSC Guru

    Points: 104707

    Nice question. At one point I would have found a means of logging full and incremental backups but not log backups useful, but that feature has never been provided.

    Tom

  • ksatpute123

    Hall of Fame

    Points: 3325

    This trace flag has existed for some time but was documented only in SQL 2008.

    It works for SQL 2008, 2005 and 2000 SP4 (not tested) update.

    Here is the source with more clarification.

    http://www.mssqltips.com/sqlservertip/1457/stop-logging-all-successful-backups-in-your-sql-server-error-logs/

  • twin.devil

    SSC-Insane

    Points: 22208

    Nice question. Thanks for sharing

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the question.

  • david.gugg

    SSCertifiable

    Points: 5599

    Good question, learned something new.

    Thank you


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

  • Ed Wagner

    SSC Guru

    Points: 286950

    A very good question - thanks. I learned something new and think I'm going to use it.

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Ed Wagner (10/30/2014)


    A very good question - thanks. I learned something new and think I'm going to use it.

    +1 (except the "using" part)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Shawn Melton

    SSC-Insane

    Points: 24554

    This trace flag is still available in current versions, and will probably never go away. This is a part of my checklist for installations and is always enabled.

    I would like to see this become an option that we can enable with sp_configure or similar. Just like successful logins is handled.

    Shawn Melton
    Twitter: @wsmelton
    Blog: blog.wsmelton.info

  • pmadhavapeddi22

    SSCertifiable

    Points: 5306

    learnt something new today

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply