The Connection to the Primary Replica is not Active
In this article, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group.
2020-01-31 (first published: 2017-04-17)
11,739 reads
In this article, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group.
2020-01-31 (first published: 2017-04-17)
11,739 reads
This calculator will help you determine the number of DTUs for your existing SQL Server database(s) as well as a recommendation of the minimum performance level and service tier that you need before you migrate to Azure SQL Database.
2018-02-14
2,096 reads
In this post, I’m going to talk about an issue that I found while restoring a backup of CDC enabled database to different SQL instance. You may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.
2018-02-13
2,621 reads
The advantage of Setting the readable secondary as Read-Intent Only will allow the secondary server to serve the read-only workload only if the connection string of the application contains Application Intent=Readonly parameter.
2018-02-05
9,194 reads
In this article, I’m going to show a procedure to resolve an issue that I found while running cluster validation report. you may receive below warning message that includes information about the cause of the warning, which can help you to resolve the issue.
2017-07-20
2,173 reads
In this article, I will show a procedure to isolate the replication traffic from the public network.
2017-04-10
5,625 reads
In this article, I will show you a procedure to combine SQL Server AlwaysOn with logshipping and to make log-shipping to work even in case of failovers between availability replicas in primary site.
2017-04-03
10,834 reads
In this article, you will learn how to troubleshoot error when you try to launch the main Dashboard Report.
2017-02-27
1,278 reads
In this article, you will learn how to troubleshoot If your vCenter Server fails to start and and manually purge the Vcenter database if required.
2017-02-16
4,644 reads
In this article, you will learn how to troubleshoot backup failures in SQL Server 2016 when you run using commvault backup tool
2017-02-09
1,343 reads
As we all know, there are various numeric data types, such as TINYINT, INT,...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By James-Serra
Microsoft Ignite has always announced many new products and new product features, and this year...
hello everyone I must proceed to migrate my database from the premises to EC2...
I'm working with a 260GB sized production-database here and working a little bit with...