Backup Types Supported on Secondary Replicas BACKUP DATABASE supports only copy-only full backups of databases, files, or filegroups when it is executed on secondary replicas.… Read More »SQL Server Backup Database on Secondary Replicas
This topic introduces the steps for configuring instances of SQL Server AlwaysOn availability groups What is a cluster? A server cluster is a group of independent servers… Read More »SQL Server AlwaysOn
SQL Server Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between… Read More »SQL Server Replication
The GUI monitoring tool for SQL Server Mirroring Monitoring While I recommend you pay attention to all properties of the GUI, a few we should… Read More »SQL Server Mirroring Monitoring
Database Mirroring is process having a redundant copy of a single database at another location to ensure continuous data availability in case of a disaster… Read More »Database Mirroring
Monitoring Log Shipping can be done using several methods they are as follows: SQL Server Reports Stored procedures Tables in MSDB database SQL Server Error… Read More »Monitoring Log Shipping
IDENTIFY AND FIX THE ORPHANED USERS IN SQL SERVER Great script by Microsoft Also See: SQL Server 2019 Troubleshoot orphaned users
The primary reason(s) you will want to Log shipping Manual Failover the primary database to the secondary database is when you need to: Apply to… Read More »Log shipping Manual Failover
SQL Server log shipping is one of the high availability solutions which involves two or more SQL Server instances; the source server is called the… Read More »SQL Server Log Shipping
The principal goal of a SQL Server High Availability (HA) solution is to minimize the impact of downtime and provide redundancy for databases throughout the… Read More »SQL Server Installation For HA
In this article, we will explore the following topics. Domain controller, active directory and join servers in the configured domain Assign static IP’s for all… Read More »Configure Domain Controller and Active Directory for SQL Server
SQL Server Agent Logs are useful in troubleshooting issues with the database server. It contains both system and user-defined events information. We can use error… Read More »SQL Server Agent Logs