After installing a new instance of 2014, I see that the MSSQL12.MSSQLSERVER isn't on the drive I intended.
This is the folder that has subfolders:
MSSQL
DATA
JOBS
Log
repldata
Well I see the master and msdb databases arw in \Data.
Will I have to uninstall and reinstall or can I move these folders without corrupting the instance?
Thanks. Jack
Hi jbates99,
In a way yes, you can move it, but its not easy. I haven't try it before, from the top of my head, you will need to perform the following:
Backup everything
Stop SQL service
Move the master mdf/ldf to another folder
change the SQL startup parameter to point to the correct master DB path
Start SQL, and ensure it can startup
restore msdb db with the new path
That might work I assume, however, there might have other things that still marked as the old path and you might need change them when you see it. To be clean, you can simply re-install it.again.
When it has happened to me (the IT people didn't read / SET the relevant folder during install) we reinstalled Belt & Braces and to cover Front, Back and BOTH Sides
The system databases went to the wrong drive.
Kristen's comment scared me so much that I decided to uninstall and reinstall.
That went well and everything is good now Thanks for the tips!