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

http://mssqlfun.wordpress.com/2012/07/26/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

http://msdn.microsoft.com/en-us/library/ms142495(SQL.105).aspx

the Full-Text Search crawl logging facility creates and maintains a crawl log, which is a plain text file

a. Before 2008 – restart the indexer

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

5) Recycle FDLAUNCHERRORLOG

SQL Full-text Filter Daemon Service Error Log (FDLAUNCHERRORLOG)

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/04/06/how-to-move-fdlauncherrorlog-from-one-location-to-another-in-sql-2008.aspx

a. Restart FDLauncher service