title: Does altering SQL Server 2008 R2 Database Master Key seamlessly change dependent keys?
body: <p>In SQL Server 2008 R2, If I alter the database master key do I have to make any changes to certificates that change user data base encryption keys.  I have an annual update requirement.</p>
  
  <p>So if I do this:</p>
  
  <pre><code>USE [Master];
  ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD = 'blah((blah&amp;something';
  GO
  </code></pre>
  
  <ol>
  <li><p>will it also update keys encrypting all the the certificates that were created for user database encryption keys?</p></li>
  <li><p>is there a data loss risk?</p></li>
  </ol>
  
  <p>There are a lot of examples on how to make the change but I'm having trouble finding on point commentary on this specific situation.</p>