Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to replicate a database from a failover cluster

Status
Not open for further replies.

web4fun

MIS
Oct 2, 2002
127
0
0
US
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.
 
Yes this can be done without issue. There are no special requirements for setting up SQL Replication on a clustered SQL Server.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top