Has anyone combined more than one MS SQL server into one and maintained both going forward?
I need to combine two servers into one backup server so that either server could fail over to the backup at
any time. I am not sure how to handle the logins on each server at implementation or going forward.
Any ideas?