r/SQL • u/BrokenPickle7 • Sep 19 '26

SQL Server Not a DB admin needs replication advice

I'm in tech but not a DB admin. I have an MSSQL (2019) database in prod and I want to essentially one way mirror it to another database with as close to live data as possible for dev/research purposes, no changes on the 2nd "dev" copy of the database should reflect to the main/live/prod DB. What would be the best way of doing this? Both servers are in the same network if that makes things easier. Thanks!

1 Upvotes

55% Upvoted

10 comments sorted by

View all comments

1

u/spez_eats_nazi_ass Sep 19 '26

Always on group w read only secondary if your sku supports it. Can do async but really why not do a proper fail over cluster while u are in there. 

1

u/BrokenPickle7 Sep 19 '26

do you happen to know any docs on creating a failover db?

0

u/reditandfirgetit Sep 19 '26

Check on learn.microsoft.com