I am currently using snapshot replication to backup a single SQL database to
a server at home. What technique(s) would be best if I wanted to backup say
6 databases? These would all be one-way as no changes are made to the data
from the backup server. Also, the data is not SO critical so as not to be
able to afford the loss of up to 24 hours worth of changes from one to the
other. I've considered doing 6 Publications-Subscriptions etc, but I
thought there must be a better way. Is there?
Thanks
Carlos, the publications are on a per-database basis, so there isn't a
simpler method than the one you're considering. Potential alternatives (not
simpler) include log shipping and transactional replication. If you're
concerned about bandwidth issues then these would be more suitable.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||If you have big pipes between your publisher and subscribers I would
recommend log shipping. Otherwise I would recommend transactional
replication as only the changes will be replicated.
For transactional replication you will need a pk on each table; although
there are ways around this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Carlos Y. Maldonado, Ph.D." <cmaldonado@.earthlink.net> wrote in message
news:U5i4f.14372$vw6.9184@.newsread1.news.atl.earth link.net...
>I am currently using snapshot replication to backup a single SQL database
>to a server at home. What technique(s) would be best if I wanted to backup
>say 6 databases? These would all be one-way as no changes are made to the
>data from the backup server. Also, the data is not SO critical so as not
>to be able to afford the loss of up to 24 hours worth of changes from one
>to the other. I've considered doing 6 Publications-Subscriptions etc, but
>I thought there must be a better way. Is there?
> Thanks
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment