SQL transaction log unexpecting grow on my published database

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…

1

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:   …

0

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*…

0

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…

1

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…

1

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…

0