September 14, 2009 at 2:41 pm
we have a db , 200 users are in that db.
we need to restore that db.so how to take the backup of all user permissions .
i should check that all permissions after restore.
so how to take the backup of all permissions.
September 14, 2009 at 3:16 pm
You can use the transfer login task in visual studio (Integration Services project) and set CopySids = true.
September 14, 2009 at 4:07 pm
ok thanks........
the db is sql2000 db.
so how to take the backup of user permissions.
September 14, 2009 at 5:28 pm
A standard full database backup should also backup the system tables that contain the Users and their assigned permissions. No additional actions are required.
If you are trying to map/sync database users to logins after a restore from one Server to another the you can also have a look at the sp_change_users_login system procedure.
September 14, 2009 at 7:42 pm
hopefully you'll find some answers on previous similar posts
http://www.sqlservercentral.com/Forums/Topic508244-359-1.aspx
http://www.sqlservercentral.com/Forums/Topic757794-6-1.aspx#bm761173
September 14, 2009 at 7:48 pm
sorry earlier post was to script users and logins. Links below are for user database permissions.
http://www.sqlservercentral.com/scripts/Security/66129/
http://www.sqlservercentral.com/scripts/Miscellaneous/31315/
September 15, 2009 at 12:40 am
charipg (9/14/2009)
ok thanks........the db is sql2000 db.
so how to take the backup of user permissions.
Infact, this can be done through DTS also. You can use ' Copy SQL Server Objects' and change the default option to only Logins?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply