Backup con SqlServerBooster

SqlServerBooster is very useful because it allows easily to create a backup of sql server, to copy it also on one or more remote folders and to delete the oldest backups from all the destinations.

but many have noticed that copying to remote folders works only when you start the task by hand while producing an authentication error (yellow dot) when the task runs automatically at the preset time

to remedy this problem you can configure sqlserverbooster to run commands before and after the backup

For example the following configuration is to create TWO copies of the backup: the first on 192.168.1.16 and the second on 192.168.1.2 (example in Conakry)

To give permission to write to the destination you need to create these command lines in one of the following screens

in the BEFORE window:

net use /user:backupsql \\192.168.1.16\BK_Conackry\DIXINN pwddream 
net use /user:backupsql \\192.168.1.2\mssqlfile_bkps3 cona06 pwddream 

in the AFTER window

net use /delete \\192.168.1.16\BK_Conackry
net use /delete \\192.168.1.2\mssqlfile_bkps3

ATTENTION: on the destination server (in the example 192.168.1.16 and 192.168.1.2) you have to create a user with login name: backupsql and password pwddream