Hi, I tried to backup the transaction log on hourly basis. And I don't want
to the job overwrite the one created before, so I specified the retaindays
=7, however the backup job failed to run. I believe there is a conflicting
between retaindays = 7 and with init. How can I create a transaction log
backup job that all the backup files will be kept for a week? Many thanks!

_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com

MS Sql Server LazyDBA home page