Martin Schoombee (9/12/2016)
I believe the restore GUI also has an option asking if you'd like to restore roles/permissions, so you can choose not to restore those when performing the restore of the backup. You may need to verify...it's been a while since I've done this via the GUI.
There's indeed an option in the GUI for this. You can choose to replace existing security options, or to keep the original ones.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP