Trace Flag

Question

Post reply

Trace Flag

Chandra Sekhara Vyas Dhara

SSChampion

Points: 10207
More actions
October 29, 2014 at 10:52 pm

#294586

Comments posted to this topic are about the item Trace Flag
October 30, 2014 at 1:57 am

This was removed by the editor as SPAM

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

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

Hany Helmy SSChampion Points: 13921 More actions · Answer 1

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

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Great question, thanks.

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

RKaram SSCommitted Points: 1518 More actions · Answer 3

RKaram

SSCommitted

Points: 1518

October 30, 2014 at 2:00 am

#1755700

Very nice question!:-)

rabih

rkaram

Toreador SSChampion Points: 11365 More actions · Answer 4

I'm never very good at these historical questions 🙁

TomThomson SSC Guru Points: 104773 More actions · Answer 5

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 More actions · Answer 6

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/

Umer Akram SSC-Insane Points: 22209 More actions · Answer 7

Umer Akram

SSC-Insane

Points: 22209

October 30, 2014 at 6:41 am

#1755752

Nice question. Thanks for sharing

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 8

akljfhnlaflkj

SSC Guru

Points: 76202

October 30, 2014 at 7:00 am

#1755758

Thanks for the question.

david.gugg SSCertifiable Points: 6090 More actions · Answer 9

Good question, learned something new.

Thank you

Be still, and know that I am God - Psalm 46:10

Ed Wagner SSC Guru Points: 287026 More actions · Answer 10

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

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 11

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: 24685 More actions · Answer 12

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: wsmelton.github.com
Github: wsmelton

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 13

pmadhavapeddi22

SSCertifiable

Points: 5306

October 30, 2014 at 11:36 pm

#1755963

learnt something new today