SQL Server xp_delete_file parameters
sql-server, sql-server-2008-r2, sql-server-2012, sql-server-2014
Solution
`xp_delete_file` take five parameters:
- File Type = 0 for backup files or 1 for report files.
- Folder Path = The folder to delete files. The path must end with a backslash "".
- File Extension = This could be 'BAK' or 'TRN' or whatever you normally use.
- Date = The cutoff date for what files need to be deleted.
- Subfolder = 0 to ignore subfolders, 1 to delete files in subfolders.
Source `How to Use xp_delete_file to Purge Old Backup Files` by Patrick Keisler
Problem
Who can explain list of `xp_Delete_file` parameters in sql server. I don't find msdn document for this stored procedure. I got script of xp_Delete_file from maintenance plan but didn't understand first parameter.