May 9, 2011 at 5:24 am
Hi every body,
currently i am working on sql server 2005 SP4(STANDARD EDITION).
in this version DATABASE MIRRORING supporting or not.
In this server total 10 user databases is there.i want do all,is it possible?
Regards
venkat
May 9, 2011 at 5:54 am
Yes, you can use mirroring on your platform. You are however, limited to synchronous mirroring AKA High Safety mirroring.
May 9, 2011 at 5:57 am
Thank you for the answer
i want to create 10 mirroring databases.but how many end points required.
Regards
venkat
May 9, 2011 at 5:58 am
Hi,
Yes, DB Mirroring can be implemented on above mentioned edition.
FYI..
Also, on a 32-bit system, database mirroring can support a maximum of about 10 databases per server instance because of the numbers of worker threads that are consumed by each database mirroring session.
regards,:-)
Ankur
May 9, 2011 at 5:58 am
You only create 1 endpoint per SQL Server instance. Don't forget to configure the windows firewall also.
May 9, 2011 at 6:04 am
thank you for the great answer Craig Purnell
Regards
venkat
May 9, 2011 at 6:06 am
thank you for the answer ankur_libra
Regards
venkat
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply