Since we've for seen to work with several disks
it's recommended to configure SQL default values. This values are
used when creating databases (if it can't be done through the
installation of the software itself).
- Launch
"Microsoft SQL Server Management Studio"
- Connect
to Database
- Right
click on this database and select 'Properties'
- Select
'Database Settings'
- Change
'Database default locations' for 'data' and 'Log'.
Mostly will the Data be located on the first disk in the group. For
example E:\DBData.
The Log location will be located on a second disk. For example
F:\DBLog
If the disk is not present, this means
that you've forgotten to change the dependencies on the SQL Server.
It must be depending on both disks!
- Repeat
all these steps for each instance present on the cluster.