Default Trace Logs - Increase Size

[topub]

The default trace file that is located in the following location:

~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_1.trc
~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_2.trc
~\Program Files\Microsoft SQL Server\MSSQL\LOG\log_3.trc
....
....
....

How do I configure to increase the file size and the max. number of files for rollover? The default size is suppossed to be 32MB with retention period of 14 days before deletion. But in my servers case, the size is defaulting to 512KB.... thats just too small.

I looked at sys.configurations, but did not see any option for that. It has a flag to enable or disable trace logs but not on size.

Any help would be great...

thanks,
UB

 

[mkal]

You need to open the trace in Sql Profiler. Once it's opened you will notice on the Trace Properties dialog box (General tab) that you have the ability to change:

Save to file
Set Maximum file size (MB)
Enable rollover
or
Save to table if that would work better.

Hope that helps.