February 26, 2014 at 3:29 am
Hi,
I have 2 node cluster and 4 instances running. I have installed the 5th instance on Specific U drive.
My questions is now SQL binaries path is
U:\Mssql_50 INS but i need to change this path to
U:\MSSQL\U:\Mssql_50 INS,
Please suggest me how to i can made the changes this is cluster instance.
Thanks,
Giri
February 26, 2014 at 3:40 am
As far as I know, the only way is to uninstall the instance and reinstall it in the 'correct' place, i.e. your desired filepath. Have you created user databases on the instance or is it a vanilla install?
Regards
Lempster
February 26, 2014 at 3:45 am
User databases running on the server..
February 26, 2014 at 4:07 am
kommagoni (2/26/2014)
User databases running on the server..
Well in that case I would just live with the current install path.
Otherwise you are going to have to install a new instance in the correct place, move your existing system databases and move/copy your user databases to the new instance using detach/attach or backup/restore. You need to plan this very carefully and communicate with the business/end users otherwise you could be in a world of pain!
I definitely recommend that once you have decided on your process, you test it throughly - set up a couple of test instances well away from Production. The link below might help you with moving system databases:
http://www.mssqltips.com/sqlservertip/1604/move-all-sql-server-system-databases-at-one-time/
Do plenty of reading on this subject before attempting anything would be my advice. 😉
EDIT: spelling mistake
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply