No transaction logs

can you manually backup the transaction log from EM?
Keene
>--Original Message--
>I have a maintenance plan set up on a database to take
transaction log backups every 2 hours. The job runs
successfully everyday, but I do not see any .trn files
generated (and the task pad description shows that no
transaction log backups ever took place).
>Any idea why? I've never seen this problem on any of my
other servers.
>Thank you!
>.
>It's SQL Server 7.0 with a database option of Truncate Log on Checkpoint...d
oes that make a difference?|||Gina,
With truncate log on checkpoint set the log file backups will be =
failing. You cannot do a backup log when this option is set as the =
contents of thye log are effectively destroyed at every checkpoint (ie =
every few minutes).
It sounds like you want this option OFF if you require point-in-time =
recovery.
Mike John
"Gina" <anonymous@.discussions.microsoft.com> wrote in message =
news:A4AC132C-1726-494E-AA0C-952A18EBED8E@.microsoft.com...
> It's SQL Server 7.0 with a database option of Truncate Log on =
Checkpoint...does that make a difference?|||Thank you very much!