Retrieving SQL Server Fixed Database Roles for Disaster Recovery

Posted on SQL Server Central See other posts from SQL Server Central
Published on Wed, 23 Feb 2011 07:00:00 UT Indexed on 2011/02/23 7:31 UTC
Read the original article Hit count: 210

Filed under:
We ran into a case recently where we had the logins and users scripted out on my SQL Server instances, but we didn't have the fixed database roles for a critical database. As a result, our recovery efforts were only partially successful. We ended up trying to figure out what the database role memberships were for that database we recovered but we'd like not to be in that situation again. Is there an easy way to do this?

© SQL Server Central or respective owner