Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Business Continuity for SQL Servers With a Standby Approach Expand / Collapse
Author
Message
Posted Friday, April 14, 2006 11:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 28, 2006 10:13 AM
Points: 21, Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bahmed/businesscontinuityforsqlserverswithastandbyapproac.asp


Post #273411
Posted Wednesday, April 26, 2006 8:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 08, 2007 2:25 PM
Points: 53, Visits: 1

Thanks for the effort, but this was a little too much of an ad.

 

Post #275553
Posted Wednesday, April 26, 2006 9:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 06, 2013 6:52 AM
Points: 298, Visits: 332
Nice ad.


Student of SQL and Golf, Master of Neither
Post #275570
Posted Wednesday, April 26, 2006 10:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:17 AM
Points: 10,911, Visits: 12,554
I don't read sqlservercentral.com articles to be sold a product.  Buy advertising space.  If I am looking for a 3rd party product to provide continuity I will do research on the products.  The least you could have done was honestly compare ALL products that provide this functionality.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #275617
Posted Wednesday, April 26, 2006 11:20 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 22, 2014 1:51 PM
Points: 908, Visits: 2,803

Agreed.  You should at least have a disclaimer up front saying the "article" was written by a Sonasoft executive...

Very disappointed.

Post #275627
Posted Wednesday, April 26, 2006 1:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 24, 2008 4:19 PM
Points: 2, Visits: 13
Microsoft Log Shipping is quoted as hot standby. Authors do not know the difference between warm and hot standby. Exhibited poor understanding of concepts, too much markting spin in the name of business continuity. All it does is, recovering the backup to a remote (standby) machine. Ask yourself how much of 99.999 it meets?


Post #275678
Posted Wednesday, April 26, 2006 5:03 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:07 PM
Points: 2,844, Visits: 2,427
I tend to agree with Kumar. The authors do not demonstrate a good understanding of clustering or log shipping. If you are not familiar with the MS options, you may well think that this is an unbiased article.

e.g. in clustering, load balancing is not a feature of clustering software as implied by this article. The designer of the cluster does this by implementing appropriate hardware and configuring the nodes of the cluster so that load is shared apropriately across the cluster.

And whilst an additional NIC on each node is recommended and strictly speaking it is an extra cost, when compared to the hardware typically used in a cluster, the cost of an extra NIC really is insignificant.

The discussion on storage arrays is also a bit light. Most storage arrays worth using come with cache that makes the performance of the array pretty impressive. Many storage arrays have battery backed cache that is used to cache writes to the array further improving performance.

And, looking at the architecture of of the "Sonasoft Standby Solution", it looks a lot like SQL 2005 Database Mirroring. So if you are using or planning to use SQL2005, have a look at Database Mirroring.



Post #275727
Posted Thursday, April 27, 2006 8:09 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 2:00 PM
Points: 298, Visits: 970

Also published as a White Paper on SonaSoft's site:

http://www.sonasoft.com/pdf/DRandBCforSQLServersThruStandby.pdf

Clearly a marketing tool designed to sell their software, rather than an objective discussion of the topic.



-- J.Kozloski, MCDBA, MCITP
Post #275882
Posted Monday, May 01, 2006 6:39 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:39 AM
Points: 1,317, Visits: 960

One advantage of the Sonasoft product is that it supports a mixed environment of SQL Server 2000 and SQL Server 2005. But the Sonasoft is a bit expensive.

Best regards

Henrik Staun Poulsen, MCDBA, Stovi Software




Post #276506
Posted Tuesday, May 02, 2006 11:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 22, 2008 2:30 PM
Points: 3, Visits: 3
Mirroring in SQL2005 looks to me like the best, cheapest option for failover if you can't afford to go enterprise (which many of my clients can't).

To not mention it and then have 2 thirds of the article on a proprietary product...

Shame on you SQLServerCentral. You just went down in my estimations.
Post #276913
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse