Cloud & SQLSailor

Cloud, Databases & Beyond!

How can we rename the logical file name of a data and log file


There are instances where in we need to rename the files and below simple Alter command will do that for you : ALTER DATABASE  <Database> MODIFY FILE (NAME = <Current Name> , NEWNAME = <New Name>)  

Leave a comment