Using the SG SMB share with MSSQL

  1. RDP back into the Jump Server, and open up SSMS to validate Storage Gateway access for backups:
  2. Open up a new query window, then initiate a backup directly to the newly created SMB share (should there be any errors, you should directly get an error from the query):

  3. You can also validate the backup, by going directly to the SMB share from windows Explorer:

  4. Once the Storage gateway instance flushes the data to S3, you can validate the S3 bucket to see the backups being transferred:

Congratulations, you have successfully created a Storage Gateway (File Gateway), and used it as a backup target for MSSQL