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.
George
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.
"George Nentidis" <gnentid@.msn.com> wrote in message
news:%23rnPmmQ6FHA.3760@.TK2MSFTNGP14.phx.gbl...
> 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.
> George
Tuesday, February 21, 2012
Replication, Log Shipping and Backup
Labels:
backup,
database,
installation,
log,
microsoft,
mysql,
online,
oracle,
replicatessome,
replication,
server,
shipping,
sql,
transactional
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment