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 :confused: 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