A blog for all the virtualization and operating system troubleshooting

  Right click on the machine Power OFF Virtual machine. Edit settings of VM Compatibility ->Upgrade

 Check the coredump path: /var/lib/systemd/coredump/ Verify the output of below command is unlimited: #ulimit -c unlimited

 1.Enable role "Server NFS " on windows server.     Add roles  “File and Storage Services“ -> ‘Server for NFS’ role 2.Create a Folder in c:\ as "NFS1" 3.Right click on the folder and select properties ->NFS sharing ->Manage NFS sharing    Check "Share the folder"    Click "Permisions" -> give read-write permision for the "All Machines"     4.Right click ESXI and Storage->Create Datastore     select NFS option     provide Datastore name" NFS1     Folder as :/NFS1     Server: IP of the windows machine. NFS datastore creation is completed:

 Error: You will see the secondary replica is disconnected error as: Solution: In this case go to SQL server and check the ERROR log and see the exact error: Error Log location: C:\Program Files\Microsoft SQL Server\<MSSQL15.MSSQLSERVER>\MSSQL\Log I am able to see the error as : There is no user and permisions. On Node2 from SQL query run: GO CREATE LOGIN [RAN\ SQL-AG-VM-Node1 $] FROM WINDOWS GO GRANT CONNECT ON ENDPOINT::hadr_endpoint TO [RAN\ SQL-AG-VM-Node1 $]; GO On Node2 run SQL query GO CREATE LOGIN [RAN\ SQL-AG-VM-Node2 $] FROM WINDOWS GO GRANT CONNECT ON ENDPOINT::hadr_endpoint TO [RAN\ SQL-AG-VM-Node2 $]; GO Now try a failover and you will see both in CONNECTED

  the error log is located at  C:\Program Files\Microsoft SQL Server\MSSQL. n \MSSQL\LOG\ERRORLOG  and  ERRORLOG. n  files.

  1. create a bash script in linux : vi /data/1 ************************* #!/bin/bash mkdir /data echo "test file for ">orig for i in {000..010} do  yes| cp orig file$i done ************************* 2.provide executable permisions chmod +x /data/1 3.Add to cron: run: "crontab -e " and enter below content: * * * * * (cd /data && /bin/bash /data/1) and save the file 4.verify the cron entries crontab -l 5.restart the crond service: systemctl restart crond verify the scrip run everyminute.