Hello

I have previously asked same question as following link

Question Link

According to that discussion we can not create role with Same SID. 

But my doubt is If I take backup of database from one server then use this backup to restore database on another server then SID will be same, If I create the database then overwrite this database while restoring.

process is I have first created some database on my local pc with diff name (blank database), Then I have created backup from server database. Then restore this backup on my local machine on my previously created blank database by changing its log file & also selecting overwrite option. & I check SID was same for role. How this is happening.

I want to know that if it is not possible to create Role with same SID then how sql manages it.

If SQL can manage this then we can do using SMO.

I know that in sql query we can not pass SID as parameter by my previous question. Just want to know is it possible or not.

I want to know that How to create role with same SID on different server?

Can you please give me proper clear guidance for it?

Regards

Vipul Langalia

 

• Edited by Vipul Langalia 3 hours 58 minutes ago

When you restore a backup users in that backup become orphan. This is because log ins are not available on that server and SID is different.

Users will have same roles when you restore the backup.

I want to know that How to create role with same SID on different server?

First find the SID of a user.

Create the user with the same SID on the different server.