How do I dump the MS SQLServer error log? Use sp_ cycle_errorlog to cycle your MS SQLServer error logs. Create an agent job to cycle logs periodically.