+ 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
    516
    Thank Post
    89
    Thanked 29 Times in 27 Posts
    Rep Power
    15

    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,063
    Thank Post
    391
    Thanked 301 Times in 255 Posts
    Rep Power
    150
    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,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    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
  •