Log Shipping: Questions RE setup and access
I will be setting up a log shipping environment soon. SQL Backup looks great!
I have a few questions related to SQL Backup and log shipping:
a) Does it work with Express Edition of SQL 2005 and 2008 ?
b) Can I do one-to-many? E.g. log ship to a warm spare DB server, and to our analytics DB server?
c) How many copies of SQL Backup do I need? (One per server? One per "source" server? or ?)
d) Exactly what visibility is needed across the two servers? (Our servers are in different data centers across the country... I really need to know!)
e) Is a network share required?
f) Can I use ftp or Amazon S3 instead of a network share?
(S3 would be smokin!)