SQL Server Error Logs

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

more ▼

asked Oct 12, 2009 at 01:03 PM in Default

Steve Jones - Editor gravatar image

Steve Jones - Editor ♦♦
5.1k 78 79 82

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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

more ▼

answered Oct 12, 2009 at 01:28 PM

Kev Riley gravatar image

Kev Riley ♦♦
54.1k 47 49 76

I don't see anywhere in SSMS to change the # of error logs when connected to a 2005 server.
Oct 12, 2009 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, 2009 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, 2009 at 11:06 PM Jack Corbett
What version of SSMS are you using?
Oct 13, 2009 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, 2009 at 04:57 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left

This link as the answer for 2005/08 - its basically a pictorial version of whats presented above http://www.mssqltips.com/tip.asp?tip=1835

more ▼

answered Oct 13, 2009 at 09:32 PM

user-110 gravatar image

53 1 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 12, 2009 at 01:03 PM

Seen: 1996 times

Last Updated: Oct 15, 2009 at 05:42 AM