Home » SQL Server » How to Recycle SQL Server error logs – 5 Types of logs

How to Recycle SQL Server error logs – 5 Types of logs

1) Recycle SQL Error log

exec msdb..sp_cycle_errorlog

2) Recycle SQL Agent Error log

exec msdb..sp_cycle_agent_errorlog

3) Recycle(rollover) SQL Server Default trace

EXEC sp_configure ‘default trace’, 0 RECONFIGURE

EXEC sp_configure ‘default trace’, 1 RECONFIGURE

4) Recycle SQLFT#.Log

a. Before 2008 – restart the indexer

b. After 2008 – no way to cycle to full text log without restarting SQL server

5) Recycle FDLAUNCHERRORLOG

a. Restart FDLauncher service


10 Comments

  1. Homepage says:

    Excellent blog here! Also your web site loads up fast! What host are you using? Can I get your affiliate link to your host? I wish my website loaded up as quickly as yours lol 873333

  2. Alberto Neer says:

    Really appreciate you sharing this blog post.Really thank you! Cool.

  3. Very good post.Really thank you!

  4. A big thank you for your blog post.Thanks Again. Really Great.

  5. Teresa Wynn says:

    Thanks-a-mundo for the article post.Really thank you! Want more.

  6. Sergio Riker says:

    A round of applause for your article post.Thanks Again. Want more.

  7. Major thankies for the blog.

  8. Very neat blog post.Really looking forward to read more. Want more.

  9. Hey sweet heart from a young womanreader contunue the awe inspiring writing

  10. antioxidants says:

    I came here expecting something else, but this entertained me regardless. Enlightening stuff!

Leave a Reply

Join us on Facebook

microsoftcommunitycontributor
%d bloggers like this: