up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question

20% accept rate
feedback

migrated from superuser.com Jan 14 '10 at 14:15

This question came from our site for computer enthusiasts and power users.

1 Answer

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.