Problem description: The transaction log grow up without end. Cause: After investigation we can confirm that the distributor database is with sync with backup option. And that cause the issue Resolution: At this end to solve the issue, I remove this option that we don’t need. I also check this property to all…
Year: 2013
Command sp_cycle_agent_errorlog is failing
Problem description: on ours SQL Server 2008, when we execute “EXECUTE msdb.[dbo].[sp_cycle_agent_errorlog] “, we got the error message below: Msg 22022, Level 16, State 1, Line 0 SQLServerAgent Error: 32. Work done: Step1: We can see that the log is recycled. The file SQLAGENT.OUT contains for each execution the message below: …
Unable to install SCOM 2012 Reporting Services
Problem description: you are trying to install SCOM 2012, and the SQL Server reporting service 2012 part failed. Error message: –> Inside SCOM Setup installation, you got the error message below eThe specified SQL Server instance is not valid. The possible causes of this problem include the following:* SSRS has not been configured correctly*…
How to create a dependency between two or more Availability Groups
Hi all, Problem description: I got a specific scenario where I have to failover two or more AlwaysOn Availability Groups in the same time. To explain by another way, I have to create a dependency between 2 Availability Groups. If one of them failover, the second one has to move also on the same…
AlwaysOn warning: The current WSFC cluster quorum vote configuration is not recommended for this availablity group
Problem description: You have got odd number of nodes. To prevent possible ties in the quorum vote you added a witness disk to the cluster and adjusted the quorum mode in the cluster manager. However, when you perform a failover from SSMS on our SQL Server 2012 Availability group, we got a validation WSFC…
How configure correctly AlwaysOn readable secondary replica for applicationIntent
Hi all, I would like to share with you an issue that I got recently because I didn’t set up correctly AlwaysOn to enable readable database on the secondary replica. Problem description: When I am trying to connect to my application with .Net or PowerShell, I got the following issue only when I…
Keyword not supported: ‘applicationintent’
Problem description: When you try to connect to your SQL Server by using powershell, .Net, sqlcmd… you got this error message: System.ArgumentException: Keyword not supported: ‘applicationintent’. at System.Data.SqlClient.SqlConnectionStringBuilder.set_Item(String keyword, Object value) at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value) Cause: The message occurs when you include ApplicationIntent=ReadOnly (AlwaysOn Availability Groups properties) in your connection string. And the server…