pvc sql-server-data

apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: sql-server-data
  namespace: sre
spec:
  accessModes:
  - ReadWriteOnce
  resources:
    requests:
      storage: "1000Gi"
  volumeName: 
  storageClassName: nfs

Deployment sql-server

apiVersion: apps/v1
kind: Deployment
metadata:
  name: sql-server
  namespace: sre
spec:
  replicas: 1
  selector:
    matchLabels:
      name: sql-server
  template:
    metadata:
      labels:
        name: sql-server
    spec:
      containers:
      - name: sql-server
        image: mcr.microsoft.com/mssql/server:2019-latest
        imagePullPolicy: IfNotPresent
        ports:
        - containerPort: 1433
        env:
        - name: ACCEPT_EULA
          value: Y
        - name: MSSQL_SA_PASSWORD
          value: "msserver@123456"
        volumeMounts:
        - name: sql-pvc
          mountPath: /var/opt/mssql
      volumes:
       - name: sql-pvc
         persistentVolumeClaim:
           claimName: sql-server-data

svc

kind: Service
apiVersion: v1
metadata:
  name: sql-server
  namespace: sre
spec:
  ports:
  - name: mongo
    port: 1433
    targetPort: 1433
    protocol: TCP
  selector:
    name: sql-server