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

avatar image

Steve Jones - Editor ♦♦
5.1k 79 93 87

(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

avatar image

Kev Riley ♦♦
63.8k 48 61 81

(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

avatar image

user-110
53 1 1 3

(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:

x408
x131

asked: Oct 12, 2009 at 01:03 PM

Seen: 2205 times

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

Copyright 2016 Redgate Software. Privacy Policy