In this blog, we would look into a special situation where ONLY SQL Server Agent is missing in SQL Server Configuration Manager.
This blog is from one that came from a DBA from one of my consulting engagements. Let us learn how to fix event id 7000 error.
SQL SERVER – Script Level Upgrade for Database ‘master’ Failed – The Server Principal Owns One or More Availability Group(s) and Cannot be Dropped
In this blog we would learn about fixing error Script level upgrade for database ‘master’ failed because of upgrade step ‘’msdb110_upgrade.sql’
If you have read release notes of SQL Server 2019, Microsoft has finally made an enhancement to error 8152 – String or binary data would be truncated.
In this blog, I would share my findings of how I identified the cause of failure “Disk full: There is not enough disk space on the volume.”
As per them restore job was failing with errors. Let us learn how to solve Log Shipping Job Error: Failed to Connect to Server.
SQL SERVER – Log Shipping Error: Only Members of the Sysadmin Fixed Server Role Can Perform this Operation
Many disaster recovery solutions are available in SQL Server. Let’s learn how we can fix a specific log shipping error about the sysadmin fixed server role.