Note: to delete files from the backup share/folder the account must have read, write and delete subfolders/files permission. Here I will show you two different options to run a PowerShell script which will delete files based on how old the file is based on days. PowerShell scripts support more complex logic than Transact-SQL scripts, giving SQL Server administrators the ability to build robust administration and automation scripts.īelow are some of the most commonly used processes to delete older backup files:

PowerShell is a powerful scripting tool which allows administrators and developers to automate server administration and application deployment. While there are many processes for file deletion that you can use in SQL Server, I will show you how this can be done using PowerShell. There are several techniques for deleting old files, but in this tip I show how this can be done using PowerShell. One of the things that you need to do is to maintain the number of backup files that exist on disk, so you don't run out of disk space. Many clients are using custom stored procedures or third party tools to backup databases in production environments instead of using database maintenance plans. By: Jugal Shah | Updated: | Comments (13) | Related: More > PowerShell

How to delete a power plan