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

Advertisements

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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: