SQL Server Performance

Need a little clarification regarding Sql Server CLUSTERING

Discussion in 'SQL Server 2005 Clustering' started by dhull007, Jul 11, 2008.

  1. dhull007 New Member

    A and B are 2 Physical Servers having both Sql Server 2005 instances clustered(active/active).
    Can I have the same database, say db_cluster , available on both nodes (A and B) of cluster??such that oltp run on B and reports run on A on the same database.???i.e. db_cluster would be read-only on A.
    Is it feasible or rather achievable through clustering???
  2. satya Moderator

    Welcome to the forums (as I can see your screen name familiar here [:)])
    You cannot do that way and if you need to do database mirroring is best to go where the mirror database can be used for reporting purpose (bear in mind you have to pay license for Mirror in this case).

Share This Page