February 13, 2006 at 2:37 pm
In 2k5
C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
there is a log file that can get very big. Does anyone know where to set the size of these errorlogs. So that they can not become a gig?
February 14, 2006 at 9:07 am
Not an Integration Services question, but... You get a new error log each time SQL Server is restarted. However, in order to keep the size of the logs smaller, you should schedule a job to call sp_cycle_errorlog every couple of weeks or so. Then you'll get a smaller error log. Just remember that there are only x number available (6 by default) and that cycling them will mean that eventually you may lose older error information.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply