wavesmash (6/27/2008)
Hi Paul,Great article. If schema changes are not copied during log shipping, what is the best method to maintain updates to scripts and tables with large databases where full backups may take hours to copy to a DRP site, even with a log compression solution.
thanks,
Andrew
wavesmash, schema changes are copied over by log-shipping, its one of its big advantages.
Paul, good article. As a firm believer in log shipping I am glad to see you recommend it over replication for failover. I would have been even more forceful in this recommendation, I see replication as more for scale-out, and log shipping as much the better failover\DR solution. Only circumstance I personally would ever recommend replication for failover is if absolutely no data can afford to be lost. even then if you get the tail of the log, log shipping won't lose you any data, and if there is a delay before the restore on the standby could give you a way of backing out incorrect amendments to the data.
---------------------------------------------------------------------