January 11, 2011 at 1:07 pm
I'm trying to copy objects and data using the PS Transfer object.
I keep getting an error on sp_grantdbacces to a user-group which already exists in the destination. I don't want to transfer users/groups at all. Just the DB roles.
I have the following settings:
$xfr.CopyAllRoles = $true
$xfr.CopyAllLogins = $false
$xfr.CopyAllUsers = $false
Why am I getting this error?
Thanks!
January 17, 2011 at 9:23 am
Solved: had to set CopyAllObjects = $false, and enumerate each of the object categories and set them to $true.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy