+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 21
MIS Systems Thread, Movng FMS over to a new server in Technical; Hi Guys we are thinking of moving our Sims server over to a new domain. Does any know of any ...
  1. #1
    ful56_uk's Avatar
    Join Date
    Mar 2008
    Location
    Essex
    Posts
    569
    Thank Post
    106
    Thanked 25 Times in 22 Posts
    Rep Power
    19

    Movng FMS over to a new server

    Hi Guys

    we are thinking of moving our Sims server over to a new domain. Does any know of any documents that tell you how to move the fms infrastructure over to a new server/domain.


    Thanks

    Mark

  2. #2

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,266
    Thank Post
    242
    Thanked 1,575 Times in 1,254 Posts
    Rep Power
    341
    Essentially there's two parts - firstly the Sims share itself, which you should be able to move to a different server, but the more complex part is moving the database. Of course you'd need to re-install SQL 2005, but then the rest I am not sure of the exact procedure.

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,450
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Am I correct in thinking that you have a guide or such for SIMS?

  4. #4

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,217
    Thank Post
    116
    Thanked 332 Times in 274 Posts
    Blog Entries
    4
    Rep Power
    115
    You should be able to detach the database from where it currently sits, or even just run a backup, then install SIMS afresh on the new domain, choosing to attach an existing database rather than create a new one. Attach your database through dbattach (or restore it, depending on which option you chose) and job done.

  5. #5

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 770 Times in 598 Posts
    Rep Power
    183
    It's dead easy. Follow the following steps:
    • Use dbattach to backup the SIMS and FMS databases (there's a different version of dbattach for each)
    • Install SIMS server software onto new server (SIMSINST - select 'server' as the option)
    • Copy shared folders from old server to new
    • Copy DOCSTORAGE folder from old server to new (this is for the Document Server)
    • Use the two dbattach jobbies to re-attach your backups
    • Re-install clients to point to new server (unless it has the same name)


    IIRC SupportNet has full instructions too.

  6. Thanks to Ric_ from:

    ful56_uk (8th April 2009)

  7. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,450
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    ... and then get shot by your LEA as you haven't reset your B2B schedule.

  8. #7

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,967
    Thank Post
    1,212
    Thanked 1,075 Times in 766 Posts
    Rep Power
    332
    I have just been informed by our LA that the school should factor in our budget the cost of moving to SQL server 2008.
    Apparently this is to do with new reporting tools and the replacement of Nova-T4 reporting.

  9. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,450
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    The whole of SIMS\FMS is moving over to SQL 2008 soon. I think later this year.

  10. #9
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    The base release of Reporting Services 2008 and replacement for NT4 Reporting, both using SQL 2008, are due for release in March 2010.

  11. #10

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    13
    choosing to attach an existing database rather than create a new one.
    What would be the default user/password for the blank database?

  12. #11

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,217
    Thank Post
    116
    Thanked 332 Times in 274 Posts
    Blog Entries
    4
    Rep Power
    115
    Quote Originally Posted by Steve_T View Post
    What would be the default user/password for the blank database?
    Whatever password you set for the SQL Instance when you installed it should work.

  13. #12

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,450
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    SIMS
    sysman \ [REMOVED]

    FMS
    sysman \ [REMOVED]
    Last edited by matt40k; 9th April 2009 at 09:51 AM.

  14. #13

    Join Date
    Jun 2007
    Location
    London
    Posts
    894
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    55
    @matt40k

    Maybe not a good idea to paste any SIMS passwords on this forum since:
    a. pupils read it
    b. some people never change the default passwords

    Any chance you could edit your post and remove them? Thanks.

  15. #14

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,866
    Thank Post
    412
    Thanked 777 Times in 650 Posts
    Rep Power
    182
    Quote Originally Posted by timzim View Post
    a. pupils read it
    They're not exactly a secret, nor are they particularly difficult to guess... I'd be scared if 'password' wasn't the first try by a kid.

    b. some people never change the default passwords
    Such people deserve to be rudely awoken from their complacency.

  16. Thanks to powdarrmonkey from:

    matt40k (9th April 2009)

  17. #15

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,450
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Quote Originally Posted by timzim View Post
    @matt40k

    Maybe not a good idea to paste any SIMS passwords on this forum since:
    a. pupils read it
    b. some people never change the default passwords

    Any chance you could edit your post and remove them? Thanks.
    1/ Done
    2/ a. And? Pupils should be able to get onto a SIMS\FMS machine
    3/ b. Then they should read the Capita document with regards to setup SIMS\FMS again and review there policies. It clearly states YOU MUST CHANGE THE PASSWORD.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. FMS installable \ FMS installer
    By matt40k in forum MIS Systems
    Replies: 0
    Last Post: 5th March 2009, 01:01 PM
  2. Terminal Server, SIMS.net and FMS
    By localzuk in forum MIS Systems
    Replies: 6
    Last Post: 20th November 2008, 04:13 PM
  3. Moving SIMS\FMS to a new server
    By matt40k in forum MIS Systems
    Replies: 2
    Last Post: 22nd August 2008, 07:58 PM
  4. FMS
    By edie209 in forum MIS Systems
    Replies: 19
    Last Post: 7th October 2007, 06:58 PM
  5. FMS
    By StewartKnight in forum MIS Systems
    Replies: 19
    Last Post: 3rd May 2006, 09:35 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
  •