Aug 20
Requirement: Add a node to availability alwayson group. It’s an multi-subnet and the node is a DR node on a different subnet. It is a three node cluster two in same data center (US East) and third node is in DR (US Central). Node A – 172.28.76.12 Node B – 172.28.76.13 Node 3 – 172.29.77.14 …
Nov 07
Step by Step installation of SQL Server 2016 cluster. SQL Server 2016 Cluster is similar to SQL Server 2008R2 but in SQL Server 2016 you can configure the TEMPDB during installation. Please download the PDF version. SQL Server 2016 Cluster. Enjoy the SQL cluster Installation in case any issue you can reach me …
Oct 04
Important Points before backing up the SQL Server Databases. Backing up SQL Server databases is one of the important job to protect the data. Consider the below points while planning and backing up the databases. 1. One of the important step is the Backup plan. Most of the DBA only consider the user database backup …
Jun 14
Getting below Error while building windows 2012 failover cluster. ……………………………………………………………………………………………………………………………………………………….. Checking for account information for the computer object in the ‘UserAccountControl’ flag for CN=SQLDBCLU,CN=Computers,DC=abc,DC=co,DC=in. Set password on SQLDBCLU. There are currently no logon servers available to service the logon request. Unable to successfully cleanup. An error occurred while creating the cluster and the nodes will …
Jun 01
Today one of my friend reported error message in one of his MySQL 5.6.35 Community Version. InnoDB: WARNING: over 67 percent of the buffer pool is occupied by lock heaps or the adaptive hash index! Check that your transactions do not set too many row locks. InnoDB: Your buffer pool size is 127 MB. Maybe you should …
Apr 07
SQL Server Agent service failed to come Online on the Active Node in a 2 Node Fail-over cluster. Error Messages in the Event-logs. [sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435) [sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service. CurrentState: 1 [sqagtres] OnlineThread: Error 435 bringing resource online. To understand the problem, we have to check the AgentError …
Apr 07
Problem: Getting below messages frequently in Event Logs. Windows detected your registry file is still in use by other applications or services. The file will be unloaded now. The applications or services that hold your registry file may not function properly afterwards. DETAIL – 16 user registry handles leaked from \Registry\User\S-1-5-21-2838966446-1611402468-3389684964-82091: Process 604 (\Device\HarddiskVolume2\Windows\System32\lsass.exe) has …
Feb 07
Getting below error while installing SQL Server 2008 R2 in cluster. …………………………………………………………………………………………………………………………………………………………………… SQL Server Setup has encountered the following error: Element not found. (Exception from HRESULT: 0x80070490) …………………………………………………………………………………………………………………………………………………………………… Solution: The above error usually come, if there is offline disks in the custer which you can see when you connect to Failover Cluster Manager and than go …
Jan 30
I got question from one of my friend that “How to check the license type in Microsoft SQL Server 2012 via SQL server.” Solution: There are multiple methods in SQL Server to find the license type in SQL server. Before SQL Server 2008 R2 there used to be properties maintained but in SQL Server 2012, you can …
Dec 14
Getting below error while doing failover of database in Active Passive cluster. Error: 17190, Severity: 16, State: 1. Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0. Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate. …
