Steps to change the default location of SQL Server /SQL Server Agent – Error log files

  Recently came across a customer scenario, wherein the ‘ask’ was to change the current location of SQL Server Errorlog files to a different location. Here’s a simple way to get this done: Steps to change Location of SQL Svr Errorlog files Step 1. First, identify the current location of SQL Server Errorlog files. Refer…

0

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…

1

How to: Verify path for SQL Server Error Log Files

Hello Friends, March has been a busy month, and it is not over yet. Taking some time off to blog;  as small find “worth sharing”. While managing a SQL Server instance, there are so many different locations to look for MSSQL files, like SQL Server Error Logs. While we can easily locate path to SQL…

5