¿Cómo cambio el nombre de un archivo físico en SQL Server?

How do I rename a physical file in SQL Server?

Open SQL Server Management Studio and right click on the database we want to change and select Properties. Choose the “Files” tab from the left pane. The below screen will appear where you can see the current physical file names along with other details.

Rename a database using SQL Server Management Studio

1. In Object Explorer, connect to your SQL instance.
2. Make sure that there are no open connections to the database.
3. In Object Explorer, expand Databases, right-click the database to rename, and then click Rename.
4. Enter the new database name, and then click OK.

4 Answers

1. Use SSMS to take the database Offline (right-click on Database, select Tasks, Take Offline), change the name of the files at the OS level and then Bring it Online.
2. You could Detach the database, rename the files and then Attach the database pointing to the renamed files to do so.

Step 1: Logical file names can also be changed using SQL Server Management Studio. Select the database in Object Explorer and right click on the database and select Properties. On the Files page, we can see the logical file names.

In the Navigation Pane, double-click the table in which you want to rename the field. The table is opened in Datasheet view. Right-click the column heading for the field that you want to rename, and then click Rename Field on the shortcut menu. Type the new name for the field and then press ENTER.

Renaming the Database Select the database you wish to rename from the left hand column and then click on Operations. Select a database in phpMyAdmin. Enter the new database name in the field “Rename database to:” and click Go. Renaming the database.

Attach a SQL Server Database Using SSMS To attach the database, right click on Databases and select Attach… on the SQL Server instance where you want to attach the database. The following screen opens. Click on the Add button to find the mdf file that you want to attach, select the file and click OK.

Open Microsoft SQL Server Management Studio. Connect to the server wherein the DB you want to rename is located. Go to the location that MDF and LDF files are located and rename them exactly as you specified in first two alter commands. If you changed the folder path, then you need to move them there.

Go to the location ( C://Program Files//Microsoft SQL Server//MSSQL10_50.MSSQLSERVER//MSSQL//DATA//…) where the physical files are located and rename them to the NewDatabaseName you specified in number 2. Remember to check the absolute path of these files to be used on your computer. Go back to Microsoft SQL Server Management Studio.

If we want to rename any physical file, it is not possible to rename the file while the file is in the use. For the same reason, first, we will have to take the database offline.

I have blogged about it here: SQL SERVER – Rename Logical Database File Name for Any Database. Right after the blog post, I received another question where the user wanted to know if there is an easy way to rename the physical file. In this blog post, we will learn about how to rename the physical database files name.

The physical file name is the name of the actual file in the Windows operating system. When we rename a database, the database name changes but the physical database file name remains same. This can be confusing to identifying the corresponding database for the files.