In order to create database backups through SqlBak or SQLBackupAndFTP, the user specified when adding the connection must have sufficient privileges to perform the backup operation. Although you can use a superuser to create a backup without any problems, it is considered best practice to create a separate user specifically for this purpose.
Below are examples of SQL scripts for creating a backup user, as well as the necessary privileges for database recovery.
Please note that it is not necessary to grant recovery permissions immediately. This can be done when you need to restore the database.