Cannot change logical file name: The logical file name "PROD1" is already in use. Choose a different name
Try this:

What you have to do is, first set it to another name.

ALTER DATABASE [PROD] 
MODIFY FILE (NAME=N'PROD0', NEWNAME=N'PROD1Temp')
GO


The file name 'PROD1Temp' has been set.

Then change it back to PROD1 so that you can achieve your target.

ALTER DATABASE [PROD] 
MODIFY FILE (NAME=N'PROD1Temp', NEWNAME=N'PROD1')
GO


Some helpful links :

&#39;Logical file name &quot;MyDB&quot; is already in use&#39; Even though the database doesn&#39;t exist

https://stackoverflow.com/questions/7534664/sql-server-script-error-database-is-already-in-use