+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, sims.net backup in Technical; Hi we have now been asked to run patches upgrades and backup of sims.net. Could I go on a course ...
  1. #1

    Join Date
    Feb 2008
    Posts
    325
    Thank Post
    51
    Thanked 3 Times in 3 Posts
    Rep Power
    14

    sims.net backup

    Hi we have now been asked to run patches upgrades and backup of sims.net. Could I go on a course to do this or any website links etc?

    Thanks

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350

    Run patch via dbupgrade

    There is a thread here that describes backup processes, but that's too much detail for what you need, though may be of general interest if you are taking on these extra responsibilities: Sims Backup

    You will need some high level access to carry out these tasks.

    Firstly make sure you have a decent backup, so you need access to system manager - Focus | System. From there you can go to the Tools menu, check on the backup path, and then create a backup. This can be done when users are on the system, but i prefer to have everyone off, which you'll need for the next steps anyway.

    Capita's SupportNet website has instructions on running a patch, KB article #92874 - though your support team / Capita should really have sent you instructions if they are expecting you to do this.

    The patch will come via a Solus download (if you've not used solus before, you really should call your local support for help on this) or via email.

    If you are doing these sorts of tasks now, you should have access to the SupportNet site, if you don't request access asap. SupportNet

    The content of the KB is below, but i strongly suggest you access SupportNet and seek advice from your support team, if you going to be doing all your own stuff, especially upgrades which can be painful.

    KB92874 - How to run a patch through DBupgrade


    Created 27/10/2009Last Updated 20/01/2011

    Affected Products SIMS .net System Maintenance & Utilities

    Notes
    How to apply a patch using DBupgrade.exe



    How to run DBupgrade.exe

    Additional Notes
    SIMS.net patches can now be applied through DBupgrade.

    These patches will be of the format '3.61.001 to 3.61.999 9999 Patch.ZIP'.

    Advice
    1. Extract the patches to e.g Desktop. There should be 2 files e.g '3.61.000 to 3.61.132 2993 Patch.ZIP' and '3.61.000 to 3.61.132 2993 Patch.ZIP.signature'


    2. Run DBupgrade.
    This is located in C:\Program Files\SIMS\SIMS .net\DBupgrade.exe (on workstation)
    or
    C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\DBupgrade.exe (on SIMS SQL server)

    3. Select 'Run the following SIMS database upgrade file' and path to the location of the patch file (zip).

    4. Login with Sims username and password and click LOGIN. If advised to run the patch as the SA user please specify SA as the SIMS Username and enter your SA password

    5. Patch should now show, click install.
    Please, if in doubt, call your support team or at least come here and check with someone first.

  3. Thanks to vikpaw from:

    itgeek (8th April 2011)

  4. #3
    NorthernSands's Avatar
    Join Date
    Mar 2011
    Location
    Qatar
    Posts
    134
    Thank Post
    21
    Thanked 19 Times in 19 Posts
    Rep Power
    10
    Other than what Vik has said, which is absolutely spot on, make sure you have a good backup before running any patch on the DB (I know it does a backup during the patching routine, but this can fail).

    Regular backups of the SIMS (and FMS) DB are vital. Some establishments (mine included) backup the DB more than once a day. SIMS is very good from a data-integrity point of view, but it can go wrong (not to mention what staff can achieve!).

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 5
    Last Post: 31st May 2010, 08:26 AM
  2. Replies: 23
    Last Post: 3rd October 2009, 05:44 PM
  3. 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
  4. SIMS .net backup path
    By Jawloms in forum MIS Systems
    Replies: 2
    Last Post: 26th October 2007, 03:17 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
  •