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 |
go langaunage online training
ReplyDeleteazure online training
java online training
salesforce online training
hadoop online training
This post is so useful and informative. Keep updating with more information.....
ReplyDeleteJava Training
Thanks for the clear explanation! Renaming logical files in SQL Server isn't something that comes up every day, but it's super useful to know when managing databases or prepping for migrations. Your detailed steps and examples really help demystify the process.
ReplyDeleteAlso, for anyone looking to strengthen their overall QA and database testing skills, I recently found a great resource for Best software testing training in Hyderabad – definitely worth checking out if you're diving deeper into the tech field.
Great post! Renaming logical files in SQL Server can be a bit tricky if you’re not familiar with the proper steps, and your explanation really simplifies the process. The examples and clear commands are super helpful — definitely bookmarking this for future reference.
ReplyDeleteAlso, for those looking to strengthen their foundation in software testing, I’d recommend checking out this Manual testing training in Hyderabad
— it’s been a great resource for grasping core testing concepts alongside database knowledge.
Very informative post! Renaming logical files in SQL Server can be a bit tricky if you're not familiar with the right steps. Your explanation, especially the use of ALTER DATABASE and SET OFFLINE, really clears things up. It’s great to see detailed DBA tips like this shared so clearly.
ReplyDeleteFor those branching out into other areas of tech, especially automation testing, I found this Best Selenium online training in Hyderabad quite useful – definitely worth checking out if you're looking to upskill!