Uwe Ricken (8/1/2015)
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?
Hi Uwe ,
You are right. But I think that it is only a little error.
I have used this command 3 months for a SQL Server 2012 database and I have done some research about this topic in the SQL Server 2012 documentation which is easier to understand than the the SQL Server 2014 one.