Post reply

SQL Server Logs

  • December 10, 2003 at 9:09 am

    #59513

    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

    #485578

    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

    #485690

    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

    #485741

    see also http://qa.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