Unable to Restore Transaction Log – Causes Stack Dump

When restoring a transaction log backup to a log shipped server, the restores fails and causes a stack dump. Error Given An error occurred while processing the log for database ”. If possible, restore from backup. If a backup is not available, it might be necessary to rebuild the log. SQL Server Assertion: File: <mediaRead.cpp>, […]

Encrypting SQL Server Backups

If a database contains sensitive information, it is possible to encrypt any Full, Differential and Transaction Log backups that are taken of it.  This functionality is included with SQL Server Standard Edition and is not just an Enterprise feature. There are no requirements to enable any features in SQL Server, just simply create a Master […]