You need to ensure that data can be migrated from a production server to two reporting servers…?

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?

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.
Availability Groups



Leave a Reply 0

Your email address will not be published. Required fields are marked *