SQL 6.5 Database Dump Inquirygreenspun.com : LUSENET : SQL Server Database Administration : One Thread |
I would like to know how to reset a scheduled task after 7 days. I am referring to the backup device where it would release the prior 7 days of information and start as a clean device on the eighth day.Thanks for taking my question!
Gordon
-- Anonymous, August 22, 2000
Gordon,I would schedule a second task to run once a week.
Use this weekly task to release the prior 7 days of information.
Hope this helps,
Eric
-- Anonymous, August 23, 2000
Gordon:If you are referring that you want to delete all the previous backup and write on the same backup device, you can use 'init' keyword in the backup statement. For the syntax see BOL.
Hope this helps
-- Anonymous, August 23, 2000