'SQL Server Always On: How simulate disks in secondary replica which only exist in primary replica
I have an Always On system with two replicas: A and B. A is addressed to be mainly the primary replica.
Replica A has 2 local disks dedicated to user databases data and user databases logs: D: and L:.
Replica B has an only disk: E:, and I have created two folders in it for data and logs: E:\Data and E:\Log
Nevertheless, until I know, database folders must be the same in both replicas. In replica A I have D: for user database data and L: for user database logs. But I have no such disks in replica B.
How can I simulate the necesary disks in B?
Thanks in advance
Solution 1:[1]
It's not a hard requirement to have the same file paths on both servers, but it makes your life easier.
In Windows you can create multiple volumes on a single disk. So on B delete the E volume and add two new volumes on the disk, assigning the driver letters D and L, just like the primary.
Or you could use D:\Data and D:\Logs on both servers by mounting the L volume as D:\logs on the primary, and re-mapping E to D on the secondary.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |