Introduction
SQL Server Transparent Data Encryption (TDE) is a security feature. TDE is known as encryption at rest. Database files and backups are protected from unauthorized access using AES or 3DES algorithm.
SQL Server
SQL Server Encrypted Backup and Restore
SQL Server encrypted backup is a feature of both standard and enterprise edition in SQL Server 2019. You can refer below link for more details: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver15 Taking encrypted backups and restoring those backups on another SQL instance requires some additional steps to be followed. Take Encrypted Backup Above encrypted backups could be restored on same … Read more
Taking SQL Server Backups in yyyymmdd_hhmmss format
When we configure native log shipping, it takes log backups in yyyymmdd_hhmmss format. Recently, we had requirement where customer wanted us to take other native backups in yyyymmdd_hhmmss format. We used below code for taking different backups in required format. Full Backup Differential Backup Log backup
Read SQL Server Error logs effectively
As a DBA, how often we check SQL error logs. I would say Mutiple times in a single day. And how many of us really know who to check and read the error logs effectively.
Upgrade OS on MS SQL Server Box
Recently we got one request to upgrade OS of a MS SQL database server. Customer asked us to perform in-place upgrade from Windows 2012 datacenter to Windows 2019. We educated customer that in-place upgrade should be avoided considering associated risks. However, customer was fine with risks considering it was a development database server. Anyways, customer … Read more
SQL Server Log shipping Copy Job Failing without error
We did setup of a fresh log shipping for one of the customer. It was setup without any issues. Log shipping backup, copy and restore jobs were created as well. We restored full and subsequent log backups from primary to secondary for initial sync. Log shipping backup job was working fine as well. However SQL … Read more
Log file full due to snapshot replication
Log File Truncation Pending for Replication in Snapshot Replication
Always ON Group Failover not happening in SQL Server 2017
We had one activity planned which was related to windows hostname and SQL server name change. DB Servers Setup Information: It was a 2 node windows cluster, Node1 & Node2. SQL server Always On was configured on this setup. 4 Synchronous Always On Groups (AG1, AG2,AG3,AG4) were setup and Node1 was acting as Primary. Always … Read more
SQL Server Performance Tuning : Ways to do Index Optimization
In our last post we discussed an approach on what we should do to find whether there is a memory issue or a way to identify if there is a memory crunch which is causing bad SQL performance. However, not always the thing we see on the surface is the root cause. Though there may … Read more
Understanding Files created by Replication Snapshot Agent
In Previous article, we discussed – Where Are various Replication Agent Jobs Running ? This is very important for quick troubleshooting of replication issues. In this article, we will try to understand various files created by Snapshot Agent when a Snapshot is created. If we go to snapshot folder (Check location in Publication Properties), we … Read more