Posted by Erland Sommarskog on 06/08/05 10:39

Ellen K (ekaye2002@yahoo.com) writes:
> Thanks so much. So I think I can use log shipping for my availability
> / disaster recovery plan, the BLOB data was my only worry.

It goes without saying that you have not completed the work with setting
up a recovery plan, until you actually have simulated a disaster recovery.
(And depending on your availability requirements, is something that should
be exercised with some frequency.)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Backup strategy
• Prev in forum: Does the transaction log on a publisher SQL server get truncated when the database is backed up, but the distributor is down?
• Thread view: Re: Log Shipping and BLOB data

[Reply to this message]