Backup those keys, citizen

Periodically I back up the keys within my servers and databases, and when I do, I blog a reminder here. This should be part of your standard backup rotation – the keys should be backed up often enough to have at hand and again when they change. The first key you need to back up…

0

Have you backed up your keys lately?

Did you know that you already have a Server Master Key (SMK) generated for your system? That’s right – while a Database Master Key (DMK) is generated when you encrypt a certificate or Asymmetric Key with code, the Server Master Key is generated automatically when you start the Instance. So you should back all of…

0

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 = ‘<complete path and filename>’…

1

Controlling Just One Part of a Maintenance Plan

A few posts back I mentioned that I was speaking with someone that wanted to use the new Resource Governor feature in SQL Server 2008 to “throttle back” only one portion of a Maintenance Plan, using the Wizard to create one. The problem he had was that the Maintenance Plan Wizard creates a single Agent…

1

Maintenance Plan MetaData

I was recently asked about which tables are involved in a maintenance plan in SQL Server 2005.The primary tables are: msdb.dbo.sysmaintplan_subplansmsdb.dbo.sysmaintplan_logmsdb.dbo.sysmaintplan_logdetailmsdb.dbo.sysdbmaintplansmsdb.dbo.sysdbmaintplan_jobsmsdb.dbo.sysdbmaintplan_databasesmsdb.dbo.sysdbmaintplan_historymsdb.dbo.sysmaintplan_plans Also check the column table_name where the value is ‘%maint%’ in information_schema.tables.

1