Category: Backup

• The Missing BACKUP ASYMMETRIC KEY statement

  

  2014-06-02 - Backup, General, Security

  Is the BACKUP ASYMMETRIC KEY statement really missing from the T-SQL language? Read on to discover the truth and see if there are any viable alternatives.

  [more…]

• CERTENCODED: How to Script your Certificates

  

  2014-05-16 - Backup, Cryptography, General, Security

  The ability to copy certificates from one database to another is often an important requirement in SQL Server security management. Read on to learn how to do just that effectively.

  [more…]

• Differential Changed Map (DCM): How SQL Server Tracks Changed Pages

  

  2014-05-07 - Backup, General, Series, SQL Server Internals, Storage Wednesday

  SQL Server uses the Differential Changed Map to determine, which pages changed since the last full backup. Read on to find out how the DCM is working.

  [more…]

• How to Back Up Your Certificates

  

  2014-05-02 - Backup, Cryptography, General, Security

  Certificates are an important part of you encryption strategy and as such need to be backed up. Discover how to achieve that, by using the BACKUP CERTIFICATE statement.

  [more…]

• Log Reuse Waits Explained: ACTIVE_BACKUP_OR_RESTORE

  

  2014-01-16 - Backup, General, Log Reuse Wait, Series, Transaction Log

  Is your database log file growing out of bound and reporting ACTIVE_BACKUP_OR_RESTORE as reason? Read on to find out what that means and what you can do about it.

  [more…]