x

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 newest

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.3k 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

user-110
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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x348
x127

asked: Oct 12, 2009 at 01:03 PM

Seen: 2009 times

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