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???
   

   dhull007, Jul 11, 2008

   #2
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).
   

   satya, Jul 11, 2008

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in