What are the challenges you face when working across database platforms? Take the survey
Options

Replicating User Accounts

NixNix Posts: 8
edited July 10, 2011 10:29PM in SQL Backup Previous Versions
Is it possible to the replicate SQL user accounts and settings to another server when using log shipping to replicate the databases and logs. I notice when I stop replication and try to bring up the replicated SQL databases in our DR site, I have to recreate the user accounts that were on the production database by hand and associate them with the replicated DB each time I start and then stop replication.

I assume SQL user accounts have SSID's or the SQL equivalent of that when the account is created that makes it unique to that SQL install but I would figure there must be a way to replicate that out to the DR SQL box where the DB's are being replicated to or is that just wishful thinking?

Comments

Sign In or Register to comment.