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
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
Really appreciate you sharing this blog post.Really thank you! Cool.
Very good post.Really thank you!
A big thank you for your blog post.Thanks Again. Really Great.
Thanks-a-mundo for the article post.Really thank you! Want more.
A round of applause for your article post.Thanks Again. Want more.
Major thankies for the blog.
Very neat blog post.Really looking forward to read more. Want more.
Hey sweet heart from a young womanreader contunue the awe inspiring writing
I came here expecting something else, but this entertained me regardless. Enlightening stuff!