Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-11 : 23:13:27
|
Daniel writes "I am trying to backup logs into a disk dump device. I schedule it to run every 4 hours and the backup sets should be stay for 2 days. I try to write one stored procedure to handle this job. However, the procedure backs up log every 4 hours. However, it won't erase the old sets. My device is keep growing.
If you I use " WITH INIT" option, it will erase the backup set created 4 hours ago. I want it stay for 2 days.
How do I solve this problem, I don't want to clean up the backup set mannually and for business reason, I only can use 'disk' as dump device.
Thanks a lot
Daniel" |
|
|
|
|
|
backup log question