Does the permission get copied when copy database from one server to another

Avyayah 1,146 Reputation points

Does the Copy Database Wizard copy permission when copy database from one server to another.

Azure Service Fabric
Azure Service Fabric
An Azure service that is used to develop microservices and orchestrate containers on Windows and Linux.
206 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Vaibhav Chaudhari 37,886 Reputation points

    The document below says - Logins are also copied to target server and also Limitation and restriction doesn't point out that we need to set up the permissions again on target DB.

    You may also raise this question in MSDN SQL server forum here -

    1 person found this answer helpful.
    No comments

  2. Armand Brunelle 491 Reputation points

    Hi @Avyayah

    Can you be more specific please ?

    What are you doing , on what platform, which system and version are you using ?

    Normally from a copy and paste, it should copy everything you did copy from the main folder or .txt file.

    Permission and access identification should remain the same.

    Once your migration is complete, you can run the command : dsregcmd /status in Powershell


    Please ''Accept as Answer'' wherever the information provided helps you to help others in the community.