+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, Moving SIMS to a new server in Technical; I want to move our SIMS to a new server as the old server is so old and slow. Also ...
  1. #1

    Join Date
    May 2007
    Location
    North Yorkshire
    Posts
    11
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Moving SIMS to a new server

    I want to move our SIMS to a new server as the old server is so old and slow. Also will be replacing my SIMS workstations, so basically, starting from scratch. Can anyone advise how this is done, in particular the SQL side. I don't want to pay the extreme fees of my LEA if I can do it myself - fairly computer literate. Many thanks.

  2. #2

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    Boston, MA
    Posts
    7,601
    Thank Post
    110
    Thanked 771 Times in 599 Posts
    Rep Power
    183

    Re: Moving SIMS to a new server

    The SIMS and SQL part of the install are like a new installation. You then use the DBATTACH tool to reconnect the database once you have restored it from a backup. I think that Capita (or your local support team) can give you instructions.

  3. #3
    nicholab's Avatar
    Join Date
    Nov 2006
    Location
    Birmingham
    Posts
    1,569
    Thank Post
    4
    Thanked 101 Times in 97 Posts
    Blog Entries
    1
    Rep Power
    53

    Re: Moving SIMS to a new server

    Will this work if you migrate from MS SQL 2000 to 2005 at the same time?

  4. #4
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    4,002
    Thank Post
    983
    Thanked 477 Times in 398 Posts
    Blog Entries
    12
    Rep Power
    98

    Re: Moving SIMS to a new server

    Its a very easy process, you just need to copy the sql data file to the new server and then use dbattach.



SHARE:
+ Post New Thread

Similar Threads

  1. Moving Sophos to a new server
    By sidewinder in forum Windows
    Replies: 18
    Last Post: 12th October 2010, 11:43 AM
  2. Moving to a new server?
    By sidewinder in forum ICT KS3 SATS Tests
    Replies: 10
    Last Post: 27th February 2009, 02:20 PM
  3. Moving RIS images to new Server
    By Kyle in forum Windows
    Replies: 4
    Last Post: 11th October 2007, 01:18 PM
  4. Moving the SIMS G/S Drive - easy?
    By sidewinder in forum MIS Systems
    Replies: 7
    Last Post: 5th March 2007, 10:10 PM
  5. Moving RIS from 1 server to another
    By Zoom7000 in forum Windows
    Replies: 15
    Last Post: 10th February 2007, 01:25 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
  •