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 ...
13th October 2009, 02:39 PM #1
- Rep Power
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
13th October 2009, 02:47 PM #2
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
13th October 2009, 03:24 PM #3
13th October 2009, 04:01 PM #4
- Rep Power
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.
14th October 2009, 03:16 PM #5
- Rep Power
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 03:26 PM.
14th October 2009, 03:29 PM #6
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.
By ANB in forum MIS Systems
Last Post: 19th January 2009, 10:00 AM
By KWestos in forum MIS Systems
Last Post: 26th June 2008, 09:34 PM
By sycho666 in forum Windows
Last Post: 13th March 2008, 04:52 PM
By SimpleSi in forum Windows
Last Post: 3rd March 2008, 03:29 PM
By fawkers in forum Windows
Last Post: 2nd August 2007, 11:28 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread