+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Backup failed unlocking database in Technical; I have been attempting to do my November Upgrade this weekend and I receive the subject error message straight after ...
  1. #1

    Join Date
    Mar 2007
    Location
    The North of England
    Posts
    209
    Thank Post
    1
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    Backup failed unlocking database

    I have been attempting to do my November Upgrade this weekend and I receive the subject error message straight after doing the download of the upgrade and prior to doing the backup. Anyone else had this.

    My experience in the past with this is that a workstation has been left logged onto both the network and sims.net or that the server has held a connection. To combat this I created a batch file to shutdown all workstations in the school prior to doing an upgrade and also before doing the upgrade on the servers i restarted them. I say them because the sims application (ie setups etc) are on one server and the database is on another server.

    Any help much appreciated.

  2. #2
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Re: Backup failed unlocking database

    I think I could only get this one to run by running the dbupgrade as SA

    Have you recently had the personnel conversion done?

  3. #3

    Join Date
    Mar 2007
    Location
    The North of England
    Posts
    209
    Thank Post
    1
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    Re: Backup failed unlocking database

    Yes

    Had it done 10 days ago!!

  4. #4
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Re: Backup failed unlocking database

    Request patch 10720 from capita (as this will solve a few issues you will have with personnel 7 that you probably don't know about yet)

    Run this patch via "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\dbUpgrade.exe" /nobackup (you may have to run it twice - note the location of dbupgrade) Make sure you run this patch as the SQL sa user

    Now try running the November update

  5. #5

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    22

    Re: Backup failed unlocking database

    I hit a similar problem where a machine had crashed while running SIMS - I tracked it down through the activity monitor in SQL server management studio which showed a stalled process

SHARE:
+ Post New Thread

Similar Threads

  1. Unlocking mobile phones
    By edie209 in forum General Chat
    Replies: 12
    Last Post: 24th December 2009, 12:05 AM
  2. Unlocking Moblile Phones
    By timbo343 in forum General Chat
    Replies: 6
    Last Post: 21st September 2007, 12:59 PM
  3. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  4. Win2K Server RSM Database / Veritas Backup problem
    By speckytecky in forum How do you do....it?
    Replies: 0
    Last Post: 12th June 2006, 12:44 PM
  5. SIMS .Net upgrade - database backup problems
    By WithoutMotive in forum MIS Systems
    Replies: 7
    Last Post: 28th February 2006, 02:43 PM

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
  •