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