+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 27
MIS Systems Thread, SIMS - SQL2005 > SQL2008 Migration Problem in Technical; I'm doing a dummy run of migrating our current SIMS server (setup by Capita) to a new 2008 SQL virtual ...
  1. #1
    RobFuller's Avatar
    Join Date
    Feb 2007
    Location
    Chelmsford
    Posts
    313
    Thank Post
    83
    Thanked 39 Times in 29 Posts
    Rep Power
    22

    SIMS - SQL2005 > SQL2008 Migration Problem

    I'm doing a dummy run of migrating our current SIMS server (setup by Capita) to a new 2008 SQL virtual server.

    Right I have all the new systems setup exactly how I want it so time now to migrate the database, this is where the fun begins.
    Trying to use the SIMS SQL2008 Migration tool but I'm facing an error which Capita basically won't help me with unless I pay them lots of money....don't we already? Anyway the error I'm receiving when using the GUI version trying to save the updated database to a file so I can migrate it to the new server.

    "SQL Binn folder is missing or inaccessible - Please seek advice"

    "Unable to get registry keys for SQLBinRoot or SQLData from registry - Please seek advice"

    (the please seek advice bit should be replaced with pay Capita lots of money)

    Anyway Capita wont help me with this, do any of you guys know where I might locate the registry keys it missing, I've had a good poke about but can't see anything. I then tried using there command line tool which seem better, in the fact I could establish a direct connection to the new server but I then get the following error about moving the database:

    ----------------------------------------------------------------
    18/03/2010 10:24:49 Info Migration Started on SERVER01 by admin1
    18/03/2010 10:24:49 Info Command Line Parameters --Silent --Advanced --sInstance Server01\SIMS2005 --sSQLUser SA --sSQLPwd ********** --sDatabase SIMS --dInstance SQL01\SQL01 --dSQLUser MD --dSQLPwd ********** --dDatabase SIMS --DMSPath E:\DocStorage
    -----------------STEPS---------------------------
    Detach SIMS Database Server01\SIMS2005 | sims
    Copy Database Files From to
    Attach SIMS Database SQL01\SQL01 | SIMS
    Install SIMS Server Applications
    Configure SIMS Database
    Move SIMS Scheduled Tasks Server01\SIMS2005 | sims
    Set Recovery Model
    -----------------STEPS---------------------------
    18/03/2010 10:24:51 Info START: Detach SIMS Database
    18/03/2010 10:24:51 Info SUCCEED: Detach SIMS Database
    18/03/2010 10:24:51 Info START: Copy Database Files
    18/03/2010 10:24:51 ***STOP*** FAIL: Copy Database Files
    18/03/2010 10:24:51 Info START: RollBack System
    18/03/2010 10:24:54 Info SUCCEED: RollBack System
    18/03/2010 10:24:54 Info Migration Finished
    -----------------------------------------------

    I wonder if the same registry key is missing so it can't find the SQLData folder to move the files!

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Your not trying to copy it the database across the network to another server?!?

  3. #3
    RobFuller's Avatar
    Join Date
    Feb 2007
    Location
    Chelmsford
    Posts
    313
    Thank Post
    83
    Thanked 39 Times in 29 Posts
    Rep Power
    22
    This is the next plan, setup another server move 'SIMS' to that then run the migraton to SQL2008 on that server.

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Basically the error is because your moving the database from Server01 to SQL01. You can't do it.

    It isn't Capita, it's Microsoft. SQL stuff has to be on local disc.

    Either migrate SQL on the same server, or deattach the database, copy it to the new server, install SIMS, run the SQL2008 migration, tick the advance button, and select the mdf.

    I think Capita are a bit worried about you doing it on your own which is why they keep saying, call us out etc. I mean they recommend a named instance of SIMS2008, you've got SQL01. A pretty school boy error (no offence meant).

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,636
    Thank Post
    683
    Thanked 1,399 Times in 1,159 Posts
    Rep Power
    353
    surely you can name the instance what you like...?
    i'd prefer sql2008, and then name the database sims2008.
    i'm fed up of the confusion of the instance and db name being the same, even Capita guys i've spoken to said the same.

    i've not played with the migration yet, but are you saying that there's no way to do a clean setup with sql 2008? so, it has to be a migration from 2005-2008? i hate having old remnants.

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    The idea of using the default is from the support aspect. You may know that sql1 is for sims, but what happens if you aren't in, or god for bid, you get ran over by a bus. Anyway the database should be called sims, the sql instance should have purpose and version. I can't see any reason why you shouldn't use sims2008 as the named instance.

    You can indeed setup a new server, you just have to copy the files like you normally would. Don't try and use the sql migration tool to transfer the data.

  7. #7
    fawkers's Avatar
    Join Date
    Jun 2007
    Location
    Southend
    Posts
    193
    Thank Post
    32
    Thanked 22 Times in 21 Posts
    Blog Entries
    2
    Rep Power
    31
    just to thow a spanner in the works, i've had this error when tring to export by database to a flat file using the advanced options box.

    <rant>
    A why oh why wont SIMS support a tool that they provided!
    </rant>

  8. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    What??

    If your trying to do a clean install. Ask for the latest installable media, install it onto the new server. Then deattach the database(s) from the old server, copy them to the local drive of the new server, run the SQL migration tool on the new server, select the advanced option, select the deattached mdf(s).

  9. #9
    RobFuller's Avatar
    Join Date
    Feb 2007
    Location
    Chelmsford
    Posts
    313
    Thank Post
    83
    Thanked 39 Times in 29 Posts
    Rep Power
    22
    I agree with fawkers here as the instant name should only really be needed to separate the services, registry etc but anyway I have changed this to SIMS2008 in the hope that helps.

    So I then tried the way you suggested by detaching the original database, moving to the new server and then running the migration tool. All looked good until I reached this message next hurdle.

    The server is SQL01\SIMS2008 (Win 2008 x64) tried R2 and non R2 just to confirm. Configured XP_CMDShell and enabled name pipes. 100% running as Admin (UAC disabled).

    Attached Images Attached Images

  10. #10

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    When you run the sql2008 migration tool, r-click and select "Run as Administrator" see if that makes any difference.



    UPDATE:
    Found this:
    RegCreateKeyEx - Vista Forums

    Looks like a Microsoft security thing....

    Also been asked, is the service running a local service or a network service? It should be a local service.
    Last edited by matt40k; 22nd March 2010 at 01:11 PM.

  11. Thanks to matt40k from:

    benIT (17th January 2011)

  12. #11
    RobFuller's Avatar
    Join Date
    Feb 2007
    Location
    Chelmsford
    Posts
    313
    Thank Post
    83
    Thanked 39 Times in 29 Posts
    Rep Power
    22
    Hi Matt,

    That problem was caused by my services running under a domain account, switched to local service solved that problem thanks!!

    I think I'm at the last hurdle now however it’s now not accepting the backup location. If I leave it default or even set it to something simple like D:\backup (folder exists) nothing. Commanded or via the GUI. I'm really not worried about setting that location now I can do it later but it just will not accept it!

    Attached Images Attached Images

  13. #12
    RobFuller's Avatar
    Join Date
    Feb 2007
    Location
    Chelmsford
    Posts
    313
    Thank Post
    83
    Thanked 39 Times in 29 Posts
    Rep Power
    22
    To be fair they are a company that needs to make 'more' money but yes I do feel your frustration.

    Quote Originally Posted by fawkers View Post
    just to thow a spanner in the works, i've had this error when tring to export by database to a flat file using the advanced options box.

    <rant>
    A why oh why wont SIMS support a tool that they provided!
    </rant>

  14. #13
    fawkers's Avatar
    Join Date
    Jun 2007
    Location
    Southend
    Posts
    193
    Thank Post
    32
    Thanked 22 Times in 21 Posts
    Blog Entries
    2
    Rep Power
    31
    I know they need to make money but how many £1000's does each school spend each year with them?

    As an update on what were doing about this problem, it's now Capitas problem, the NM decided that we shouldn't take the risk of playing around with SIMS\FMS when it could all go so horibly wrong. (i'm 99.9% sure we wouldn't screw up but oh well, not my call).

    Just so you fokes know they are charging £350 +VAT to move your system + up to 8 workstations if you book before the end of the month (March 2010).

  15. #14
    RobFuller's Avatar
    Join Date
    Feb 2007
    Location
    Chelmsford
    Posts
    313
    Thank Post
    83
    Thanked 39 Times in 29 Posts
    Rep Power
    22
    £350 isn't bad and thatís including FMS as well. Is that one the same server I presume?

  16. #15
    fawkers's Avatar
    Join Date
    Jun 2007
    Location
    Southend
    Posts
    193
    Thank Post
    32
    Thanked 22 Times in 21 Posts
    Blog Entries
    2
    Rep Power
    31
    Yep that is on the same server, but i dont see why they would charge extra to move it to a different one.

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

Similar Threads

  1. Guide on installing Full SQL2005 and SIMS
    By mrforgetful in forum MIS Systems
    Replies: 1
    Last Post: 12th August 2009, 02:38 PM
  2. Help Please june Update + sql2008
    By woodham in forum MIS Systems
    Replies: 7
    Last Post: 6th July 2009, 03:26 PM
  3. SIMS and SQL2005 on a 64bit OS
    By timbo343 in forum Windows
    Replies: 2
    Last Post: 8th May 2008, 08:52 AM
  4. SIMS Migration help
    By randle in forum MIS Systems
    Replies: 17
    Last Post: 10th November 2007, 12:00 PM
  5. Replies: 7
    Last Post: 26th October 2007, 06:21 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
  •