Create automatic backup on sqlserver and send confirmation email

Question

I need to create an automatic daily BACKUP for a sqlserver database. - The name of the backup should follow the following pattern: BACKUP_BANCO_DIA_MES_ANO;

• After creating BACKUP, send a status email (SUCCESS or ERROR);

• If SUCCESS, copy the BACKUP to Google Drive and delete the previous BACKUP;

• If ERROR, send email informing error.

I found this tutorial but did not understand very well how to use it: https://social.technet.microsoft.com/Forums/pt-BR/07feb406-2bf4-478a-8aab-9abbbac97968/script-backup-sql-express?forum=admingeralpt

From now on I’d appreciate it if someone could help me?

Answer 1

Hello, I saw this tutorial and used this very good utility by the way and very simple! following example!

After you have installed you only need to connect the utilities to your sql instance as the image below!

soon after you have successfully logged in you just need to configure the process Backup/E-mail as example image below!

Ready this configured and very simple!