Comments
Sort by recent activity
Instead of using "sa" to run the job, here is another solution:
ALTER LOGIN [domain\old_administrator_name] WITH NAME = [domain\new_administrator_name] / comments
Instead of using "sa" to run the job, here is another solution:
ALTER LOGIN [domain\old_administrator_name] WITH NAME = [domain\new_administrator_name]
Not exactly, strange behavior here... when creating a new job, the owner name is filled in with the correct renamed administrator user name. However if I go back in to view the job's properties, the job owner name has reverted back to the standard "Administrator" user name.
Edit: Suggestion from another poster on MS TechNet SQL Server forum was to make the job's owner "sa" ... I did this and now the job is successful. / comments
Not exactly, strange behavior here... when creating a new job, the owner name is filled in with the correct renamed administrator user name. However if I go back in to view the job's properties, t...
SQL Server Agent is being run under a separate user account. I tried adding this user to the Administrators group, but the job still fails. / comments
SQL Server Agent is being run under a separate user account. I tried adding this user to the Administrators group, but the job still fails.
petey wrote:
Have you updated the owner of the SQL Server Agent job that performs the backup task?
Thanks.
The owner of the job is still MYSERVERNAME\Administrator and if I browse user objects, only the old MYSERVERNAME\Administrator user name is selectable -- the renamed admin user is not in the list.
Restarted SQL Server Agent hoping it might refresh the list, it did not.
Also noticed I am not being notified via email of job failure even though I specified this in the Red Gate GUI. / comments
petey wrote:
Have you updated the owner of the SQL Server Agent job that performs the backup task?
Thanks.
The owner of the job is still MYSERVERNAME\Administrator and if I browse user objects,...
I think I will just figure a way to pull the backup file via FTP. I can't expose an open Windows file share to the internet... / comments
I think I will just figure a way to pull the backup file via FTP. I can't expose an open Windows file share to the internet...
Ok, I'm playing with the trial version, running the GUI from my laptop. It seems I cannot pull the backup through the SQL connection to my laptop from the remote SQL server - it places the backup on the server's local drive. There is the option in the backup job to copy the backup to a network share, but that is not possible because there is no windows file share on the remote SQL server open to the internet (and god help us if we did that!) Is there no way to get a local copy of the backup via this software? / comments
Ok, I'm playing with the trial version, running the GUI from my laptop. It seems I cannot pull the backup through the SQL connection to my laptop from the remote SQL server - it places the backup ...
Just to update the thread - I updated SQL Data Compare to the latest version today, 10.2.3.5, and updated SQL Backup to 7.2.0.286, executed a full encrypted backup, ran a data compare of the encrypted backup to the live database, and the bug still exists. / comments
Just to update the thread - I updated SQL Data Compare to the latest version today, 10.2.3.5, and updated SQL Backup to 7.2.0.286, executed a full encrypted backup, ran a data compare of the encryp...
The SQL Virtual Restore idea sounds good, however this statement on the requirements page concerns me:
"If you would like to use SQL Virtual Restore with encrypted SQL Backup Pro backups, please decrypt them first. Decryption for all other backup types is supported."
... my backups are encrypted with SQL Backup 6.4. Does this mean I would have to have a copy of SQL Backup 6.x installed on the same machine so I can decrypt my backups, before SQL Virtual Restore can open them? / comments
The SQL Virtual Restore idea sounds good, however this statement on the requirements page concerns me:
"If you would like to use SQL Virtual Restore with encrypted SQL Backup Pro backups, please de...
Thanks, that utility is most helpful! I don't suppose there's a way to script that utility from the command line? / comments
Thanks, that utility is most helpful! I don't suppose there's a way to script that utility from the command line?
David Atkinson wrote:
I think we may have changed this to require a double click. Could you try this and let us know if it works as you expected?
David Atkinson
Red Gate Software
Ah yes, a double click works! Thank you. / comments
David Atkinson wrote:
I think we may have changed this to require a double click. Could you try this and let us know if it works as you expected?
David Atkinson
Red Gate Software
Ah yes, a dou...