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

8624 Internal Query Processor Error: The query processor could not produce a query plan

  Problem description: We got some mini memory dump. In side our SQL error log, we can see the error message below           Stack Signature for the dump is 0x00000000950A8E26          External dump process return code 0x20000001.          External dump process returned no errors.Error: 8624, Severity: 16, State: 116.          Internal Query Processor Error: The query processor could…

0

Moving SSAS Database to a new drive on same server

Problem description: After you moved SSAS databases to a new drive on the same server, you are not able to administrate  Analysis Service. SSAS databases is up and running. When you add a database or user, it appears that users are added successfully, but when going back out of the dialog nothing happened. Work done:…

0

How a clustered instance of Analysis Services works

  Analysis Services is clustered as  a generic service resource on a Windows failover cluster. This applies to 2005, 2008, 2008R2, and 2012.   Since SSAS 2005 version, Analysis Services is fully integrated into clustering Setup (the install of SQL):        – SSAS 2005 cluster setup is adding the service on all cluster nodes on the same…

0