Post reply

unable to delete sql error log files

  • October 6, 2008 at 2:37 pm

    #75332

    Hello

    I am trying to delete sql error log files from a log folder, the error log file is now 175 mb, and I am wondering why it is not creating multiple error log files. When ever I am trying to delete that error log file I get an errror message

    "there has been sharing violation, source or destination file may be in use".

    does anyone know the solution.

    abhisek

  • October 6, 2008 at 3:21 pm

    #881355

    You should be able to delete any of the log files except the current one, which is the one with no extension. The older log files would have the extensions .1, .2, etc. If you only have one file, have a member of sysadmin run sp_cycle_errorlog to close the current one and open a new one.

    Greg

  • October 7, 2008 at 8:25 am

    #881705

    thanks that proc really helped me.

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

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