SQL Server Performance

SQL Server Clustured Nodes can use same DB

Discussion in 'SQL Server 2005 Clustering' started by haresh, Jan 4, 2007.

  1. haresh New Member

    Hello Friends,

    I am going to use SQL Server 2005 clustering soon. I have one question: Suppose I created 2 nodes (physical machines). When a user requests it will connect to default node: SQLN1 and if it's connection limit is reached then request will be automatically transferred to SQLN2. At this time replication of DB on SQLN1 to SQLN2 is necessary to perform operations or SQLN2 will use latest database itself?

    Please help ASAP.

    Thanks,

    Haresh
  2. MohammedU New Member

  3. haresh New Member

    Thank you Mohammed.

    I got it.

    Haresh

Share This Page