|
|
|
Old Hand
 
Group: General Forum Members
Last Login: Tuesday, June 09, 2009 1:25 AM
Points: 304,
Visits: 390
|
|
I have to implement Database Mirroring or Log shipping on different server in which one server is located in USA and other in Hongkong..
So, which option is best Log Shiping or Mirroring for best performanence? How can i get benifits as well for both?
pls give me ur recommdation..
Thanks & Regards,
Paresh Prajapati
 +919924626601
prajapati.paresh@yahoo.com
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Tuesday, June 09, 2009 1:25 AM
Points: 304,
Visits: 390
|
|
Means i want to say that Mirroring ort shipping is best for both server which are on individual network..???
Thanks & Regards,
Paresh Prajapati
+919924626601
prajapati.paresh@yahoo.com
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Thursday, June 18, 2009 4:41 AM
Points: 321,
Visits: 441
|
|
Paresh Prajapati (11/18/2008)
I have to implement Database Mirroring or Log shipping on different server in which one server is located in USA and other in Hongkong..
So, which option is best Log Shiping or Mirroring for best performanence? How can i get benifits as well for both?
pls give me ur recommdation..
You will definitely face a speed issue due to the location of the servers
kshitij kumar
Senior Software Engineer
Pune.
krayknot@yahoo.com
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Tuesday, June 09, 2009 1:25 AM
Points: 304,
Visits: 390
|
|
But Which is best option if i have to implement???
Mirroring or shipping ??
Thanks & Regards,
Paresh Prajapati
+919924626601
prajapati.paresh@yahoo.com
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Thursday, July 02, 2009 4:53 PM
Points: 1,038,
Visits: 1,931
|
|
Hi,
this really depends on what you want to implement, since you have only two servers DB Mirroring would be advisable as you dont have to mirror it to multiple servers. And also When DB mirroring is used in Synchronous mode the mirror database is more up to date than log shipping and also its easier to implement.
this link could be useful:
http://blogs.msdn.com/mikewat/archive/2007/07/28/database-mirroring-and-log-shipping-which-is-better.aspx
and also....
http://technet.microsoft.com/en-us/magazine/cc160992.aspx
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Thursday, June 18, 2009 4:41 AM
Points: 321,
Visits: 441
|
|
Paresh Prajapati (11/18/2008)
But Which is best option if i have to implement???
Mirroring or shipping ??
Database mirroring can be simpler to implement. When using its synchronous mode, the mirror database is more up-to-date (with no data loss) than its log shipping counterpart, which is only as good as the last log that has been applied to the secondary.
kshitij kumar
Senior Software Engineer
Pune.
krayknot@yahoo.com
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Thursday, July 02, 2009 10:17 AM
Points: 1,384,
Visits: 532
|
|
Paresh Prajapati (11/18/2008)
I have to implement Database Mirroring or Log shipping on different server in which one server is located in USA and other in Hongkong..
So, which option is best Log Shiping or Mirroring for best performanence? How can i get benifits as well for both?
pls give me ur recommdation..
you can also think in Data Publish to another server, see more info on SQL BOL.
|
|
|
|
|
Ten Centuries
Group: General Forum Members
Last Login: Thursday, July 02, 2009 4:53 PM
Points: 1,038,
Visits: 1,931
|
|
Hi,
Yes if you want to publish your database level objects you can use Replication(merge) technology, if you want to mirror the database either logshipping or DB mirroring
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Monday, June 08, 2009 8:59 AM
Points: 249,
Visits: 218
|
|
What really matters here is: What is the purpose? How busy is the primary database? How much bandwidth are you willing to pay for? My following comments pertain to SQL Server 2005, SP2, Cumulative Hotfix 9.
I've set up log shipping and mirroring on several databases located miles apart, each connected to the public internet through normal (T1 on one end, 5mbps on the other) internet connections. Both the log shipping and the mirroring work fine. I find that the mirroring tools for monitoring status are better than the log shipping tools. There is a mirroring monitor you can run and see status in near real time. With log shipping, you have to be very careful that everything is lined up - I had one parameter wrong, everything appeared to be working, the SA jobs were succeeding, but nothing was getting restored on that particular database. With mirroring, the monitor tool compares both servers and gives you an instant status.
LS allows copies to multiple servers, and can be mere minutes behind if you set the schedule up that way. Mirroring can only copy to one server, but is generally only seconds behind. I would NOT use High Availability mode at this distance, I'd use the High Performance mode to allow for hiccups. We have chosen to go with HPerf mirroring for our warm standby server, and LS to our disaster recovery server.
Also, LS requires a share visible from one machine to the other, so it's one more thing to maintain.
Student of SQL and Golf, Master of Neither
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Tuesday, June 09, 2009 1:25 AM
Points: 304,
Visits: 390
|
|
But i think Mirroring is degrade database performanance than shipping..
Thanks & Regards,
Paresh Prajapati
+919924626601
prajapati.paresh@yahoo.com
|
|
|
|
