October 13, 2014 at 10:31 am
I tried to turn on T3226 by both using DBCC TRACEON (3226,-1) and changing the SQL Server startup parameter directly. The startup log showed that the flag had been turned on:
Registry startup parameters:
-d E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf
-e E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG
-l E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
-T 3226
However, successful backup jobs are still being logged. Has anyone experienced the same problem?
October 14, 2014 at 3:09 pm
Use DBCC TRACESTATUS to check whether the trace flag has been applied correctly.
If not, something is wrong with your startup options.
-- Gianluca Sartori
October 14, 2014 at 3:26 pm
Thanks for the response. I had done that. I did it again just to show the results:
dbcc tracestatus (-1)
TraceFlagStatusGlobalSession
32261 1 0
October 14, 2014 at 3:34 pm
Weird... does it work if you set it with DBCC TRACEON directly (I mean, without setting in the startup params)?
-- Gianluca Sartori
October 14, 2014 at 4:16 pm
As I said in the initial post, I had tried it both ways and it dod not work either way.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply