question

IJ5569 avatar image
IJ5569 asked

SQL Server Always On: How simulate disks in secondary replica which only exist in primary replica

Hello:

I have an Always On system with two replicas: A and B, A being 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

Until I know, although database paths for data or log may be different in both replicas, it is convenient they match to make maintenance easier.

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, just only disk E: with two folders in it.

How can I simulate the necesary disks in B?

I am thinking in something like mapped drives in server B that can be recognized by the Always On databases in SQL Server, and that are mounted everytime the server starts.

Thanks in advance,

Ignacio

alwaysondisk
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.