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)
33,704 reads
Ganapathi varma Chekuri
- Interests: SQL Lover
Calculating DTU's for Azure SQL Database
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
4,721 reads
Restore a Database with CDC Enabled
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
7,259 reads
Configure Read Only Routing
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
17,429 reads
Resolve Network Binding Order Warning in failover cluster
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
3,608 reads
Step by Step Configuring a Dedicated Network for Availability Group
In this article, I will show a procedure to isolate the replication traffic from the public network.
2017-04-10
10,549 reads
Step by Step Configuring AlwaysOn with Log Shipping
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
26,657 reads
Performance Dashboard Error: Could not find stored procedure
In this article, you will learn how to troubleshoot error when you try to launch the main Dashboard Report.
2017-02-27
1,989 reads
vCenter Server fails to start, Purge and Shrink Vcenter SQL Database
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
8,428 reads
Fix Commvault Backup Failures After an Upgrade
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
4,278 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers