SQL Server - TSQL, Queries, Stored procedure, triggers, tables, views, functions,sql server 2005 features, sql server 2008 features
( Select * from Random_Ideas Order By Common_Sense )
Tuesday, January 13, 2009
Have You Backed Up Your Database Master Key?
If you have encrypted columns in a database or certificates used to create them, you need to make sure that you back up the Database Master Key as part of your maintenance, and then protect that backup file. Here's the short version of the command:
BACKUP MASTER KEY TO FILE = '' ENCRYPTION BY PASSWORD = '' ; GO