CODEWITHSUNDEEP
sql-serverdiskalwayson
IgnacioJ
IgnacioJ

Reputation: 107

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

Upvotes: 0

Views: 131

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89424

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.

Upvotes: 0

Related Questions