You are a database administrator for a Microsoft SQL Server 2012 instance. You need to ensure that data can be migrated from a production server to two reporting servers with minimal data to ensure that data on the reporting server is always accessible which solution should you use?
A. Database snapshot
B. Log Shipping
C. Change Data Capture
D. AvailabilityGroups
Answer:D
You are a database administrator for a Microsoft SQL Server 2012 instance. You need to ensure that data can be migrated from a production server to two reporting servers with minimal data to ensure that data on the reporting server is always accessible which solution should you use?
A. Database snapshot B. Log Shipping C. Change Data Capture D. AvailabilityGroups