Tag: MS SQL

MSSQL-Feature-Image
Author: Joe Chan Published Date: 23 Jul, 2020
Posted in MS SQL

DBCC commands

DBCC commands: 1. DBCC means Database consistency checker 2. It…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 27 May, 2020
Posted in MS SQL

Distributed Availability Group — Part 2

Distributed Availability Group — Part 2 How to get Distributed…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 24 May, 2020
Posted in MS SQL

Distributed Availability Groups

Distributed Availability Groups 1. It is an availability group of…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 07 May, 2020
Posted in MS SQL

Always On availability groups — Part 3

How to change Failover Mode in GUI 1. Open SSMS,…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 26 Apr, 2020
Posted in MS SQL

Always On availability groups — Part 2

Lab Information Add a new member in Always On availability…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 19 Apr, 2020
Posted in MS SQL

Always On availability groups

Always On Availability Group 1. It is a group of…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 23 Mar, 2020
Posted in MS SQL

Database Mirror 2

Witness Server 1. It is an optional function in a…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 22 Mar, 2020
Posted in MS SQL

Database Mirror

Database Mirroring 1. Datadase’s recovery model must be full 2….

MSSQL-Feature-Image
Author: Joe Chan Published Date: 21 Mar, 2020
Posted in MS SQL

Log Shipping 2

Remove Log Shipping from Production server with Secondary server In…

MSSQL-Feature-Image
Author: Joe Chan Published Date: 08 Sep, 2019
Posted in MS SQL

Log Shipping

Log Shipping 1. Production Server send transaction log backups to…