• That is correct, you cannot drop the first created (primary) data or log file . If you want to move this you will incur some minimal downtime.

    Create your alter database ... modify file statement and run it. Then perform the following

    • take the database offline.
    • Copy the log file to the new location
    • once copied bring the database back online
    • Once the database is online delete the old file

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

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