Log Backups

Can log backups only be done based on time/scheduling?
What I mean by that, is can log backups be driven based on
the size of the log or based on "activity" (as opposed to
every two hours or every 15 minutes)?You can set an alert to key off of performance counters and then kick off a
job. For example, I have an alert that watches % log used and fires off a
job that backs up the t-log when the counter is over 75%. You really should
use the scheduled ones too though to maintain your business requirements
regarding to data loss.
Christian Smith
"CLM" <anonymous@.discussions.microsoft.com> wrote in message
news:e15001c3efee$dbdb8ec0$a601280a@.phx.gbl...
> Can log backups only be done based on time/scheduling?
> What I mean by that, is can log backups be driven based on
> the size of the log or based on "activity" (as opposed to
> every two hours or every 15 minutes)?