Database Roles

Retrieving SQL Server Fixed Database Roles for Disaster Recovery

  • Article

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?

2011-02-23

3,104 reads

Blogs

Book Review: Lights Out

By

I have always been interested in GE since I was a kid. My best...

A Successful Blogger on Making the Switch

By

For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and...

Login Timeouts

By

I was recently approached at work about a company that was seeing tons of...

Read the latest Blogs

Forums

would like to know SQL server 2017 Reporting Services Log File Location

By mandavli

would like to know SQL server 2017 Reporting Services Log File Location. I really...

Most recent and previous row

By Chrissy321

Hello, Thanks if you can help. DDL below. This is similar to problems usually...

Using Multi-Value Parameter not working after multiple edits

By Luv SQL

I've now read 15 different articles and it either doesn't work or get various...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers