Hello,
I have problem with backup from sql. I have 3 different databases on one sql server. Every database have different user accounts and this is impossible to use one account for all databases - when I try there was a message from provider that this user allready exist).
When I have created backup jobs with MySQL server (TCP/IP) only one of them work properly because when i gave credentials for new database on that server, it was replace credentials on previously created tasks.
in ex.:
job1
server: sql.myname.nazwa.pl
user: user1
password: password1
db: db1
job2
server: sql.myname.nazwa.pl
user: user2
password: password2
db: db2
job3
server: sql.myname.nazwa.pl
user: user3
password: password3
db: db3
After this all jobs have credentials from job3, so job1 and job2 failed. When I changed credentials for job1 it was changed on all of them so job 2 and job3 failed.
Is there any way to do this?