+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Moving SQL Database in Technical; I've not done this before! I have a new SQL server set up. Is there a guide or list of ...
  1. #1
    Sam_Brown's Avatar
    Join Date
    Sep 2009
    Location
    Northampton
    Posts
    594
    Thank Post
    100
    Thanked 42 Times in 40 Posts
    Rep Power
    19

    Moving SQL Database

    I've not done this before!

    I have a new SQL server set up. Is there a guide or list of best practices to follow for doing this at all? Even better a SIMs Guide for doing so would be great.

    Any suggestions?

  2. #2

    fiza's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    2,229
    Thank Post
    447
    Thanked 319 Times in 270 Posts
    Rep Power
    153
    Supportnet is your friend for this.
    When I did it I just contacted Capita and they sent me a straight forward guide on how to do it.(was at my last school so dont have it now).
    Wasnt difficult at all.

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,788
    Thank Post
    716
    Thanked 1,441 Times in 1,194 Posts
    Rep Power
    360
    It's explained in a few threads here. Get teh installable ISO, run it.
    run any update ISOs since the installable version so the new server is on the same version as the live server.
    take a backup of old server. (.bak file)
    use dbattach to restore to new server.
    open up firewall ports, set up mappings, copy over doc store and tell sims where it is.
    repoint connect.ini
    update sims.ini
    test
    test
    test
    test
    test

SHARE:
+ Post New Thread

Similar Threads

  1. Moving an SQL Database from Windows 2003 - 2008
    By penfold in forum Windows Server 2008 R2
    Replies: 1
    Last Post: 30th May 2012, 12:53 PM
  2. moved sims sql database but logins not moved
    By Jamie_a in forum MIS Systems
    Replies: 3
    Last Post: 13th November 2010, 10:06 AM
  3. move sims sql database to new partition
    By marekbrad in forum MIS Systems
    Replies: 4
    Last Post: 6th July 2010, 07:45 PM
  4. Backing up SQL database ?
    By Kyle in forum Windows
    Replies: 4
    Last Post: 8th June 2006, 09:36 PM
  5. Replies: 2
    Last Post: 28th March 2006, 12:15 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
  •