xp_getfiledetails to find Audit Flag????

  • 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

  • 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

  • Thanks,

    that worked a treat!!

  • 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