SQL Server 2022, Availability Groups, Temporal tables - will logshipping work as a solution for replicating to another domain?
3
votes
1
answer
193
views
I'm kinda the 'accidental DBA' so i could be totally off here.
We are onprem, and we are talking about our test environment.
We are planning on changing hosting company.
We will move our AG to the new hosting company
We would like somehow to be able to switch back fast to the old hosting company, if something is not working at the new.
We have a lot of temporal tables, so normal replication via transaction log is not possible.
Although it is a test environment, there is a lot of testactivity, that we don't want to loose if new hosting company fails. (we could backup and restore, but i was looking for a faster solution)
Could logshipping be a solution to this, or is there another way you would suggest ?
regards
Asked by Peter Tilsted
(319 rep)
Apr 9, 2025, 12:02 PM
Last activity: Apr 9, 2025, 08:52 PM
Last activity: Apr 9, 2025, 08:52 PM