FILESTREAM for RBS

Question

FILESTREAM for RBS

pshaship

SSCertifiable

Points: 6125
More actions
August 18, 2011 at 3:25 pm

#243530

I'm configuring FILESTREAM using the link http://technet.microsoft.com/en-us/library/ee748631.aspx
I have 5 databases to configure FILESTREAM. In that case do I need run the below 2 queries for all the 5 databases?
Query 1:use [db_name]
if not exists
(select * from sys.symmetric_keys
where name = N'##MS_DatabaseMasterKey##')
create master key encryption by password = N'Admin Key Password !2#4'
Query 2:
BACKUP MASTER KEY TO FILE = 'C:\RBS_MasterKey\exportedmasterkey'
ENCRYPTION BY PASSWORD = 'Admin Key Password !2#4'

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Each database master key should be backed up.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

pshaship SSCertifiable Points: 6125 More actions · Answer 2

Each database master key should be backed up

Could you please advice me how to backup the master key for each database?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

That is what your second query is doing.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

pshaship SSCertifiable Points: 6125 More actions · Answer 4

Thanks,

In which case or when excatly we need this backed up master key to restore?

Thanks

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

There are many reasons a master key may be required (TDE, create encrypted data in a column, filestream). In all of these cases, you should backup the master key. You should also test restore to ensure you can recover.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

pshaship SSCertifiable Points: 6125 More actions · Answer 6

Could you expain me how to restore a masterkey?

I mean, after restoring the database, we need to restore the masterkey? what is the order of restore like database 1st & then masterkey..

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Yes, database first and then the masterkey.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events