Friday, February 24, 2012

log shipping and growing of trans log on backup server

hi all,
we do log shipping to a backup server. Log on the backup server is
growing. It seems ok to truncate log once/day.
Is it!the LOG is growing on your backup server because it must be growing on your
primary server too, you will need backup the log on the primary server first
and then restore the latest log to the backup for the log file to truncate.
--
-- cranfield, DBA
"Zarko Jovanovic" wrote:
> hi all,
> we do log shipping to a backup server. Log on the backup server is
> growing. It seems ok to truncate log once/day.
> Is it!
>

No comments:

Post a Comment