+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, SIMS Backup Time in Technical; Hi guys, I've been volunteered to do the patches and upgrades on the SIMS.net system we have here. There's been ...
  1. 14th January 2009, 10:46 AM #1
    ninjabeaver
    ninjabeaver is offline
    ninjabeaver's Avatar
    Join Date
    Jun 2005
    Location
    Norfolk
    Posts
    1,050
    Thank Post
    164
    Thanked 87 Times in 77 Posts
    Rep Power
    37

    SIMS Backup Time

    Hi guys,

    I've been volunteered to do the patches and upgrades on the SIMS.net system we have here.

    There's been one or two little patches that needed running on the DB recently to fix minor bugs but each time we patch it's taken apporximately 45 minutes to do a complete DB backup.

    The reason I'm asking this is that when the CAPITA techy came in to setup the SIMS Gateway he was telling me it should not be taking that long and there is a 'fix' for it.

    I'm curious to what other people patch backup times are and if there is a fix.

    Cheers,
    Simon.
    Reply With Quote Reply With Quote
  2. IDG Tech News

  3. 14th January 2009, 10:56 AM #2
    jamesb
    jamesb is offline
    Join Date
    Mar 2008
    Location
    Woking
    Posts
    2,094
    Blog Entries
    4
    Thank Post
    86
    Thanked 302 Times in 249 Posts
    Rep Power
    98
    What's the actual size of your database, and which backup method are you using? Depending on what its doing it may take this long, particularly if its compressing a large backup to a .zip format.

    One thing to try might be using one of the other available methods to do a backup, without compressing the result, and see if there's a difference in time. If there is then you can run the dbupgrade console without doing a backup using the command dbupgrade /nobackup.
    Reply With Quote Reply With Quote

  4. Thanks to jamesb from:

    ninjabeaver (14th January 2009)
  5. 14th January 2009, 11:06 AM #3
    matt40k
    matt40k is offline
    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    3,130
    Thank Post
    218
    Thanked 368 Times in 313 Posts
    Rep Power
    87
    There is a few options.

    First you need the dynazip patch, which is basically now useless.
    The other is to turn off compression on the backup file, patch 12460.
    The final is to run dbupgrade with /nobackup. Just make sure you backup before you start!

    It should be resolve in the march 09 release.
    Reply With Quote Reply With Quote

  6. Thanks to matt40k from:

    ninjabeaver (14th January 2009)
  7. 14th January 2009, 11:09 AM #4
    bossman
    bossman is offline

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    3,313
    Thank Post
    859
    Thanked 823 Times in 597 Posts
    Rep Power
    276
    Send a message via MSN to bossman Send a message via Skype™ to bossman
    @ninjabeaver:
    About the same time here and it does get a little tedious if you are having to just do a couple of patches i know but it all seems to work.
    I save updates and patching until a Thursday night so i have the time to do it usually get out about 6 - 6:30 after everyone has logged out at 4:30, stop the terminal services on the remote Sims access and then update the terminal server Sims.net job done then on to McDonalds with webman and then on to college after that.
    Reply With Quote Reply With Quote

  8. Thanks to bossman from:

    ninjabeaver (14th January 2009)
  9. 14th January 2009, 11:17 AM #5
    mcloum
    mcloum is offline
    Join Date
    May 2007
    Location
    Hull, UK
    Posts
    256
    Thank Post
    6
    Thanked 13 Times in 13 Posts
    Rep Power
    13
    Send a message via MSN to mcloum
    Mines takes about 30 mins usually. for just over 1gb database
    Reply With Quote Reply With Quote

  10. Thanks to mcloum from:

    ninjabeaver (20th January 2009)
  11. 14th January 2009, 02:39 PM #6
    Jeremy69
    Jeremy69 is offline
    Join Date
    Feb 2007
    Location
    Barnet
    Posts
    87
    Thank Post
    12
    Thanked 14 Times in 12 Posts
    Rep Power
    0

    Back up time

    Used to take 7 minutes. Went to over half an hour last year but I've now installed the patches(including the dynazip one), run the backups from dbattach and it is back to about 6 minutes for SIMS (2.5gb) and under 3 minutes for FMS
    Reply With Quote Reply With Quote

  12. Thanks to Jeremy69 from:

    ninjabeaver (20th January 2009)
  13. 16th January 2009, 11:40 AM #7
    AyatollahPies
    AyatollahPies is offline
    AyatollahPies's Avatar
    Join Date
    Jan 2008
    Location
    Earth
    Posts
    900
    Thank Post
    48
    Thanked 105 Times in 95 Posts
    Rep Power
    37
    Also depends on your hardware. What spec is the server?
    Reply With Quote Reply With Quote
SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Logging Users Off and Time Outs SIMS
    By Grommit in forum MIS Systems
    Replies: 27
    Last Post: 18th January 2012, 02:30 PM
  2. Sims.net modules time out
    By paul in forum MIS Systems
    Replies: 8
    Last Post: 5th November 2008, 10:57 AM
  3. SIMS upgrade backup problem
    By ee01akk in forum MIS Systems
    Replies: 3
    Last Post: 29th August 2008, 11:37 AM
  4. Sims Audio Cast what time?
    By russdev in forum MIS Systems
    Replies: 17
    Last Post: 5th December 2007, 02:11 PM
  5. SIMS .net backup path
    By Jawloms in forum MIS Systems
    Replies: 2
    Last Post: 26th October 2007, 03:17 PM
« Enterprise not making a bid for Leeds schools | SIMS error »

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
  •  

Forum Rules