+ 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. #1
    ninjabeaver's Avatar
    Join Date
    Jun 2005
    Location
    Norfolk
    Posts
    1,090
    Thank Post
    183
    Thanked 100 Times in 88 Posts
    Rep Power
    47

    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.

  2. #2

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,217
    Thank Post
    116
    Thanked 332 Times in 274 Posts
    Blog Entries
    4
    Rep Power
    115
    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.

  3. Thanks to jamesb from:

    ninjabeaver (14th January 2009)

  4. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,450
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    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.

  5. Thanks to matt40k from:

    ninjabeaver (14th January 2009)

  6. #4

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,967
    Thank Post
    1,212
    Thanked 1,075 Times in 766 Posts
    Rep Power
    332
    @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.

  7. Thanks to bossman from:

    ninjabeaver (14th January 2009)

  8. #5

    Join Date
    May 2007
    Location
    Hull, UK
    Posts
    256
    Thank Post
    6
    Thanked 13 Times in 13 Posts
    Rep Power
    18
    Mines takes about 30 mins usually. for just over 1gb database

  9. Thanks to mcloum from:

    ninjabeaver (20th January 2009)

  10. #6

    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

  11. Thanks to Jeremy69 from:

    ninjabeaver (20th January 2009)

  12. #7
    AyatollahPies's Avatar
    Join Date
    Jan 2008
    Location
    Earth
    Posts
    900
    Thank Post
    48
    Thanked 105 Times in 95 Posts
    Rep Power
    42
    Also depends on your hardware. What spec is the server?

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, 01:30 PM
  2. Sims.net modules time out
    By paul in forum MIS Systems
    Replies: 8
    Last Post: 5th November 2008, 09: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, 01:11 PM
  5. SIMS .net backup path
    By Jawloms in forum MIS Systems
    Replies: 2
    Last Post: 26th October 2007, 03:17 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
  •