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!)