Post reply

SQL Server Logs

  • December 10, 2003 at 9:09 am

    #162744

    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 2:28 pm

    #485610

    SQL server uses an error log file each time it reboots.

    You can use a new error log file by executing sp_cycle_errorlog.

  • December 11, 2003 at 3:37 am

    #485676

    DBCC Errorlog

    will do it for you.

    Carl

    CEWalden


    CEWalden

  • December 11, 2003 at 7:09 am

    #485705

    The following script appeared on this site a couple of weeks ago. You might find it useful.

    http://qa.sqlservercentral.com/scripts/contributions/946.asp

    Rob

  • December 11, 2003 at 11:18 am

    #485784

    Also, you can increase the quantity of log files retained by right clicking on "SQL Server Logs" in Enterprise Manager, click on "Configure...", click the check box and modify the quantity.

    Steve

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply