Error Log Maintenance

18 May
Default is 6 error log for the MS SQL server 2008. In order to ease the reading of the log file and keep the log files small, you can do the following:
1. Increase the log file

2. Recycle the error log (create a new)

  • EXEC sp_cycle_errorlog
3. Add SQL Agent for scheduling
  • SQL Server Agent – Jobs – Right mouse click and new jobb
  • Add under steps what to run (e.g command)
  • Add under schedule when to run and how often

 

  • Start SQL Server Agent
Advertisements

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: