SQL Server Error Logs

How do I increase the number or error logs that SQL Server keeps?

asked Oct 12 '09 at 01:03 PM in Default

Steve Jones - Editor ♦♦
5.1k ● 74 ● 78 ● 82

(comments are locked)

2 answers:

There is a registry edit you can make, see this support article for 2000 and 2005.

Also in 2005 and 2008, there is an option in SSMS, when you right click 'SQL Server Logs' and choose Configure

Edit: links for SSMS : SQL2005, SQL2008

answered Oct 12 '09 at 01:28 PM

Kev Riley ♦♦
46.1k ● 38 ● 43 ● 69

I don't see anywhere in SSMS to change the # of error logs when connected to a 2005 server.

Oct 12 '09 at 03:37 PM Jack Corbett

@Jack: what menu options do you get when you right-click 'SQL Server Logs' in Object Explorer?

Oct 12 '09 at 04:12 PM Kev Riley ♦♦

I see configure and recycle. When I select Configure I can change the location of the erro logs and I can change what is logged (error, warning, information), but not the # of logs kept.

Oct 12 '09 at 11:06 PM Jack Corbett

What version of SSMS are you using?

Oct 13 '09 at 03:46 AM Kev Riley ♦♦

Just checking - you are looking at SQL Server Error Logs and not SQL Server Agent Error Logs? I get the options you mentioned when right clicking and selecting configure on SQL Server Agent Error Logs.

Oct 13 '09 at 04:57 AM Kev Riley ♦♦

(comments are locked)