Skip to Content

Limit Number of Auto Backup Copies Generated by RSP in SAP B1 SQL

Hi Experts,

So recently I have configured Auto Backup (Full Database) scheme on a daily basis since database size is quite less as of now maybe I will increase interval at a later stage.

So problem is that it generates a new copy of backup for each day and I am unable to figure out a method where i can remove older backups or limit the number of copies.

I have explored both methods available in RSP

1. Using Task

2. Using Backup Management

Usinf RSP 3.2, SAP B1 9.3 PL06 SQL

Please advise me or share link to a resource where I can learn more about it (already Searched in forum and web as well).

Thanks

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Aug 06 at 12:58 AM

    Hello,

    If I remember correct there is no default option available in RSP to delete the backup.

    You can create a batch file to delete the older backups and configure it under the windows scheduler to delete them automatically.

    Otherwise you can configure in the SQL Server as it has the capability to do backup and delete them on schelude basis.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded