How to share SQL backup files between two servers for DR solution

Question

I have a standalone SQL server on physical hardware in a primary data center. The organization will use a replication technology to snapshot the primary server and replicate it to a VM in secondary data center for DR. So the DR server is as up to date as of the last snapshot every 4 hours.

The DR scenario is primary site down. So DR server needs to restore tran logs to get from last replication snapshot to point in time recovery. Let's say that each data center has it's own SAN storage and network access to the other data center. How can I have the primary SQL server and DR SQL server both have access to the same set of SQL backup files for point in time recovery of the DR server?

What are the possible solutions?:

-Backup primary SQL databases and tran logs to remote share in the DR data center, then map that remote share to a drive letter on the DR SQL server at the time when I need to recover it.

-Map a drive letter on the primary server to a share in the primary SAN; I assume the replication technology can include that drive letter and file contents in the replication to the DR VM.

Answer 1

Hi @Cooper, David A. [ISS] (Contractor)

Do you mean to use a backup and restore strategy for disaster recovery? Maybe you can refer to this article: https://www.sqlshack.com/backup-and-restore-sql-server-disaster-recovery/.

Best regards,

Aniya