T-sql delete bak files

It is very easy to accomplish. What's wrong with the extended stored procedure that MS supply?? I thought that we were supposed to stop using the xps as they were going to be deprecated? October 21, at am April 13, at am April 13, at pm HI, You can add a step to your daily backup job such that 1 first step will delete old backup file based on ur need days. April 14, at am Thanks, But we always backup first to make sure we have a good and verified backup before we delete anything Viewing 15 posts - 1 through 15 of 23 total.

In the New Job Step window, under General tab, enter a descriptive job name, under Database select the database which we want the job to work on and under Command: insert the following line:. Under Advanced tab, choose what will be done after this step is done successfully. Here we can also set how many times the step will retry as well as time interval between tries in minutes. In the new window, enter a descriptive name for the schedule.

Also, for Schedule Type check that it is set to Recurring for proper scheduled operation. After that, we can set up the schedule using the options below:. The rest of the tabs is optional in this use case, though, we could use Notifications tab to set up email notifications when the job is completed. SQL Server Maintenance plans are another way of deleting old backup files by using the cleanup task. When connected to the server, expand it and the Management folder after.

Enter a descriptive name and, optionally, a description, and in the bottom right click on Change…. After that, we can set up the schedule using the options below.

After that, click OK. In the next window, check Maintenance Cleanup Task and click on Next :. In the following window, because we have only one task, there is no ordering, so we proceed by clicking on Next :.

After 7 years, I'm changing the accepted answer from my own below, to this one instead. Not sure if this was available in SQL Server R2, but at this point, I think this is the answer that deserves to be accepted.

Thanks very much! Alexey Alexey 1, 3 3 gold badges 16 16 silver badges 19 19 bronze badges. Do you get an error? Maybe you need to have enough permissions. Requires membership in the diskadmin fixed server role. This is what I needed. Create a backup-device, with a physical name that points to the backup-file: exec master..

Physical filenames can be found in the table 'msdb.. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.