+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, SIMS .Net upgrade - database backup problems in Technical; I was just about to do the February upgrade today via SOLUS. This being the best time as it's half ...
  1. #1
    WithoutMotive's Avatar
    Join Date
    Feb 2006
    Location
    Wigan, UK
    Posts
    628
    Thank Post
    41
    Thanked 47 Times in 41 Posts
    Rep Power
    27

    SIMS .Net upgrade - database backup problems

    I was just about to do the February upgrade today via SOLUS.
    This being the best time as it's half term.

    As always, I backup the database from System Manager first.
    Usually goes ok, however, today I had a message saying that the "Operation cannot complete when the object is closed" and the backup is abandoned.

    On running SOLUS, the download goes ok and the upgrade is fine until the actual database upgrade when it automatically start backing it up first. At this point, it told me that the database was locked and it cannot be backed up.

    Now, as it's half term, I was the only one in the building apart from the caretaker so there was definitely no one logged into SIMS .Net. All the computers were off. So how was the database locked and how to I stop this from happening in the future?

    I had to backup the database files manually and run DBUPGRADE /NOBACKUP to complete the upgrade.

    Any advice would be appreciated.

  2. #2

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,933
    Thank Post
    1,339
    Thanked 1,783 Times in 1,106 Posts
    Blog Entries
    19
    Rep Power
    594

    Re: SIMS .Net upgrade - database backup problems

    Although it is never written down or sent out in upgrade instructions it is always a good idea to reboot the server before doing the backup and then upgrade.

    I tend to do a ghost backup before the monthly upgrade, just in case.

    This has saved me more times than I care to think.

  3. #3
    eejit's Avatar
    Join Date
    Jun 2005
    Location
    Ireland
    Posts
    606
    Thank Post
    52
    Thanked 12 Times in 12 Posts
    Rep Power
    22

    Re: SIMS .Net upgrade - database backup problems

    You take a ghost of your SIMS server before an upgrade? Wow.
    How do you get the time to schedule in that kind of downtime?

  4. #4
    mark's Avatar
    Join Date
    Jun 2005
    Posts
    3,966
    Thank Post
    248
    Thanked 49 Times in 45 Posts
    Blog Entries
    2
    Rep Power
    46

    Re: SIMS .Net upgrade - database backup problems

    hehe - yes - My SIMS server is in use from 8:30am to 6pm weekdays, and sporadically at weekends - I have to book downtime then.

  5. #5

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,530
    Thank Post
    1,496
    Thanked 1,050 Times in 919 Posts
    Rep Power
    303

    Re: SIMS .Net upgrade - database backup problems

    Do my methods (all be it, i use Facility), force the users off from the system manager screen, then "whoopse, my foot caught the power lead"

  6. #6

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,828
    Thank Post
    24
    Thanked 91 Times in 71 Posts
    Rep Power
    50

    Re: SIMS .Net upgrade - database backup problems

    DB locking always used to be a problem with my previous Sims School. I found easiest to scheduel a reboot in the middle of the night and do a backup on startup.

    Rebooting is Windows best friend/worst enemy.

    I see with Solus2 you can schedule installs now. Might be a god send

  7. #7

    Join Date
    Jul 2005
    Location
    Corby
    Posts
    1,056
    Thank Post
    12
    Thanked 20 Times in 18 Posts
    Rep Power
    24

    Re: SIMS .Net upgrade - database backup problems

    Yes- a reboot usually fixes that one. As for ghosting the SIMS server: isn't that a bit extreme? I can understand extreme hesitation with any SIMS update, but just a system backup with System State etc should be enough to recover things surely?

    The latest update went really well for us- traditionally we have minor client update issues after updates but this one sent us none. Read that again. None!

    Great :-)

  8. #8
    WithoutMotive's Avatar
    Join Date
    Feb 2006
    Location
    Wigan, UK
    Posts
    628
    Thank Post
    41
    Thanked 47 Times in 41 Posts
    Rep Power
    27

    Re: SIMS .Net upgrade - database backup problems

    Thanks for all your input... however, I've just found an article on Capitas support website that seemed to do the trick. Posting it here in case anyone else has the same problem ever:


    KB24748 - Backup failed unlocking database
    Created 27/05/2004
    Last Updated 24/02/2006

    Affected Products SIMS .net Installation & Upgrade
    Notes
    Backup failed
    Unlocking database

    Error occurs when a backup is being performed before the SQL database is upgraded.
    Additional Notes

    CAUSES
    1. The backup fails due to insufficient space on the server.

    Or

    2. The SQL log file is so large that there is insufficient space to create the backup.

    3. Full SQL has been installed on 2 seperate drives eg Program Folders on C: and Data & Backup folders on D:. SIMS has been coded to use a default installation of SQL ie All folders installed to one location and therefore fails when it tries to access the Backup folder.

    Or

    4. SIMS Infrastructure has not been installed and therefore the backup file cannot be zipped as Dynazip is missing.
    Advice
    FIX 1: Check there is sufficient space on the partition where SQL is installed. Also check the system partition has sufficient space as temporary files can be created during the backup.

    FIX 2: Check the size of the SQL Log file eg SIMS.LDF. If excessively large use SHRINKDBLOG.BAT to shrink the log file.

    FIX 3: Workaround:

    Take a copy of the sims.mdf and sims.ldf. This will act as the backup for the upgrade.

    At a dos prompt change directory to the location of SQL eg C:\program files\Microsoft SQL server\MSSQL$SIMS\binn.

    Then type DBUPGRADE /NOBACKUP

    This will run the DBUpgrade Tool and the /nobackup switch will upgrade the database with no backup.

    FIX 4: Install SIMS Infrastructure.

SHARE:
+ Post New Thread

Similar Threads

  1. Backup failed unlocking database
    By ctbjs in forum MIS Systems
    Replies: 4
    Last Post: 17th December 2007, 02:58 PM
  2. Restoring problems on backup (SIMS and Veritas)
    By steelrazor in forum MIS Systems
    Replies: 3
    Last Post: 6th July 2007, 07:25 AM
  3. Problems With Upgrade To XP ....Help....
    By tickmike in forum Windows
    Replies: 11
    Last Post: 19th March 2007, 02:42 PM
  4. Sophos v5 upgrade problems.
    By Geoff in forum Windows
    Replies: 68
    Last Post: 16th June 2006, 11:28 AM
  5. 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

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
  •