In a previous article we have seen that TDE (Transparent Data Encryption) is the encryption of a database at a physical level. That is, it encrypts data files, log files and backups. When a database in SQL Server has enabled… read more
How can we perform backups and other Agent jobs in an Always On Availability Group of SQL Server
In this article we will see how to take backups and run jobs on any server that has the Primary role or is a Preferred Backup Replica in an Always On Availability Group of SQL Server. While installing… read more
How to setup a SQL Server Always On Availability Group for High Availability
Microsoft provides us with the ability to Replicate our databases as a Group on up to eight Secondary Nodes (servers) as a solution for High Availability, Disaster Recovery or even for reading without the Primary Node being occupied. THE… read more
What is Always On Availability Group
The Always On Availability Group is the feature provided by Microsoft in SQL Server to Replicate our bases on up to eight Secondary Nodes (servers) as a solution for High Availability, Disaster Recovery and for reading... read more
