Post reply

command to create new sql server error log ?

  • August 17, 2004 at 6:09 am

    #86057

    What is the command to create a new sql server error log without having to stop and restart SQL Server

  • August 17, 2004 at 6:51 am

    #519320

    sp_cycle_errorlog

  • August 17, 2004 at 6:52 am

    #519321

    You are looking for sp_cycle_errorlog.

    One thing you can do with this is create a job that runs the command once a week as part of your maintenance.

    -SQLBill

Viewing 3 posts - 1 through 2 (of 2 total)

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