How to Change Logical Name of Database in SQL Server

How to Change Logical Name of Database in SQL Server


Now we want to change from TestMoveMDFLDF to TestMoveMDFLDF_Data

Method 1:

select * from sys.database_files where name = 'Logicalname' and type_desc='ROWS'

select * from sys.database_files

see through query of logical name as see below

Method 2:

EXEC SP_HELPDB dbname



Method 3:

Logical and physical name through below query

Select sd.name as DatabaseName,sm.Name as logicalname,physical_name from sys.master_files sm
join sys.databases  sd on sm.database_id=sd.database_id
where sd.name='TestMoveMDFLDFSTD'

We should need to execute below query to alter new logical name see below


ALTER DATABASE TestMoveMDFLDFSTD
            MODIFY FILE (NAME=N'TestMoveMDFLDF', NEWNAME=N'TestMoveMDFLDF_Data')​

EXEC SP_HELPDB dbname

You can see Logical name is changed

that is logical name is changed it