Hello All
Just for clarification for the current environment state. It it a bit complicated, I hope I will make myself clear:
I got a clustered environment:
2 nods:
- NODA - Comp1 (Physical box) with access to the storage (LUN)
- NODB - Comp2 (On VM - W2K3) with access to the same LUN
SQL Server is hosted on the Comp1;
DB and Trans Log are on the LUN (on the storage)
Drive E:\ hosts .mdf file
Drive F:\ host .log file
(If you want to ask why it is configured like that - honestly, do not have a clue)
btw. this is a production environment.
ok, the next server reboot is schedule for Friday after Server patching.
I have made SQL Services depend on Cluster Services. (Cluster Services should make all necessary connection to the LUN)
As long as we got connection established to E:\ and F:\ Drive, SQL should have connectivity to DBs.
If you guys have any suggestions, please let me know.
I will post all results after Friday's reboot.
Regs
Kris