Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

At my company I need to create a Trace on our SQL Server (for a workload file), that should run for several days. However, The Server is turned off every night, so the trace dies. How do I make a Trace that will continue automaticaly on the next day?

share|improve this question

Have you thought about using Server Side Traces (SST)- it's essentially rhe same thing, but without the Profiler GUI. You can start it and stop it through SQL Server jobs - and hence you can tell SQL Agent to start the SST when SQL Server starts.

They are easy to do when you get the hang of them, and you can script it all out of Profiler too!

See also:,_Why,_and_How

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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