Does the transaction log on a publisher SQL server get truncated when the database is backed up, but the distributor is down?

[mokles]

Hello All,
The setting is SQL server 7, on Windows NT.

If the distributor can not access the log on the publisher database ( but
subscribers are not deleted yet), will the full backup of the publisher
database truncate the transaction log? My guess is, it will not truncate the
log.
Can any one confirm please?

Thanks,
Mokles

[Dan Guzman]

Full backups don't truncate the log; the log is truncated by BACKUP log.
From the Books Online:

<Excerpt href="\tsqlref.chm::/ts_ba-bz_35ww.htm">
Once the log is backed up, the space may be truncated when no longer
required by replication or active transactions.
</Excerpt>

I believe the data is considered required for replication until retrieved by
the distributor

--
Hope this helps.

Dan Guzman
SQL Server MVP

"mokles" <mo****@rogers.com> wrote in message
news:nc********************@rogers.com...

Hello All,
The setting is SQL server 7, on Windows NT.

If the distributor can not access the log on the publisher database ( but
subscribers are not deleted yet), will the full backup of the publisher
database truncate the transaction log? My guess is, it will not truncate
the
log.
Can any one confirm please?

Thanks,
Mokles

[mokles]

Dan Guzman,

Thanks for your confirmation and explanation.

Mokles

"Dan Guzman" <gu******@nospam-online.sbcglobal.net> wrote in message
news:ZS*****************@newssvr30.news.prodigy.co m...

Full backups don't truncate the log; the log is truncated by BACKUP log.
From the Books Online:

<Excerpt href="\tsqlref.chm::/ts_ba-bz_35ww.htm">
Once the log is backed up, the space may be truncated when no longer
required by replication or active transactions.
</Excerpt>

I believe the data is considered required for replication until retrieved by the distributor

--
Hope this helps.

Dan Guzman
SQL Server MVP

"mokles" <mo****@rogers.com> wrote in message
news:nc********************@rogers.com...

Hello All,
The setting is SQL server 7, on Windows NT.

If the distributor can not access the log on the publisher database ( but subscribers are not deleted yet), will the full backup of the publisher
database truncate the transaction log? My guess is, it will not truncate
the
log.
Can any one confirm please?

Thanks,
Mokles