There are couple of easy ways described below to rename logical files of a SQL Server Database.
USE master;
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 |
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.