May 2, 2009 at 9:17 am
Hello,
I have installed 2 named instances and the default unnamed instance on the same virtual server we have in our dev environment. The problem I have installed some under the default directory in Program Files folder and some under a separate directory elsewhere. I would like to have them under the same directory. Can I just shutdown the instance, move all the files and edit the registry (I tried this but got unhandled exception upon restart, so I must have missed something) or is there some other trick?
Thank you!
May 2, 2009 at 3:18 pm
Hmm never had to do this myself, but you might try:-
1) Shutdown the instance in question
2) Take a file-system copy of all the MDFs and LDFs (including the system databases
3) Uninstall the instance
4) Install the instance (and relevant Service Packs) from scratch back again with the same name but into the desired file system location.
5) Shutdown the instance.
6) Overwrite the newer MDFs and LDFs with the copies you made in step 2.
7) Start the instance again.
May 2, 2009 at 3:44 pm
In Windows Server isn't possible as Unix Server (not MSSQL off course).
You need to uninstall and install again.
Make a database backup if needed.
---------------------
Alex Rosa
http://www.keep-learning.com/blog
May 3, 2009 at 10:01 pm
Thank you!
I ended up uninstalling and re-installing in new location.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply