SQL Trace ID 1 Stopped

• JohnnyDBA

  SSCertifiable

  Points: 6355

  More actions

  January 17, 2011 at 8:06 am

  #233303

  One of our SQL Server 2005 instances ran out of disk space over the weekend and the log had the following information in it:

  Trace ID '1' was stopped because of an error. Cause: 0x80070070(There is not enough space on the disk.). Restart the trace after correcting the problem.

  How do I restart the trace? I can't seem to find information online.

  Thanks!

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  January 17, 2011 at 8:28 am

  #1274260

  I did a quick search and found this:

  http://www.sqlservercentral.com/blogs/jeffrey_yao/archive/2010/08/13/restart-sql-server-default-trace.aspx

  (I have not tested or verified it)

• JohnnyDBA

  SSCertifiable

  Points: 6355

  More actions

  January 18, 2011 at 4:27 pm

  #1275044

  That's what I was looking for! Thanks!

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  January 20, 2012 at 4:16 am

  #1436361

  Please confirm it is system responsibility to start and stop the trace?

  Thanks