I'm in the process of restoring a pre-live database (containing 6 databases) with the live databases. All I need is the live data. However I'm guessing other things might be affected like like Replication, Jobs, Users, Roles and perhaps other components.
I would like to know how I would go about this process so that users, Replication and Jobs are not affected, only the data. I'm guessing the following:
- Generate a script that backs up the current users and roles (how?)
- Stop Replication and Jobs.
- Backup the pre-live databases,
- Backup Replication (generate script) and Jobs (how?) - This may not be necessary
Run the script to restore the users and roles
Restart Jobs and Replication
I read somewhere to use
EXEC sp_change_users_login 'Auto_Fix', 'someUser' to connect an orphaned user to the login.