Minggu, 13 Maret 2011

SQL Server: How to Avoid Big Single Error Log File on Production Servers

One thing, strange I found on our production database servers was a BIG SINGLE Error log file. It was taking long time to open and exploring it for required information was even worse. This happened because production database servers never go down and SQL Server is keeping error log to a single file. On every restart SQL Server initiates a new error log file but for production servers, restart

Tidak ada komentar:

Posting Komentar