<div>
Yes you can change the name of the files but you will have to attach the db again. And its always a best practice to take a backup of your data incase something goes wrong.<br />
<br />
Aash.
</div>


Yes you can change the name of the files but you will have to attach the db again. And its always a best practice to take a backup of your data incase something goes wrong.

Aash.

<div>
matrix_aash proposes a solution for the physical files, mine is for the logical filenames. &nbsp;Choose the appropriate path for your need
</div>


matrix_aash proposes a solution for the physical files, mine is for the logical filenames.  Choose the appropriate path for your need

<div>
Thanks very much, folks. &nbsp;It works!
</div>


<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
Is there a way to change the internal names of the data and log files on SQL Server? &nbsp;(Like, change &quot;my_db_data&quot; to &quot;my_other_db_data&quot;?<br />
<br />
Thanks!<br />
BrianMc1958 &nbsp;
</div>
</div>


Dear Experts,

Is there a way to change the internal names of the data and log files on SQL Server?  (Like, change "my_db_data" to "my_other_db_data"?

Thanks!
BrianMc1958  

Can I change internal names of .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.