Sync'ing logins with Log Shipping.
One of the problems restoring a database to a new server is dealing with out of sync logins. The link between a database user name and a server user name is the SID that is generated when the login is added to SQL Server. There are stored procedures to sync the SID's but they have to be run for each user that is out of sync in each database. If you are bringing up a DR server that houses 60 log shipped databases, this can be a very tedious task.
Sync All Logins on a Server in a single click using SP_MSForEachDB - SQL Server Central
No comments:
Post a Comment