+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, Help Please june Update + sql2008 in Technical; well Ive just tried to do the June Upgrade on my test system running SQL2008/sp1 and the march version of ...
  1. #1

    Join Date
    Sep 2007
    Posts
    223
    Thank Post
    4
    Thanked 25 Times in 23 Posts
    Rep Power
    19

    Help Please june Update + sql2008

    well Ive just tried to do the June Upgrade on my test system running SQL2008/sp1 and the march version of sims
    And it's not playing:


    reading supportnet you need solus "2.whatever" But the version thats on the ISO is ver 1.19
    the install keeps failing with backup failed no_log not supported

    I cant find docs on supportnet to help and since there fix for locked backups only applies to sql 2005 im stuck

    Anybody got any ideas?

    Cheers
    Andy

  2. #2

    Join Date
    Dec 2006
    Location
    Preston, Lancashire
    Posts
    126
    Thank Post
    13
    Thanked 12 Times in 11 Posts
    Rep Power
    18
    SIMS has a problem with locking the database at the moment, and it fails on the backup. To get around the problem you currently need to put the database into single user mode to perform upgrades. Capita have a fix available (I'm installing it tomorrow).

  3. #3
    Diello's Avatar
    Join Date
    Jun 2005
    Location
    Kent, England
    Posts
    1,064
    Thank Post
    112
    Thanked 228 Times in 128 Posts
    Rep Power
    74
    SIMS doesn't support SQL 2008, that's your first problem, so no reason it would work.

    As for the error... Have you got transaction logging turned off?

  4. #4

    Join Date
    Dec 2006
    Location
    Preston, Lancashire
    Posts
    126
    Thank Post
    13
    Thanked 12 Times in 11 Posts
    Rep Power
    18
    Good point Diello. 2008 not officially supported until later this year, but I have assumed that upgrades have worked on your test system before?

  5. #5

    Join Date
    Sep 2007
    Posts
    223
    Thank Post
    4
    Thanked 25 Times in 23 Posts
    Rep Power
    19
    yep march 09 runs fine on sql2008

    will have to try locking sql to single user will report back soon...

    I know i would not want to be having to jump straight to sql2008 without testing it first ....

  6. #6

    Join Date
    Sep 2007
    Posts
    223
    Thank Post
    4
    Thanked 25 Times in 23 Posts
    Rep Power
    19
    nope single user didnt work...
    looks like im taking sql2008 off and reinstalling my test rig
    ho hum

  7. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,407
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    Why would you test something before it's supported? There basically saying it won't work lol!

  8. #8

    Join Date
    Sep 2007
    Posts
    223
    Thank Post
    4
    Thanked 25 Times in 23 Posts
    Rep Power
    19
    i was looking at the work that i might have to do over the holidays no biggie will just go back to 2005
    but it would have been nice to have 6 weeks to play with sims on sql 2008 rarther than just having it dumped on us in october...


    teach me to planm ahead....

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 5
    Last Post: 28th August 2008, 09:55 AM
  2. SIMS June Update
    By skunk in forum MIS Systems
    Replies: 33
    Last Post: 1st August 2008, 01:28 AM
  3. SLG + June Update!?
    By PRicho in forum MIS Systems
    Replies: 0
    Last Post: 30th June 2008, 10:50 AM
  4. THREE jobs in West Kent (close 16th June and 25th June)
    By elsiegee40 in forum Educational IT Jobs
    Replies: 0
    Last Post: 6th June 2008, 07:34 AM
  5. XP Retail June End
    By sLiDeR in forum Windows
    Replies: 19
    Last Post: 1st April 2008, 10:01 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
  •