+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Copying SIMS to a test server in Technical; Hi fellow edugeeks I'm trying to set up a brand new server with SIMS. Initally this is just for testing ...
  1. #1

    Join Date
    Nov 2007
    Location
    Suffolk
    Posts
    15
    Thank Post
    7
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Question Copying SIMS to a test server

    Hi fellow edugeeks

    I'm trying to set up a brand new server with SIMS. Initally this is just for testing the process alongside our current SIMS server, but will eventually replace the old server. I've seen a few threads on here with details of using DBAttach to detach the SQL database, copy the SQL files to the new server then re-attach.

    However, if possible I'd like to use the .bak file created as part of our nightly backup to restore the DB on the new server. I can do this using dbattach with the /restoreui switch but it doesn't copy the user logins. Detaching, then reattaching the DB doesn't help Has anyone successfully copied an entire SIMS DB, including logins? If so how did you do it? Is a db detach/reattach the only way?

    The reason I want to use the .bak file is it doesn't affect the current system

    Cheers

  2. #2
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    936
    Thank Post
    35
    Thanked 164 Times in 132 Posts
    Rep Power
    94
    the .bak file not copy the passwords as they are now stored in the master of the SQL server.

    There is a routine you can, and should run which will copy the passwords.

    The other way is to create a backup using dbattach of the database and then extract the .bak file from within the zip file and dbattach using the /restoreui switch

  3. #3

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,915
    Thank Post
    1,189
    Thanked 1,063 Times in 754 Posts
    Rep Power
    329

  4. #4

    Join Date
    Nov 2007
    Location
    Suffolk
    Posts
    15
    Thank Post
    7
    Thanked 1 Time in 1 Post
    Rep Power
    0
    That sounds like just the ticket.

    I actually just managed to get in working using a backup of the master.mdf file from an old backup.
    Just dropped it in the SQL data directory and we were good to go after restarting the service. Looks like tranferring the logins is the best way though.

    Cheers

  5. #5

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    22
    I'm intrigued - I regularly use dbattach with restoreUI to restore data from my main server onto a test setup and I've never had a problem with passwords, In fact when I have changed passwords on the test setup to allow me to play with other users details I find that restoring the backup sets them back to the users original password. It even works on a clean database (ie a brand new SIMS installation). I'm wondering what is different about my system

    I think I've answered my own question we use dbattach to create the backups in the first place
    Last edited by Hecate; 14th October 2009 at 02:26 PM.

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,408
    Thank Post
    368
    Thanked 639 Times in 521 Posts
    Rep Power
    158
    It's a bug, in short. If you open up the MSSQL, you'll notice the logins are within the MASTERS and also within SIMS. Sometimes they don't appear in the SIMS database. Capita's offical response is to deattach, reattach the database, basically poking it, the exec sims.db_p_transfer_login should force the MASTERS passwords to be copied to the database.

    You can also get problems if you reattach the database with another name. Also if you have trusted logins and your not attaching it to the same domain.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 16
    Last Post: 19th January 2009, 09:00 AM
  2. SIMS test environment
    By KWestos in forum MIS Systems
    Replies: 6
    Last Post: 26th June 2008, 08:34 PM
  3. Replies: 7
    Last Post: 13th March 2008, 03:52 PM
  4. Pulling copying fails - push copying works
    By SimpleSi in forum Windows
    Replies: 1
    Last Post: 3rd March 2008, 02:29 PM
  5. Copying user areas to a new Server
    By fawkers in forum Windows
    Replies: 10
    Last Post: 2nd August 2007, 10:28 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •