+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, What versions of SQL is SIMS supported on? in Technical; Hi, I am just wondering what specific versions, SP and CU update is SIMS supported on please? When doing SQL ...
  1. #1

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,823
    Thank Post
    875
    Thanked 1,675 Times in 1,458 Posts
    Blog Entries
    12
    Rep Power
    444

    What versions of SQL is SIMS supported on?

    Hi,

    I am just wondering what specific versions, SP and CU update is SIMS supported on please? When doing SQL updates don't want to jump the gun by going to far.

    Thanks

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Capita says to apply all the latest windows updates, which is good, I would however recommend you avoid CU as they tend to get rolled back or updated frequently, so unless you have a specific problem, avoid. If its something important, it'll get rolled into a SP. I've yet to see a particular CU that has me rushing to install, even the security are normally blocked by a different layer of security, or the risk isn't worth it.

  3. #3
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,164
    Thank Post
    561
    Thanked 153 Times in 139 Posts
    Blog Entries
    78
    Rep Power
    80
    Only up to 2008 r2 at the mo I think, support for 2012 in Spring is that right @PhilNeal?

  4. #4

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,823
    Thank Post
    875
    Thanked 1,675 Times in 1,458 Posts
    Blog Entries
    12
    Rep Power
    444
    Yes thought that was the case. Didn't plan on going to 2012, just want to check with the SQL updates.

    I assume when updating SQL you just do it the usual way you would with any other SQL database?

    Thanks

  5. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Quote Originally Posted by TheScarfedOne View Post
    Only up to 2008 r2 at the mo I think, support for 2012 in Spring is that right @PhilNeal?
    To quote Jon Wood (who Phil would ask) - from the Autumn announcement:
    Microsoft SQL Server 2012 support has been introduced for SIMS and FMS only from the Autumn 2012 release. Customers should not migrate to SQL2012 if they have InTouch, SLG, Discover or SOLUS3. Please read the release note carefully for more details on SQL2012 support.
    @FN-GM - yer, Windows Update, do not reboot - then have a scheduled reboot out of hours (not on a Monday, Sunday, Saturday or Friday) - unless you don't mind (maybe) losing your weekend

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Ahem, The office 2010 CU from 2011 was quite a useful one, especially for generating individual reports.
    As for updates, i just do them periodically or when the server / NM complains. They don't / shouldn't affect data, you should be able to roll back an update without any issue. Or you can just switch back to an old snapshot and restore a backup.

  7. #7

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,823
    Thank Post
    875
    Thanked 1,675 Times in 1,458 Posts
    Blog Entries
    12
    Rep Power
    444
    Quote Originally Posted by matt40k View Post
    To quote Jon Wood (who Phil would ask) - from the Autumn announcement:

    @FN-GM - yer, Windows Update, do not reboot - then have a scheduled reboot out of hours (not on a Monday, Sunday, Saturday or Friday) - unless you don't mind (maybe) losing your weekend
    All done out of hours anyway

  8. #8

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,316
    Thank Post
    35
    Thanked 351 Times in 237 Posts
    Rep Power
    78
    @matt40k has revealed my source of technical information!

  9. #9

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    QUOTE=vikpaw;913248]Ahem, The office 2010 CU from 2011 was quite a useful one[/QUOTE]

    Very true, however Servers\SQL are a different beast, don't care what happens to a desktop as the worst thing that could happen is you have to rebuilt it - or get a spare out the cupboard (trys not to laugh), server goes down, then you're looking at spending the weekend in a darkend room.

  10. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by PhilNeal View Post
    @matt40k has revealed my source of technical information!
    Well he is Technical Manager!
    Quote Originally Posted by matt40k View Post
    Quote Originally Posted by vikpaw View Post
    Ahem, The office 2010 CU from 2011 was quite a useful one
    Very true, however Servers\SQL are a different beast, don't care what happens to a desktop as the worst thing that could happen is you have to rebuilt it - or get a spare out the cupboard (trys not to laugh), server goes down, then you're looking at spending the weekend in a darkend room.
    I have Office installed on the server. It's typical of a support flowchart to ask 'does it work on the server?', but i see your point.

  11. #11
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,164
    Thank Post
    561
    Thanked 153 Times in 139 Posts
    Blog Entries
    78
    Rep Power
    80
    Quote Originally Posted by vikpaw View Post
    Well he is Technical Manager!
    < -- hehehe!

    Quote Originally Posted by vikpaw View Post
    I have Office installed on the server. It's typical of a support flowchart to ask 'does it work on the server?', but i see your point.
    < -- Same for the same reason :-)

  12. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by TheScarfedOne View Post
    < -- hehehe!

    < -- Same for the same reason :-)

  13. #13
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,164
    Thank Post
    561
    Thanked 153 Times in 139 Posts
    Blog Entries
    78
    Rep Power
    80
    <-- was supposed to show on same line, but since i used the quote tag, it dropped below it. Oh well

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 7
    Last Post: 30th October 2012, 09:34 AM
  2. Pre-release version of SQL!
    By CadlaM in forum Windows Server 2008 R2
    Replies: 2
    Last Post: 25th November 2010, 01:55 PM
  3. What's in what version of 7?
    By Ric_ in forum Windows 7
    Replies: 0
    Last Post: 13th October 2009, 10:16 AM
  4. What level of functionality is required
    By speckytecky in forum EduGeek Joomla 1.5 Package
    Replies: 2
    Last Post: 3rd April 2009, 06:09 PM
  5. What version of Acrobat Reader are you using
    By mrtechsystems in forum Windows
    Replies: 22
    Last Post: 7th July 2008, 01:03 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
  •