Upgrade Virtual Machine compatabality/Hardware Version

 

Right click on the machine

Power OFF Virtual machine.

Edit settings of VM

Compatibility ->Upgrade

linux coredump path

 Check the coredump path:

/var/lib/systemd/coredump/

Verify the output of below command is unlimited:

#ulimit -c

unlimited

How to add windows NFS server share to ESX NFS datastore

 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:

MSSQL AAG Replica secondary showing disconnected error

 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

MSSQL Error log location

 the error log is located at 

C:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.

crontab job for running every minute | overwrite file

 

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.