• It's one alter command per file when modfying, never been a bother for me

    you're only typing multiple alter statements, not as if it's a hardship 😉

    ALTER DATABASE somedb MODIFY FILE

    What you could have done though is this

    ALTER DATABASE [NAME]

    MODIFY FILE ( NAME = NAME, FILENAME =

    "D:\Data\NAME.mdf")

    ALTER DATABASE [NAME]

    MODIFY FILE ( NAME = NAME_log, FILENAME =

    "L:\Logs\NAME_log.ldf")

    Then when you're ready issue

    ALTER DATABASE [NAME] SET OFFLINE WITH ROLLBACK IMMEDIATE;

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

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