December 10, 2003 at 9:09 am
To be clear I do not mean transaction logs for the database.
How to I adjust the size of the SQL Server logs? (The ones in Enterprise Manager, under the Management node of the tree) Right now, they are too big and take too long to access.
Thanks!
Chris.
Chris.
December 10, 2003 at 10:19 am
sp_cycle_errorlog will close the current error log and open a new one without restarting SQL Server. See "sp_cycle_errorlog" in BOL.
Greg
Greg
December 11, 2003 at 6:12 am
If you right click on your SQL Server Logs and select "Configure", you can specify how many logs to keep. Then, just setup a job to run sp_cycle_errorlog every few hours. This should keep the logs down to a managable size.
Jarret
December 11, 2003 at 9:13 am
see also http://www.sqlservercentral.com/scripts/contributions/946.asp
Francis
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply