Skip to main content

Change the logical Name of a MS SQL database



The process to change the logical name for the database and the log file is  the same 


ALTER DATABASE [DataBaseName
   MODIFY FILE ( NAME = OldLogicalName
      NEWNAME = NewLogicalName );

ALTER DATABASE [DataBaseName 
   MODIFY FILE ( NAME = OldLogicalNameLog
      NEWNAME = NewLogicalNameLog );

Comments

Popular posts from this blog