SQL Backup with dbAttach [Solved]
We have an automated script that runs each night to back up the SIMS and FMS database using the command line parameters of dbAttach.exe.
The same script runs in 250+ schools but with one site, it fails almost every other day with the following error:
No work has been done to cause the SA password to reset and if you run the script in the morning, it works fine. I can't see anything thats causing the SA password to be locked out as there are no other tasks/jobs running that use it. Any ideas?
Login failed for user 'sa' because the account is currently locked out. The
system administrator can unlock it.