December 11, 2002 at 5:21 am
Hi,
I have a job which needs to delete old backups. I want to chack the audit flag (NT4) and only delete if this is not set, meaning that VERITAS has backed up the dump to tape.
I have looked at xp_getfiledetails, bt this doesn't seem to do the job. Does anyone know how to acheive this? IS there another way?
Thanks in advance
December 11, 2002 at 5:42 am
I don't have access to a NT machine right now, but check the switches for the del command (del /?). NT has most of the same switch options as W2K. On W2K you can use "del *.* /a-a" to achieve what you are wanting.
Jay
Jay Madren
December 11, 2002 at 8:00 am
Thanks,
that worked a treat!!
December 11, 2002 at 9:08 am
You need to look at the attribues section of the results
If you AND 32 this will indicate that A is set
Read Only 1
Hidden 2
System 4
Archive 32
None 128
I hope that makes sense.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply