question

SahaSaha-5270 avatar image
0 Votes"
SahaSaha-5270 asked ·

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

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

service-fabric-standalone
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Sirlupinwatson avatar image
0 Votes"
Sirlupinwatson answered ·

Hi @SahaSaha-5270

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.



·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image
1 Vote"
VaibhavChaudhari answered ·

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.

https://docs.microsoft.com/en-us/sql/relational-databases/databases/use-the-copy-database-wizard?view=sql-server-ver15


You may also raise this question in MSDN SQL server forum here - https://social.msdn.microsoft.com/Forums/en-US/newthread?category=undefined&forum=sqldatabaseengine


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.