Post reply

Trace Flag

  • October 31, 2014 at 9:56 am

    #1756074

    ksatpute123 (10/30/2014)

    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.

    Yes, an excellent QOTD. (And, as it turns out, a repeat of pretty much the same question from 2007.)

    I have used this for years in SQL 2000 SP3. It was a big problem for us, backing up about 200 DBs every half hour. I learned about the flag from that original 2007 QOTD and it has been a lifesaver. Note that I found it only works as a startup parameter, not in DBCC:

    http://www.sqlservercentral.com/Forums/Topic419450-34-1.aspx#bm420623

  • November 13, 2014 at 5:16 am

    #1758191

    Comparatively easy one. 🙂

  • January 30, 2015 at 11:24 am

    #1774437

    +1 Thank you, favorite search engine!

Viewing 3 posts - 16 through 17 (of 17 total)

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