Database Roles

External Article

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

Spark Connect Dotnet Variant Data Type

By

All Spark Connect Posts I recently published the latest version of the Spark Connect Dotnet...

A New Word: Opia

By

opia – n. the ambiguous intensity of eye contact The entry for this says...

Friday Flyway Tips: Searching a Migration

By

This was actually a cool tip I saw internally from one of the product...

Read the latest Blogs

Forums

Serverless Gets Faster

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Serverless Gets Faster

sqlclient data provider .net provider connection

By jaango123

I have a task to check the connection managers as part of ssis integration...

How

By cw255

Hi, wondering if someone can help me. We're trying to build an application that...

Visit the forum

Question of the Day

Statistics Histograms

I have a statistics objects with 2 key columns from my tables. How many histograms and their type are stored?

See possible answers