Rename Database path names?
-
After installing my first SQL Server 2005 database, I found the path names for the database files to be too long. Is it possible to change this for all of my databases without too much grief? A reinstall is possible, but not desired.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
-
I presume you are speaking of the default path where database files are stored? In that case, you can search on 'moving databases' in this website. An easy way is to dettach and attach the files. Note that moving system databases requires more work.
-
You can also try Books on Line
moving system databases
http://msdn2.microsoft.com/en-us/library/ms345408.aspx
moving user databases
http://msdn2.microsoft.com/en-us/library/ms345483.aspx
-
This is very helpful. Thank you.
I couldn't find this in books online.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply