SQL Tip-4 | Do you know you can increase number of archived Errorlogs

Sarabpreet Singh Anand

SQLServer - MVP Sarabpreet is SQLServer MVP, Consultant, Speaker, Trainer, Blogger and Community Lead. You can find him speaking at a local UG Event or a SQL Webcast. He has 11+ years of Experience and worked with Industry Leaders. He has many SQL Certifications under his belt. His core competency lies in administration of SQL Server. Always ready to help, online \offline. His life’s mantra is “Knowledge Increases by sharing so, Pass it on”.

You may also like...

2 Responses

  1. July 27, 2013

    […] Note: Make sure you also increase the Archived error log retention before recycling your errorlog else you may end up loosing your old errorlogs: Do you know you can increase number of archived Errorlogs […]

  2. August 4, 2013

    […] In my first SQL Tip Don’t forget to recycle your SQLServer ErrorLog I listed some common problems you may face if you are not recycling your errorlogs timely. However, I do understand the criticality and importance of Error Log that’s the reason I also suggested you to increase the retention of your Error Logs in another tip Do you know you can increase number of archived Errorlogs. […]

Leave a Reply