0

I need to find out if Trace Rollover is enabled on my SQL Server 2005 machine. Where can I find this out and turn it on if I need to?

wahle509
  • 333
  • 1
  • 2
  • 8

1 Answers1

0

When you start a new trace you'll see the "Trace Properties". On the General tab select "Save to file". Then you can set the max. file size & mark the "Enable file rollover" box.

EDIT: This is not a general setting, but is on a per-trace basis.

Frank Kalis
  • 161
  • 1