November 17, 2015 at 8:57 am
We are about to move all of our 2008R2 instances to a new clustered 2 node failover 2012 environment. Can you advise if the following is the best method for migrating logins or is there a better method
https://support.microsoft.com/en-gb/kb/918992
Thank you in advance
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 17, 2015 at 8:59 am
Pretty much hit the nail on the head with that link.
sp_help_revlogin is probably the best tool out to do what you need to do.
November 17, 2015 at 9:01 am
Thank you Anthony
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 17, 2015 at 11:50 am
Yes, sp_helprevlogin is the best way. It'll create two stored procedures in your master DB.
Filtering down the logins to extract and putting into a script is easy. Wrote about it here:
Script SQL Server Logins for Disaster Recovery[/url]
BTW, as the name of the article implies, this is a good script to run periodically for DR purposes. Run the script through some sort of automation against each of your SQL Servers, extracting the logins, and writing to a location you know will be backed up/replicated.
K. Brian Kelley
@kbriankelley
November 18, 2015 at 1:36 am
Thanks Brian
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply