SQL Server Performance Forum – Threads Archive

Changing DB logical filename

I restore .bak to different server with new dbname in EM but it kept the old logical filename. How can I update the logical filename to new name?

---

ALTER DATABASE DatabaseName
MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name)

---

By the way if you are going to perform other modifications to the database useing ALTER DATBASE, it is recommended you use multiple ALTER DATABASE statments for optimal performance. <img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />

---

Note that the Alter Database statment only work on SQL 2000. There is no supported way to change logical filename in SQL 7 and below. Having different logical filename on a database doesn’t impact functionality.

---

True but it could confuse some one, so if you are running 2000 I would go ahead and change the file name as well it wont hurt.

---

]]>