Loading

How To Change Name Of Database.mdf exixts Physically

Vikas Singh

10y1.1kSQL

We can change the name of database through command and it reflect in SqlServerManagement Studio But the name do not get change physicallyy stored in MSSqlServer/Data folder on the System.

How We Do That

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nikhil Sangani10y ago
hello Vikas Singh,
I hope this will helpful for you.
1.Rename SQL Server Database using T-SQL
ALTER DATABASE oldName MODIFY NAME = newName
or
EXEC sp_renamedb 'oldName', 'newName'
2.Rename SQL database using detach and attach
EXEC sp_detach_db 'oldName', 'true'
EXEC sp_attach_db @dbname = N'newName', @filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\test.mdf', @filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\test_log.ldf'