SQL DBA Posts - How to rename Logical Files of a SQL Server database?

There are couple of easy ways described below to rename logical files of a SQL Server Database.


Method 1

                  USE master;

GO
ALTER DATABASE sqlage_test
MODIFY FILE ( NAME = SqlAge_Test, NEWNAME = SqlAge_modified_test )


Method 2

1-      Right click on the database that you would like to rename files of and go to properties

2-      Click on File

3-      Click on Logical File Name and renaming it

4-      Click on Ok
Fig 1 - How to rename SQL Server Database Logical Files
Fig 2 - How to rename SQL Server Database Logical Files