Tuesday, February 26, 2013 5:59 PM
I'm in the process of moving two existing databases to a brand new SQL Server 2008 R2 server. The existing databases are on separate servers today (2008 R2 as well). I need to take a backup of both databases and restore them to the new SQL Server instance. My question is - how can I restore all users and roles for both databases? I am using SQL Server Authentication for my logins. How can I retain all existing users, logins, roles, and object permission during the restore process? Will security and permissions be restored from a backup?
Tuesday, February 26, 2013 6:19 PMModerator
Please use the following articles to transfer logins from the old instance to the new one:
Hope this helps.
Tuesday, February 26, 2013 6:42 PM
Please follow the Albert instructions, so let me tel few information-
Once you restored the database,the same data will exists on the destination side as well,but the logins will not create on the destination instead of Database users will be creates , so in order to map login you need to script out the logins & SIDs then execute the rev logins scripts(please check Alert KB).
Ensure you have the proper permission to restore.
SQL Script to generate script for existing database permissions
Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.