+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, Sims SQL upgrade 2008 R2? in Technical; Can I use SQL server 2008 R2 in the upgrade process for Sims from 2005 version?...
  1. #1
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86

    Sims SQL upgrade 2008 R2?

    Can I use SQL server 2008 R2 in the upgrade process for Sims from 2005 version?

  2. #2
    bodminman's Avatar
    Join Date
    Apr 2007
    Location
    Sunny Suffolk
    Posts
    1,153
    Thank Post
    724
    Thanked 224 Times in 116 Posts
    Rep Power
    84
    IIRC the guidelines tell you this. The answer is though I don't think so.

  3. #3

    Theblacksheep's Avatar
    Join Date
    Feb 2008
    Location
    In a house.
    Posts
    1,934
    Thank Post
    138
    Thanked 290 Times in 210 Posts
    Rep Power
    193
    We were advised not to use sql2008r2.

    2008 only.

  4. #4

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,843
    Thank Post
    876
    Thanked 1,679 Times in 1,459 Posts
    Blog Entries
    12
    Rep Power
    444
    Quote Originally Posted by Theblacksheep View Post
    We were advised not to use sql2008r2.

    2008 only.
    Same here.

  5. #5
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86
    Grr I wish Capita would keep up-to-date.

    I've checked the install notes and there is no mention about not using SQL server R2 in there.

  6. #6
    Shane's Avatar
    Join Date
    Apr 2007
    Location
    Kernow
    Posts
    166
    Thank Post
    23
    Thanked 14 Times in 12 Posts
    Rep Power
    21
    I used SQL2008 SR2 in the upgrade process and haven't come accross any issues (or no more issues than usual)
    Last edited by Shane; 26th October 2010 at 12:26 PM. Reason: missed the L in SQL2008

  7. #7

    Theblacksheep's Avatar
    Join Date
    Feb 2008
    Location
    In a house.
    Posts
    1,934
    Thank Post
    138
    Thanked 290 Times in 210 Posts
    Rep Power
    193
    Quote Originally Posted by zag View Post
    Grr I wish Capita would keep up-to-date.

    I've checked the install notes and there is no mention about not using SQL server R2 in there.
    FYI: Our was a call from the LA (last month) saying "you've not used 2008 r2 have you? theres been some backend issues discovered and 2008 must be used"

  8. #8


    Join Date
    Feb 2007
    Location
    51.405546, -0.510212
    Posts
    8,772
    Thank Post
    222
    Thanked 2,631 Times in 1,939 Posts
    Rep Power
    779
    I was advised against this by Capita too (yesterday in fact). I wonder if the delay is due to Microsoft's .Net Framework v1.1 not being supported on Windows Server 2008 R2?

  9. #9
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86
    Got this error during the migrate process, any ideas how to fix?

    Image1.jpg

    EDIT: Nevermind, carried on with the manual steps and its working ok.

    How do I set the recovery model?
    Last edited by zag; 26th October 2010 at 01:13 PM.

  10. #10

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,387
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Have you got SQL Management studio installed?

  11. #11
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,762
    Thank Post
    897
    Thanked 416 Times in 350 Posts
    Blog Entries
    12
    Rep Power
    86
    Yes I have, (I just used it to give the backupexec user permissions to connect to the DB)
    Last edited by zag; 26th October 2010 at 02:15 PM.

  12. #12

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,652
    Thank Post
    516
    Thanked 2,443 Times in 1,891 Posts
    Blog Entries
    24
    Rep Power
    831
    The key question here is - why do you want to use SQL2008 R2 when Capita say not to?

    Surely you should use the tools that Capita state are the right ones?

  13. #13

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,387
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Quote Originally Posted by zag View Post
    Grr I wish Capita would keep up-to-date.
    I've checked the install notes and there is no mention about not using SQL server R2 in there.
    Maybe because the document was written pre-SQL2008R2. Distribution of updates isn't as easy as you think.

    Quote Originally Posted by Arthur View Post
    I was advised against this by Capita too (yesterday in fact). I wonder if the delay is due to Microsoft's .Net Framework v1.1 not being supported on Windows Server 2008 R2?
    SIMS uses v2, it's moving to v4 in Spring 2011. Not aware of anything using v1.1, I guess there is some small bit in there that could be.

    Quote Originally Posted by zag View Post
    How do I set the recovery model?
    Database > properties > options > recovery model - change to simple. If you can't figure it out, close sql studio management and log a call with capita\local support team and request the patch.

    Quote Originally Posted by localzuk View Post
    The key question here is - why do you want to use SQL2008 R2 when Capita say not to?
    Surely you should use the tools that Capita state are the right ones?
    I agree. Only reason I can think of is if your trying to save money buy SQL 2008 standard (and your database is over 4GB).

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 9
    Last Post: 29th September 2010, 08:47 AM
  2. [SIMS] Summer Release and SQL 2008 Upgrade
    By enjay in forum MIS Systems
    Replies: 12
    Last Post: 17th August 2010, 12:23 PM
  3. SQL 2008 upgrade
    By theaksy in forum MIS Systems
    Replies: 1
    Last Post: 8th August 2010, 03:23 AM
  4. New SIMS Server - Windows 2008 R2 & SQL 2008 R2
    By MYK-IT in forum MIS Systems
    Replies: 23
    Last Post: 17th June 2010, 09:31 AM
  5. FMS SQL 2008 Upgrade
    By rh91uk in forum MIS Systems
    Replies: 2
    Last Post: 17th April 2010, 08:40 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
  •