+ Post New Thread
Results 1 to 6 of 6
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 ...
  1. #1
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0

    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:

    Login failed for user 'sa' because the account is currently locked out. The
    system administrator can unlock it.
    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?

  2. #2

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,970
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    So you are not getting any backups? Or are you getting some and not others?

  3. #3
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by GREED View Post
    So you are not getting any backups? Or are you getting some and not others?
    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!

  4. #4

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,970
    Thank Post
    367
    Thanked 359 Times in 293 Posts
    Blog Entries
    8
    Rep Power
    173
    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.

  5. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Not something silly like SQL is stopped?

  6. #6
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 21
    Last Post: 18th January 2011, 12:20 PM
  2. [SIMS] DBATTACH for FMS Why different? [Solved]
    By mark-p in forum MIS Systems
    Replies: 9
    Last Post: 6th January 2011, 07:05 PM
  3. Backup SQL using Command Line
    By linkazoid in forum How do you do....it?
    Replies: 1
    Last Post: 11th November 2010, 11:02 AM
  4. Sharepoint and SQL backup
    By wesleyw in forum Virtual Learning Platforms
    Replies: 1
    Last Post: 22nd September 2009, 07:34 PM
  5. Problem with batch backup or SIMS.net using DBAttach
    By GreenICT in forum MIS Systems
    Replies: 5
    Last Post: 18th August 2009, 08:48 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •