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.
IDG Tech News
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)