May 26, 2010 at 12:07 pm
does anyone have t-sql to find backup file deleted or not?
suppose say maintenance plan created for every 2 hrs logbackup and delete file older than 2 days.
is there any t-sql to find out which file deleted and which are not?
May 26, 2010 at 12:36 pm
As far as I remember maintenance plan relies on XP_DELETE_FILE to delete old files - XP_DELETE_FILE is not supposed to leave any paper trail.
I assume some windows scripting may let you know which files are still in the server - the authomatized version of login into the server and doing a dir on the targer directory 🙂
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply