Rename database file

You agree that your use of the Script and any impacts on your software, databases, systems, networks or other property or services are solely and exclusively at your own risk.

You hereby release Datavail from any claims, causes of action, losses, damages, costs and expenses resulting from your downloading or other use of the Script.

These terms and conditions constitute your complete and exclusive legal agreement between you and Datavail. With more than 20 years of experience as an IT professional, JP carries a wealth of customer support, problem-solving, writing, and team management experience.

All are available at www. Outside of work, JP enjoys traveling and sampling exotic foods around the world. Related Posts. Vijay Muthu February 4, Esayas Aloto February 28, Craig Mullins April 6, Subscribe to Our Blog Never miss a post!

Now our target database has been detached. Our next step is to rename the physical database files that you want to rename. Go to the location of your database files in Windows and rename the files as needed. You can find the location of the files as shown in Step 1. Now we will attach this database with the modified file names. Once you click on "Attach Click on the "Add Once you click on the "Add Choose the necessary data file and click the OK button to proceed.

Once you attach the primary data file as we did in the above screenshot, the interface will show the corresponding secondary data files and log files for the database as shown below. One thing you might notice in the below screenshot is last column "Message" shows that the files are "Not Found" for each database file. This is because the system catalog is not updated in SQL Server, so when you select a mdf file it will show all of the associated files for the attached mdf file.

That is why when we choose the mdf file it shows the older database file names. Now we need to manually select each database file and choose the correct file for each one we renamed. Popular Articles. Rolling up multiple rows into a single row and column for SQL Server data.

How to tell what SQL Server versions you are running. Resolving could not open a connection to SQL Server errors. Ways to compare and find differences for SQL Server tables and data. Searching and finding a string value in all columns in a SQL Server table. View all my tips. Back To Top After trying different sites with their explanations, this covered it percent.

Thank you. Monideepa In order to rename a database you have to have exclusive access, so you need to get everyone out of the database first. Hi, If I need to rename my DB while it is being accessed by other customers across the world can I use the same method? Hi, I executed below remane db command on sql server and it works succefully. How to get succeed in the job? Please help me Is there any project, I can do practice in my leasure time Please SQList wrote: One important thing that was missed is that objects in other databases, like functions, views, procedures, that refer to the old name of the database need to be updated as well.

Toe make sure you dont miss them you can check using: Oh, be careful now. It could also be a good thing to change teh logical name to before detaching the 'old' database. Greg, I wanted to know your opinion on the following procedure of renaming the database: 1. Perform full database backup on the database that you want to rename 2. Delete database that needed to be renamed 3.

Create new database with the desire new name 4. If the database you're renaming was set as the default database of a SQL Server login, they may encounter Error , Cannot open user default database. Use the following command to change the default to the renamed database:.

Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode.