Backup transaction logs and replication simultaneously -- sql server (alternate)

wumutek NO[at]SPAM yahoo.com
9/28/2004 11:08:47 AM

Is there any problem with implementating some kind of replication and
backing up transaction logs at the same time? SQL Server 2000 Standard
Edition

The server is configured to back up log files regularly, with the
presence
of a(New) Disaster recovery server and with an inability for
standby(Standard Edition)I am planning to implement some kind of
replication hopefully still backing up the transaction logs to enable
a point in time recovery.

Thanks in advance for your great ideas

Simon Hayes
9/29/2004 10:31:40 AM

[quoted text, click to view]

Check out "Backing Up and Restoring Replication Databases" in Books Online -
it covers each type of replication, as well as how to combine replication
with log shipping.

If that doesn't give you enough information, you could post in
microsoft.public.sqlserver.replication - you might get a more detailed
answer there.

Simon

sql server (alternate) : Backup transaction logs and replication simultaneously