February 19, 2009 at 7:53 am
Situation: We have two databases (test & production)
Every couple of days we take the new backup of production and restore it to test to update the test environment.
After doing this we have to delete the SQL authenicated users and recreate them, map them to the correct DB, etc.
Is there a method of restoring or copying the production database to the test environment without having to deal with creating users?
February 19, 2009 at 8:11 am
Have a look at the following from Chris Burrows Blog...
It's not so much how to back it up withhout the users, but a script to run to fix your orphaned users once your restore the backup.
Perhaps you could work this into a script that will work in your environment and streamline your restores..
http://madtechnology.spaces.live.com/blog/cns!F637E4FD356E127D!127.entry
-Luke.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply