+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, SIMS on MSSQL 2005 in Technical; Since I migrated to 2005 (from full 2000) the database backup that used to take 6 minutes now takes 40. ...
  1. #1
    AlexB's Avatar
    Join Date
    Jul 2006
    Location
    Warwickshire
    Posts
    365
    Thank Post
    36
    Thanked 36 Times in 32 Posts
    Rep Power
    23

    SIMS on MSSQL 2005

    Since I migrated to 2005 (from full 2000) the database backup that used to take 6 minutes now takes 40.

    Now as all the sims admins know any upgrade/patch carries out a backup before applying (whether you've done one manually or not) So every little patch now takes roughly 40 minutes and 3 seconds.

    This is getting damned annoying with all the little patches that have been needed of late so I rang county support (We pay them for SIMS, I just don't want to know when it comes to SIMS) and the answer back from them. "Thats perfectly normal" grrr

    Anyone else experiencing a huge increase in db backup since the forced move to 2005?

  2. #2
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,424
    Thank Post
    10
    Thanked 488 Times in 428 Posts
    Rep Power
    111

    Re: SIMS on MSSQL 2005

    yes, everyone

  3. #3

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,310
    Thank Post
    35
    Thanked 349 Times in 235 Posts
    Rep Power
    77

    Re: SIMS on MSSQL 2005

    I'm told you can place all patches into a single directory and do the backup once.

  4. #4

    Jawloms's Avatar
    Join Date
    Aug 2007
    Posts
    812
    Thank Post
    175
    Thanked 104 Times in 72 Posts
    Rep Power
    185

    Re: SIMS on MSSQL 2005

    That will certainly work if you have all the patches already. Can you confirm what the situation is if you have three patches to install via SOLUS? I think it will do a backup for each one then.

    Stuart

  5. #5
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,485
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    75

    Re: SIMS on MSSQL 2005

    Quote Originally Posted by Jawloms
    That will certainly work if you have all the patches already. Can you confirm what the situation is if you have three patches to install via SOLUS? I think it will do a backup for each one then.

    Stuart
    dbugrade.exe will perform a backup at the start, not sure about solus.

  6. #6

    Join Date
    Dec 2006
    Location
    Shrewsbury
    Posts
    40
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: SIMS on MSSQL 2005

    SOLUS currently makes a backup for each package that it deploys (ie a separate backup for each patch/release). However - a future version will change this, so that SOLUS makes a single backup.

    Regards,

    Toby Belfield
    Capita

  7. #7

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,203
    Thank Post
    372
    Thanked 376 Times in 334 Posts
    Rep Power
    147

    Re: SIMS on MSSQL 2005

    Yes, I can confirm that it takes 30 mins + for us now also.

  8. #8

    tech_guy's Avatar
    Join Date
    May 2007
    Location
    That little bit in the middle of Little Old England
    Posts
    8,135
    Thank Post
    1,908
    Thanked 1,343 Times in 742 Posts
    Blog Entries
    3
    Rep Power
    395

    Re: SIMS on MSSQL 2005

    Here also :-(

  9. #9
    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: SIMS on MSSQL 2005

    takes about 15 minutes here along with the customary 100+ system log errors

  10. #10
    AlexB's Avatar
    Join Date
    Jul 2006
    Location
    Warwickshire
    Posts
    365
    Thank Post
    36
    Thanked 36 Times in 32 Posts
    Rep Power
    23

    Re: SIMS on MSSQL 2005

    Ah well, at least it isn't me. Its just so damned annoying, but I guess I can say that about a lot of things.

    Also, thanks for that update Toby.

SHARE:
+ Post New Thread

Similar Threads

  1. Ease of SIMS migration to SQL 2005
    By Ric_ in forum MIS Systems
    Replies: 12
    Last Post: 29th February 2008, 02:06 PM
  2. Upgrading SIMS to SQL 2005
    By AnnDroyd in forum MIS Systems
    Replies: 13
    Last Post: 9th October 2007, 03:02 PM
  3. SQL 2005 and SIMS FMS Finance
    By thom in forum MIS Systems
    Replies: 2
    Last Post: 30th August 2007, 04:50 PM
  4. SIMS SQL 2005
    By steve in forum MIS Systems
    Replies: 54
    Last Post: 20th August 2007, 01:35 PM
  5. SIMS + SQL 2005?
    By Norphy in forum MIS Systems
    Replies: 22
    Last Post: 5th April 2007, 10:20 AM

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
  •