+ Post New Thread
Page 3 of 5 FirstFirst 12345 LastLast
Results 31 to 45 of 65
MIS Systems Thread, SIMS end of support XP and 2003. in Technical; Part2 Moving the database make sure all is backed up. copy documentstorage to new server and change folder names under ...
  1. #31

    Join Date
    Apr 2010
    Posts
    2,033
    Thank Post
    82
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    Part2

    Moving the database

    make sure all is backed up.

    copy documentstorage to new server and change folder names under documantstorage root to new setup names.

    create Sims folder on server
    map s drive to sims
    copy Sims folder from old server to new sims folder on server
    run Simsinst on new server
    install sims on server, choosing SQL2008 as the instance
    on old server open dbattach and login
    detach Sims database
    copy Sims MDF and LDF files found in drogramfiles\sql….data to new server
    run dbattach on new server
    attach Sims files

    change Sims.ini files to reflect new sims server
    on clients change c:/windows sims.ini to reflect new server.

    Think thats about it.
    Last edited by edutech4schools; 22nd July 2013 at 10:57 AM.

  2. Thanks to edutech4schools from:

    Koldov (22nd July 2013)

  3. #32
    Koldov's Avatar
    Join Date
    May 2011
    Location
    Bedfordshire
    Posts
    505
    Thank Post
    101
    Thanked 50 Times in 46 Posts
    Rep Power
    39
    Thanks so much for this! I know this is a big ask, but have you ever done FMS and it is the same procedure?

    Kol.

  4. #33

    Join Date
    Apr 2010
    Posts
    2,033
    Thank Post
    82
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    FMS is almost the same but easier as you do not need to worry about documentstorage folder.

    post back if you have any issues.

  5. #34

    Join Date
    Apr 2010
    Posts
    2,033
    Thank Post
    82
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    UPDATE: The above SQL install info is based on the full SQL software and not the express version.

  6. #35
    Koldov's Avatar
    Join Date
    May 2011
    Location
    Bedfordshire
    Posts
    505
    Thank Post
    101
    Thanked 50 Times in 46 Posts
    Rep Power
    39
    Quote Originally Posted by edutech4schools View Post
    UPDATE: The above SQL install info is based on the full SQL software and not the express version.
    Cool. We are on an EES agreement (including SQL server) do you know which SQL package I should download from the MVLS site to put on a plain 2008 server?

    Kol.

  7. #36
    Koldov's Avatar
    Join Date
    May 2011
    Location
    Bedfordshire
    Posts
    505
    Thank Post
    101
    Thanked 50 Times in 46 Posts
    Rep Power
    39
    Also this....

    "We have also reviewed our support for SOLUS 2 and have extended use of SOLUS 2 for SIMS deployment until Autumn 2013. The last SOLUS 2 compatible SIMS release will now be Summer 2013."

    I'm guessing SOLUS 3 is just a download from somewhere?

    Kol.
    Last edited by Koldov; 22nd July 2013 at 01:20 PM.

  8. #37

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,620
    Thank Post
    845
    Thanked 882 Times in 731 Posts
    Blog Entries
    9
    Rep Power
    326
    Quote Originally Posted by Koldov View Post
    "The last SOLUS 2 compatible SIMS release will now be Summer 2013."
    Crap, there goes my Christmas

  9. #38

    Join Date
    Jul 2011
    Location
    York
    Posts
    7
    Thank Post
    4
    Thanked 3 Times in 2 Posts
    Rep Power
    0
    Quote Originally Posted by Koldov View Post
    Also this....

    "The last SOLUS 2 compatible SIMS release will now be Summer 2013."
    Don't think so

    Quote Originally Posted by SIMS Technical Roadmap
    SOLUS2 support has been extended 2 releases to include Spring 2014.
    SupportNet Resource id: 17910

  10. Thanks to memo512 from:

    tmcd35 (23rd July 2013)

  11. #39
    Koldov's Avatar
    Join Date
    May 2011
    Location
    Bedfordshire
    Posts
    505
    Thank Post
    101
    Thanked 50 Times in 46 Posts
    Rep Power
    39
    Quote Originally Posted by memo512 View Post
    Don't think so



    SupportNet Resource id: 17910
    Hmmmmmm.... Well I'm not signed up to the Capita Support Net, I got mine from here:

    http://www.capitaess.co.uk/home/SIMS...rceNo17910.pdf

    Not sure why it's different, annoying though.

    Kol.

  12. #40
    Koldov's Avatar
    Join Date
    May 2011
    Location
    Bedfordshire
    Posts
    505
    Thank Post
    101
    Thanked 50 Times in 46 Posts
    Rep Power
    39
    Just got a warning about installing SQL Server 2008R2 on a Domain Controller...

    Does anybody run this config and are there really any issues?

    Kol.

  13. #41
    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,483
    Thank Post
    37
    Thanked 490 Times in 422 Posts
    Rep Power
    110
    We run SQL Server 2008R2 on a 2008R2 DC, and we have no issues

  14. Thanks to nickbro from:

    Koldov (29th July 2013)

  15. #42

    Join Date
    Apr 2010
    Posts
    2,033
    Thank Post
    82
    Thanked 187 Times in 154 Posts
    Rep Power
    83
    yep, all the schools in my county run sql on the domain server.

  16. Thanks to edutech4schools from:

    Koldov (29th July 2013)

  17. #43

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Most primary schools do, it's just a warning - basically it's not Microsoft best practice, still it's rare you can meet all the best practices. I think it's due to the DC having more rights, so SQL would have more rights then on a member server. The other issue would is performance - kinda like running Exchange and MSSQL together but no where near as bad. Ironically, Microsoft will happily sell your Windows Server Small Business that gives you Exchange, MSSQL, DC and a butt load of other roles all on one box - I think it needs 12GB ram or something stupid however

  18. #44
    Koldov's Avatar
    Join Date
    May 2011
    Location
    Bedfordshire
    Posts
    505
    Thank Post
    101
    Thanked 50 Times in 46 Posts
    Rep Power
    39
    Quote Originally Posted by edutech4schools View Post
    Part2

    Moving the database

    make sure all is backed up.

    copy documentstorage to new server and change folder names under documantstorage root to new setup names.
    create Sims folder on server
    map s drive to sims
    copy Sims folder from old server to new sims folder on server
    run Simsinst on new server
    install sims on server, choosing SQL2008 as the instance
    on old server open dbattach and login
    detach Sims database
    copy Sims MDF and LDF files found in drogramfiles\sql….data to new server
    run dbattach on new server
    attach Sims files

    change Sims.ini files to reflect new sims server
    on clients change c:/windows sims.ini to reflect new server.

    Think thats about it.
    I know these are probably really dumb questions, but I don't want to muck this up!

    Could you elaborate on the bits in blue:

    1) and change folder names under documentstorage root to new setup names.

    Where do I do this?

    2) copy Sims folder from old server to new sims folder on server

    Do I have to do the whole folder (S:\ drive) for historical purposes? As this SIMS server has been running for years and has so much cr*p in it from installs and updates and I would have liked a clean fresh folder structure. There are SIMS folders, inside SIMS folders, inside SIMS$ folders and it's really messy.

    3) install sims on server,

    This will kill you I know, but I am choosing SIMS SERVER in the setup options right? It's just that some work I had to do recently on data collection for the LEA required me to log in on the server as a client...

    4) change Sims.ini files to reflect new sims server

    This is the Sims.ini in the Sims folder on the server?

    Then just run FMS setup, detach on old server, copy across FMS database MDF and LDF files found in d:\programfiles\sql….data to new server?

    Thanks in advance.

    Kol.
    Last edited by Koldov; 29th July 2013 at 03:40 PM.

  19. #45
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 489 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by Koldov View Post
    I know these are probably really dumb questions, but I don't want to muck this up!

    Could you elaborate on the bits in blue:

    1) and change folder names under documentstorage root to new setup names.

    Where do I do this?
    On the old server, the doc storage would be stored somewhere like C:\DOCSTORAGE\<OLDSERVERNAME>\SIMS2008\SIMS

    Once copied to the new server, the <OLDSERVERNAME> needs changing to the new server name.

    2) copy Sims folder from old server to new sims folder on server

    Do I have to do the whole folder (S:\ drive) for historical purposes? As this SIMS server has been running for years and has so much cr*p in it from installs and updates and I would have liked a clean fresh folder structure. There are SIMS folders, inside SIMS folders, inside SIMS$ folders and it's really messy.
    Unless you know exactly whats current and are happy to sort it out, I would copy the complete folder. Better to be safe than sorry.

    3) install sims on server,

    This will kill you I know, but I am choosing SIMS SERVER in the setup options right? It's just that some work I had to do recently on data collection for the LEA required me to log in on the server as a client...
    Yes, run SIMSINST.EXE from the setups option and choose "This device will be a SIMS server.

    4) change Sims.ini files to reflect new sims server

    This is the Sims.ini in the Sims folder on the server?

    Then just run FMS setup, detach on old server, copy across FMS database MDF and LDF files found in drogramfiles\sql.data to new server?

    Thanks in advance.

    Kol.
    The SIMS.INI is in the Windows directory on every SIMS/FMS workstation. If the entry in the SIMS.INI file for the Setups folder location points to the old servers UAC path (\\<SERVERNAME>\SIMSAREA$\SIMS\SETUPS) rather than the mapped drive (S:\SIMS\SETUPS), you'll need to update this on every workstation.

    FMS is almost the same. Detach the DB, copy across, attach to the new SQL instance on the new server, install the FMS client on the server and test. If you point FMS directly to the server than a redirect, you will need to manually update the FMSConnect.ini files on all of your FMS workstations.

  20. Thanks to Rawns from:

    Koldov (29th July 2013)

SHARE:
+ Post New Thread
Page 3 of 5 FirstFirst 12345 LastLast

Similar Threads

  1. Replies: 18
    Last Post: 16th April 2012, 06:25 PM
  2. Pearson Phoenix Gold - end of support
    By nomad in forum MIS Systems
    Replies: 1
    Last Post: 8th October 2008, 02:06 PM
  3. Printer Spooler Failing on XP and 2003
    By BKGarry in forum Windows
    Replies: 8
    Last Post: 7th September 2007, 07:20 AM
  4. Replies: 16
    Last Post: 14th June 2007, 10:07 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
  •