• Hi Steve,

    seems to be NONE of the given examples are correct 🙂

    USE [mydb]

    GO

    ALTER DATABASE [mydb]

    MODIFY FILE

    (

    NAME=N'OldName',

    NEWNAME=N'NewName_01'

    );

    GO

    I assume that you have forgotten to change the ADD FILE to MODIFIY FILE.

    Can you check your answers?

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