Renaming sql server database files

Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Submit and view feedback for This product This page. View all page feedback. She primarily focuses on the database domain, helping clients build short and long term multi-channel campaigns to drive leads for their sales pipeline.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check , we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours. Once you learn my business secrets, you will fix the majority of problems in the future. SQL Tips and Tricks. Leave new R R.

Ed Eaglehouse. This was a great help. Easiest and quickest solution online, thank you! 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 Thanks so much. This completed my custom script to restore a client db back to our inhouse system.

For everything but the most crucial part renaming the physical files , this works. There may or may not be typos in the rename logic as well. Here's how I overcame the issues:. This doesn't work for Windows authentication because the detach changes the file permissions so the renames fail with "Access denied".

Am I the only one who thinks that it's ridiculous to have to go through this to rename a couple of files? I actually do this much differently. I restore the Database from backups to the new Name I want it to be and then Alter the Database with the new name to get the logical files consistent. Then delete the old Database. Method works for me I do this on a daily basis mind you environment is a touch different then your typical Database Environment.

But views from some third DB are still reference old DB regardles name becouse they are compiled with ID , I know if I go to view and alter it without any real change it will reference right DB by name. I know this is a very old thread Just one small addition.

Change the logical names, file size, growth, etc. This was the way you had to do it on SQL with the exception of the syntax being different for the attach and detach commands. Thank you for including this in your tips. I ran across this problem a few weeks ago and somehow, after quite a few frustrating attempts, found a way to get it done.