<div>
Panic over. The mdf and ldf in the file system were named correctly.<br />
I just had to use:<br />
alter database myDB<br />
MODIFY FILE (NAME = MyDB_data, NEWNAME = MyDBTest_data)<br />
<br />

</div>


Panic over. The mdf and ldf in the file system were named correctly.
I just had to use:
alter database myDB
MODIFY FILE (NAME = MyDB_data, NEWNAME = MyDBTest_data)



<div>
<div class="content wysiwyg-content">
I restored a DB from a backup of a different DB (same structure just the name is different e.g. MyDB and MyDBTest).<br />
Usually I do this via a script but I got lazy and used the EM GUI.<br />
All works well but the mdf and ldf are called MyDB_data.mdf and MyDB_log.ldf<br />
How can I rename them to MyDBTest_data.mdf and MyDBTest_log.ldf<br />
<br />
This is a test area at the moment so I have no issues with stopping services, kicking people out etc.
</div>
</div>


I restored a DB from a backup of a different DB (same structure just the name is different e.g. MyDB and MyDBTest).
Usually I do this via a script but I got lazy and used the EM GUI.
All works well but the mdf and ldf are called MyDB_data.mdf and MyDB_log.ldf
How can I rename them to MyDBTest_data.mdf and MyDBTest_log.ldf

This is a test area at the moment so I have no issues with stopping services, kicking people out etc.

rename mdf and ldf

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.