Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 Database mirroring replication?

Author  Topic 

confident119
Starting Member

12 Posts

Posted - 2009-07-01 : 05:09:32
I want to know Sql Server 2005 Data mirroring will supports multiple sql servers DB'S replication to One powerful standby box?
Any disadvantages in this DR scenerios? We not considering for auto failover just mirroring.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-07-01 : 14:08:42
Yes it supports it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

confident119
Starting Member

12 Posts

Posted - 2009-07-02 : 06:16:09
Thanks for the reply. Any disadvantages in this DR scenerios?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-07-13 : 18:08:31
The disadvantage would be performance if you ever had to failover the databases.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -