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 replicated from a production server to two reporting servers in
real time.
You also need 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 replicated from a production server to two reporting servers in
real time.
You also need to ensure that data on the reporting server is always accessible.
Which solution should you use?

A.
Availability Groups

B.
Extended Events

C.
Snapshot Replication

D.
Policy Based Management



Leave a Reply 2

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