question

Steve Jones - Editor avatar image
Steve Jones - Editor asked

SQL Server Error Logs

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

sql-serveradministration
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Kev Riley avatar image
Kev Riley answered

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

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

user-110 avatar image
user-110 answered

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

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.