August 18, 2011 at 8:09 am
Hi !
I am planning to move a database from one instance to multiple instances using the SSIS ,So i would like to take care of the Security(Extract the security first before replacing database and apply the security that was extracted after copying the database,fix the orphan users) also in respective environments.So can some one shade some light on doing this so ??? Thanks in advance 🙂
August 21, 2011 at 4:36 pm
RamSteve (8/18/2011)
Hi !I am planning to move a database from one instance to multiple instances using the SSIS ,So i would like to take care of the Security(Extract the security first before replacing database and apply the security that was extracted after copying the database,fix the orphan users) also in respective environments.So can some one shade some light on doing this so ??? Thanks in advance 🙂
I have done this before.
You want to make sure that you have the logins on the destination servers. If any Logins do not exist on the destination server you need to write a script and include it in a task to do so.
You copy the backup file.
You kill any SPIDS in the Database that you are attempting to restore.
You run a script to fix the orphan users.
Then you restore the Database.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply