How to delete old backup files by script.

Extended procedure 'xp_delete_file ' is used for to delete the backup files in the server.

We need to specify the file type selected ((0 = FileBackup,1 = File Report),folder path(trailing slash), file extension which needs to be deleted (N'bak'),date(prior which to delete) and folder flag level((1 = include files in first subfolder level, 0 = not) as like below in the Sql Server Management Studio.

EXECUTE master.dbo.xp_delete_file 0, N’D:\SQLBackup',N'BAK',N'06/07/2011 10:18:49',1

By running above script, we can able to delete the old backup files prior to the above specified date.


Popular posts from this blog

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)