Sunday, February 12, 2012

Backing up Transaction log

Is there a way to backup a Transaction log without actually saving with the
backup utility. All I really want to do is dump the log. Thanks.Tom,
Try NO_LOG or TRUNCATE_ONLY. For more information see the Truncating the
Transaction Log topic in the SQL Server BOL.
HTH
Jerry
"Tom Reis" <reistom@.cdnet.cod.edu> wrote in message
news:ud6$kBtuFHA.3124@.TK2MSFTNGP10.phx.gbl...
> Is there a way to backup a Transaction log without actually saving with
> the
> backup utility. All I really want to do is dump the log. Thanks.
>|||Tom Reis wrote:
> Is there a way to backup a Transaction log without actually saving
> with the backup utility. All I really want to do is dump the log.
> Thanks.
Use the with truncate_only option. The log is truncated and no backup
actually occurs. You'll need to perform a full database backup to get
back on track.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||If that is the case why are you in FULL recovery mode to begin with? As
soon as you manually truncate the log you loose the ability to use the log
for recovery purposes. So if you are not planning on issuing regular log
backups you should set the recovery mode to Simple and it will automatically
truncate the log when it gets to 70% full.
Andrew J. Kelly SQL MVP
"Tom Reis" <reistom@.cdnet.cod.edu> wrote in message
news:ud6$kBtuFHA.3124@.TK2MSFTNGP10.phx.gbl...
> Is there a way to backup a Transaction log without actually saving with
> the
> backup utility. All I really want to do is dump the log. Thanks.
>

No comments:

Post a Comment