SQL 6.5 Database Dump Inquiry

greenspun.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

Answers

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


Moderation questions? read the FAQ