Post reply

Sql server logs

  • February 5, 2014 at 11:07 pm

    #282018

    Hi every one,

    I want to remove or clear log file viewer from sql server logs in sql server 2012 kindly i need help.

    Thanks & regards

    Rajnidas

  • February 5, 2014 at 11:33 pm

    #1686452

    These files are located in Log with name "ERRORLOG" in the installation drive of your SQL SERVER with the following name "ERRORLOG". By Default there are three files.

    you can either simply delete these files from the this folder OR Cut & paste preserve them on a separate location for any further analysis.

    one question thou, why you want to clear these files ?

    hope it helps

  • February 6, 2014 at 12:23 am

    #1686461

    By default there are 6 files. You won't be able to delete the active log and to be honest you shouldn't be messing directly with files that SQL works with.

    Why do you want to delete them? To cover up something that is logged in the error log that you don't want others to see? Or is the current log just too large and you want to create a new empty log?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 6, 2014 at 12:38 am

    #1686465

    If you want to create a new log use sp_cycle_errorlog

  • February 6, 2014 at 12:45 am

    #1686467

    Thanks for reply to all

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

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