djj (3/4/2014)
Log Shipping takes care of stored procedures, et al. The thing it does not (at least how we use it) do is to keep the jobs and security synchronized.
Say I have a SQL Login titled "SQLAccount_John_Smith" at the global security level on both servers. I also have three new databases, db1, db2, and db3, all of which are being log-shipped to the DR server. If I add RW rights to db1, db2, and db3 for SQLAccount_John_Smith on the production server, will those rights be added on the DR server? My guess is that it will.