I am pretty green to the administration end of databases, but I was hoping you guys could direct me on the right path.
I have Server 1, 2, and 3. They both identical versions of SQL Server, with an application. Within each instance of MS SQL Server, I have roughly 10 databases in each server. My goal is to replicate/mirror the data to a Server 4 so that reporting and alerts can be run off of the 'live' data without effective performance of the application running on Servers 1,2,3.
To be honest, I don't even know where to start:
Is this at all possible?
Is this a common practice?
Is there any type of recommended reading material?