Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Replication setup on Active/Passive Cluster

Posted on 2004-11-09
3
Medium Priority
?
342 Views
Last Modified: 2013-11-15
On an active/passive cluster, is it possible to implement transactional replication from one database on the active server to a standby database on the passive server? Please help me.
0
Comment
Question by:kpparvathaneni
1 Comment
 
LVL 10

Accepted Solution

by:
AustinSeven earned 200 total points
ID: 12532978
As soon as you have a database (ie. another sql server instance) on the 'other' node as well, it ceases to be Active/Passive and becomes Active/Active.   So, that's two SQL Server instances.    In this case, yes you can implement transactional replication.

AustinSeven
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Among the most obnoxious of Exchange errors is error 1216 – Attached Database Mismatch error of the Jet Database Engine. When faced with this error, users may have to suffer from mailbox inaccessibility and in worst situations, permanent data loss.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question