sql server replication: Replication, Log Shipping and Backup -- sql server replication

Re: Replication, Log Shipping and Backup

Hilary Cotter
11/14/2005 6:12:33 AM

sql server replication: 1) yes, but you might want to back it up more frequently as replication
writes to the log too - not much, but some.
2) it doesn't truncate, but it does back it up.
[quoted text, click to view]

Replication, Log Shipping and Backup

George Nentidis
11/14/2005 12:59:41 PM

Hi there all.

In my installation there is a main online DB which replicates
some of its data with transactional replication to another DB.
I also use log shipping so that there is always a stand by server
for my main DB.
1. With this installation, can I still keep backing up my log every
half an hour as I used to before log shipping? I would feel much more
safer if I could. Is there a way to do it?
2. Log shipping uses log backups, so it truncate the log every time
it posts changes to the standby server, is that correct?

Thank you all in advance.