Hi, folks,
I got in this installation dilemma, and need your help to move forward.
It is a new VM windows server 2012 R2. I installed SQL 2014 Ent by accidentally specified User db and tempdb log directory to F:\ and backup directory to H:.
Then my restore command failed. and under file explorer the F and H drives said is not accessible, access is denied. And under properties, showed 0 bytes size.
It turned out, SQL tightens the ACL for default data/log directories to exclude broad access for all authenticated users. If the drive root is chosen as the default data/log location then SQL will tighten the root ACL and thus effectively locking down the whole volume.
The recommended course of action is to always use a subdirectory to store SQL data/log files.
My question is what options do I have now to correct above installation?
Thanks!