Sunday, March 11, 2012

Differential backup vs Log Shipping

Hello,
I'm trying to figure out the most effective way to have a standby database
in remote location (connected by reliable broadband link).
The option which I'm looking at are log shipping and differential backups.
As far as I understand with log shipping all I have to do is to periodically
apply transacton logs to original full restore database and be good forever.
On the other hand if I use differential restores, I need to restore full
backup to standby server each time I do full backup at origin server, right?
Original database is 10 Gb so does it mean with differential backup scenario
I would have to copy 10 Gb each time I do full backup on source server?
Are there any advantages in using differential backup as opposed to log
shipping method?On a separate note what is effect of full and transaction log backups on log
shipping process?
"ChanKaiShi" wrote:

> Hello,
> I'm trying to figure out the most effective way to have a standby database
> in remote location (connected by reliable broadband link).
> The option which I'm looking at are log shipping and differential backups.
> As far as I understand with log shipping all I have to do is to periodical
ly
> apply transacton logs to original full restore database and be good foreve
r.
> On the other hand if I use differential restores, I need to restore full
> backup to standby server each time I do full backup at origin server, righ
t?
> Original database is 10 Gb so does it mean with differential backup scenar
io
> I would have to copy 10 Gb each time I do full backup on source server?
> Are there any advantages in using differential backup as opposed to log
> shipping method?

No comments:

Post a Comment