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

3 comments:

  1. This post is so useful and informative. Keep updating with more information.....
    Java Training

    ReplyDelete
  2. Excellent Useful for everyone Thank you so much for sharing..

    ELearn Infotech offers Java Training in Hyderabad by Industry Experts. Our realtime Java Course includes from Basic to Advanced Level concepts. We have designed our Java course content based on students Requirement to Achieve their Goal. We offer both Java classroom training in Hyderabad and Java online training with real-time projects. We are one of the leading Java Training Institutes in Hyderabad.

    ReplyDelete