+ 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
    534
    Thank Post
    104
    Thanked 23 Times in 21 Posts
    Rep Power
    17

    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
    8,941
    Thank Post
    232
    Thanked 1,512 Times in 1,206 Posts
    Rep Power
    328
    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,144
    Thank Post
    354
    Thanked 580 Times in 476 Posts
    Rep Power
    142
    Am I correct in thinking that you have a guide or such for SIMS?

  4. #4

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,161
    Thank Post
    95
    Thanked 318 Times in 260 Posts
    Blog Entries
    4
    Rep Power
    111
    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,582
    Thank Post
    107
    Thanked 761 Times in 592 Posts
    Rep Power
    180
    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,144
    Thank Post
    354
    Thanked 580 Times in 476 Posts
    Rep Power
    142
    ... 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,855
    Thank Post
    1,162
    Thanked 1,028 Times in 729 Posts
    Rep Power
    323
    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,144
    Thank Post
    354
    Thanked 580 Times in 476 Posts
    Rep Power
    142
    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
    54
    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
    12
    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,161
    Thank Post
    95
    Thanked 318 Times in 260 Posts
    Blog Entries
    4
    Rep Power
    111
    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,144
    Thank Post
    354
    Thanked 580 Times in 476 Posts
    Rep Power
    142
    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
    54
    @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,855
    Thank Post
    412
    Thanked 777 Times in 650 Posts
    Rep Power
    181
    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,144
    Thank Post
    354
    Thanked 580 Times in 476 Posts
    Rep Power
    142
    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
  •