Video: How to test if you have enough permission to delete old backup files using a maintenance p (4352816)

Video: How to test if you have enough permission to delete old backup files using a maintenance p

LiteSpeed maintenance plan deletes old backup files using the SQL Server service and SQL Server agent account credentials. In order to delete the old backup via LiteSpeed maintenance plan, SQL Server service and agent account needs to have rights to list the files in the folder and rights to delete the backup file.

Please see video below

To test if the SQL Server service and agent account have enough rights to list the files, start a command prompt using the SQL server service or agent account(if they are different) and issue the following command:
dir /B /O-D /TW <full path of a directory that the sql server instance is backed up to>

If the account has enough rights, it will return a list of files located in that directory.

ST86326

Check that the SQL Server and SQL Server Agent service accounts have full control of the backup directory.
If it's a network share, check that both service accounts have full control of the network share.
If you are using a proxy account, check that the account is a member of the sysadmin server role and that is has full control of the backup directory and network share.
Check that the file is not locked in the file system. It could for example be a backup or anti-virus software that is locking the file.
DatabaseBackup has been designed not to delete transaction log backups that are newer than the latest full or differential backup. This could be the reason for transaction log backups not being deleted.