• Restoring a database from a backup restores everything in the database, including users and permissions.

    If you need to copy only permissions, you'll have to script them. There are several scripts available in the script section of this site, although a lot of them script the permissions for all databases rather than only one. Try searching for "script permissions" in the Search box above.

    Greg