How to backup Microsoft SQL in Snel Cloud Backup

Learn how to backup Microsoft SQL in Snel Cloud Backup

In this article, we will explain how you can backup a Microsoft SQL Server to Snel Cloud Backup.

Prerequisites

• Snel Cloud Backup

Step 1: Log in with RDP

Connect to your server via RDP

Step 2: Snel Cloud Backup agent

A protected item can be added through https://backup.snel.com/ and through the agent. We will use the Windows agent to create a new protected item. Open the Snel Cloud Backup agent

Step 3: Add Microsoft SQL Server as backup

Once you are logged in click “+ Add Protected Item”

Give the Protected item a name, we are using “server.example.com – MS SQL”. Once the name is entered select “Microsoft SQL Server” under “Application Backup Types” and click “Next”

$SQLInstances = (Get-ItemProperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server').InstalledInstances
foreach ($sql in $SQLInstances) { [PSCustomObject]@{ InstanceName = $sql } }

Write-Host "$($env:Computername)\$SQLInstances"

If ($SQLInstances -ne "MSSQLSERVER") {
  Write-Host $($env:Computername)\$($SQLInstances)
  $serverName = "$($env:Computername)\$SQLInstances"
} Else {
  Write-Host "Standard SQL Instance was found, proceeding with the script."
  $serverName = "$($env:Computername)\$SQLInstances"
}

You can authenticate with “Windows login credentials” or with “Microsoft SQL credentials”. In our case, we are using Windows authentication

Click “+” to select the databases you want to backup. We are selecting “MSSQLSERVER” to backup all the databases on the server. Click “Ok” to apply the selected databases.

Click “Next >”

You can enter commandos to perform before or after the backup job. We leave this default and do not provide any commands.

Configure the schedule and click “Next >”.

Configure the retention and click “Next >”

If you do not want to run the first backup right after the protected item is added deselect “Run a backup now” and click “Finish”

Select the protected item you want to back up. In our case, it’s “server.example.com – MS SQL” and click “Next >”

The default backup location is already configured click “Backup”.

Conclusion

In this article, we provided you with instructions on how to back up your Microsoft SQL Server with Snel Cloud Backup.