i have application team that have dedicated database server for datawarehouse. I want to know what is the best way to copy database from secondary.
Current Environment Always On 1 Primary 1 Secondary Sync - I want to copy database from here to dedicated server. 2 Secondaries Async
From my point of view, linked server is the best way. But app team, want a copy of the database on the dedicated server.
I appreciate all the ideas and suggestion on this platform. Thank You In Advance.