• Provided the log file is empty you can delete it. Ensure you have regulare log backups, do a shrink file and empty it.

    DBCC SHRINKFILE (N'Scratch_log' , EMPTYFILE)

    Then you should be able to delete the file.

    Cheers

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.