Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Business Continuity for SQL Servers With a Standby Approach


Business Continuity for SQL Servers With a Standby Approach

Author
Message
vsrinivasan
vsrinivasan
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bahmed/businesscontinuityforsqlserverswithastandbyapproac.asp



Robert Sterbal
Robert Sterbal
Valued Member
Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)

Group: General Forum Members
Points: 57 Visits: 1

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


BobAtDBS
BobAtDBS
Old Hand
Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)Old Hand (304 reputation)

Group: General Forum Members
Points: 304 Visits: 356
Nice ad.


Student of SQL and Golf, Master of Neither
Jack Corbett
  Jack Corbett
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11018 Visits: 14858
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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
Pam Brisjar
Pam Brisjar
SSC Eights!
SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)SSC Eights! (910 reputation)

Group: General Forum Members
Points: 910 Visits: 2804

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

Very disappointed.


Kumar Part
Kumar Part
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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?



happycat59
happycat59
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3563 Visits: 3104
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.



kozloski
kozloski
SSC Veteran
SSC Veteran (298 reputation)SSC Veteran (298 reputation)SSC Veteran (298 reputation)SSC Veteran (298 reputation)SSC Veteran (298 reputation)SSC Veteran (298 reputation)SSC Veteran (298 reputation)SSC Veteran (298 reputation)

Group: General Forum Members
Points: 298 Visits: 1056

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
henrik staun poulsen
henrik staun poulsen
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1831 Visits: 1210

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





Julian North
Julian North
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search