Activity overview
Latest activity by gswartwood
Petey, as I wrote in a response above, I have already used sqbsetlogin to specify a SQL account for the backup to use. When I ran the command, I get a result set with a single column named 'result' and a null value in the column. Since the few forum posts that explain how to run the command do not specify what the successful exeecution result value looks like, I assume that the command worked. Running the command did not change the behavior of my problem. / comments
Petey, as I wrote in a response above, I have already used sqbsetlogin to specify a SQL account for the backup to use. When I ran the command, I get a result set with a single column named 'result'...
I was able to run it manually (exact sql generated by Redgate) using the SQL Server account that I told Redgate to use (during server component installation). I also have made sure that owner of SQL Agent Job was the same SQL account. I was able to get the SQL agent job to work if I set the "Run As User" advanced option for the 'execute master..sqlbackup' step within the SQL Agent job to the SQL Account.
I tried using sqbsetlogin again to set the user/password. It doesn't fail, but doesn't give anything for a result either. I then set up another backup job and the new job didn't work even after setting sqbsetlogin. It kept trying to execute the backup as <domain>\sql-sa.
The end result: I can a Red Gate created scheduled job to work if I set the Run As User advanced option within the job. Otherwise, Red Gate keeps using sql-sa. / comments
I was able to run it manually (exact sql generated by Redgate) using the SQL Server account that I told Redgate to use (during server component installation). I also have made sure that owner of SQ...
I have not executed the backup manually. I will have to attempt that tonight for I do not want to affect our production DB during the day.
As for the owner of the backup job defined in SQL Server Agent, it is set to the SQL Server account that has permissions to perform backups and not set to <domain>\sql-sa. / comments
I have not executed the backup manually. I will have to attempt that tonight for I do not want to affect our production DB during the day.
As for the owner of the backup job defined in SQL Server A...
Unable to get Backup to execute as correct user
WHen I installed the trial of backup 6 on our SQL Server, I mistakenly did not change the services execute as <domain>/SQL-SA. Since we don't have an account by that domain, scheduled backups don't...