I currently have an active / passive SQL 2008 failover cluster and I need to replicate a 30GB database that currently resides within the cluster to a reporting server. I was hoping to implement transactional replication to the reporting server as the data needs to be updated frequently. Is this possible? Any other suggestions?
Thanks in advance.
Thanks in advance.