MIS Systems Thread, SQL Backup with dbAttach [Solved] in Technical; We have an automated script that runs each night to back up the SIMS and FMS database using the command ...
6th January 2011, 09:54 AM #1
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.
6th January 2011, 10:04 AM #2
So you are not getting any backups? Or are you getting some and not others?
6th January 2011, 10:06 AM #3
Backups are fine in all other schools except this one where we seem to have a successful backup every other day instead of daily. The scheduled backup task runs at 8pm and one night it will work fine, but the next night we wont get a backup at all and the above error is the reason for the failure. Then, if I run the script manually first thing the following day, it works fine again!
Originally Posted by GREED
6th January 2011, 10:13 AM #4
Your sure there are no events running at that same time that might affect this? NT backups or anything like that?
I had an issue where the SA account was locked out and I needed to run some SQL code to release it, but this would affect you consistantly.
6th January 2011, 10:44 AM #5
Not something silly like SQL is stopped?
6th January 2011, 11:17 AM #6
Found the issue. Seems the school are trailing a new online backup solution that runs at the same time as our backup. It has a separate SQL backup feature and they are using the incorrect SA password to back up every database which causes it to be locked out after 3 or 4 attempts. So when our backup task starts, the password is locked. It then gets unlocked overnight meaning I can run a backup as normal.
Thanks for the help guys.
By dtakias in forum MIS Systems
Last Post: 18th January 2011, 01:20 PM
By mark-p in forum MIS Systems
Last Post: 6th January 2011, 08:05 PM
By linkazoid in forum How do you do....it?
Last Post: 11th November 2010, 12:02 PM
By wesleyw in forum Virtual Learning Platforms
Last Post: 22nd September 2009, 08:34 PM
By GreenICT in forum MIS Systems
Last Post: 18th August 2009, 09:48 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)