• when the database is in full recovery model and you delete a log file, it will still list in sys.database_files and sys.master_files.

    You must take a transaction log backup and the file will be removed from the catalogs mentioned above.

    For databases in simple recovery the file will go immediately!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉