• Hi Patrick,

    maybe but this will lead to a wrong answer (as in my case). So - I'm not crazy about the points but the answers are ALL wrong from the Syntax!

    Query 1: no comment 🙂

    Query 2: ADD FILE does not work with "NEWNAME"-Parameter

    Query 3: ALTER DATABASE does not have a Parameter called OLDNAME

    Query 4: no comment 🙂

    Any of the answers may lead to a wrong decision.

    If you are concentrated to the MODIFY FILE only (which is nearest to the answer) you will fail (as I did).

    I've tuned out all ADD FILE commands.

    However - let's see what Steve will do.

    Have a wonderful Sunday and all the best to the sqlservercentral-community...

    Microsoft Certified Master: SQL Server 2008
    MVP - Data Platform (2013 - ...)
    my blog: http://www.sqlmaster.de (german only!)