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
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar