Share via


How to: Archive more that six SQL Server Error Logs using SSMS / EM

The following post describes how you can configure your SQL Server to archive more than six Errorlog files using SSMS (2008, 2005) or Enterprise Manager GUI.

While I was aware of MS KB # 196909, that describes a way of increasing the number of SQL Server error logs, by way of Registry change, I was looking for something simpler via GUI.

I could finally found a way of doing this from MS-SQL GUI (SSMS or EM) as below:

For SQL 2008 and SQL 2005: via SQL Management Studio

Screen 1.

image

Screen 2.

image

For SQL 2000: via Enterprise Manager

Screen 1.

image

Screen 2.

image 

Well, that actually made my job lil simpler !

Disclaimer: I work at Microsoft. Everything here, though, is my personal opinion and is not read or approved by Microsoft before it is posted. No warranties or other guarantees will be offered as to the quality of the opinions or anything else offered here.

Comments

  • Anonymous
    January 31, 2010
    This is really amazing thing. I wonder MICROSOFT didnot cover in the KB?