1. Create a table that holds a counter number
2. Create a dynamic script to do the log backups tacking on the number from
the table ex. Msdb_log_1.dmp, Msdb_Log_2.dmp, etc...
3. Increment the number

Be sure to write a cleanup script also... aka delete old tran logs and reset
the number when you do this

In essence what you are doing is trying to overwrite you existing log backup
and the retain parameter is not letting you overwrite it.

-----Original Message-----
From: gary cheng [mailto:[Email Address Removed]
Sent: Wednesday, May 08, 2002 10:41 AM
To: [Email Address Removed] Transaction Log Backup

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


---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page