Sam, I tried your script and it is doing what I want, but I have some really old archive logs that do not fall into the 7 day range and I will like those deleted first before I start scheduling the script to run weekly. Sould you help me fix it so that they also get deleted. [/B]
Hi,

Either delete 'em manually first or change the date range in my query.

Also pl. note that in my query, I have hard coded 'FRIDAY' as we take cold backup on Friday night.

Thanks,