Microsoft SQL Server Backup
Compatibility
SQL Server Compatibility
Version | Support |
---|---|
SQL Server 2017 | ✔ |
SQL Server 2019 | ✔ |
SQL Server 2022 | ✔ |
Supports Web, Standard, Express, & Enterprise editions.
Supported Recovery Models
Supports Full & Simple recovery models depending on the backup type.
Backup | Support |
---|---|
Full | ✔ |
Differential | ✔ |
Transaction Log | ✔ |
Full (Copy Only) | ✔ |
I. Adding a Server
The first and foremost step involves adding a server. In the platform selection, select Microsoft SQL Server.
II. Setting up the Agent
The second step is to set up the agent on your server. Follow the windows agent installation guide to set up the agent on your Windows server.
III. Setting up the connection
After the agent is installed and running, you need to set up the connection to your SQL Server instance. PettiCloud requires you to specify the following details:
- Server Name: The hostname or IP address of your SQL Server instance.
- For most cases, specifying
localhost
should be fine. - You can also find it in the SQL Server Management Studio (SSMS) login window. If that doesn't work, you can find it by right-clicking on the server in the Object Explorer and selecting "Properties". The server name will be displayed in the "General" tab.
- For most cases, specifying
- Trust Server Certificate: If your SQL Server instance uses a self-signed certificate, you can enable this option
to trust the certificate. For most local installations, this can be set to
true
.
Now click on authenticate to verify the connection. If the connection is successful, you will be navigated to the Create Backup Job page where you can create your first backup job.
IV. Creating a Backup Job
Once the connection is set up, you can create a backup job. The backup job allows you to specify the type of backup you want to perform and the frequency of the backup. They can also be exclusive to a single database. You can start the backup after specifying the required jobs.
V. Viewing Snapshots
You should see your first snapshot in the dashboard after the backup job is completed. If it's successful, you can download the snapshot from the dashboard. You can also view the details of the snapshot, including the size, type, and status.
With this your SQL Server backup is set up and running. You can now manage your backups from the PettiCloud dashboard.
Known Limitations
- Only Windows authentication is supported. If you require support for other authentication methods, kindly contact us by email ([email protected]) stating your requirements. We will try to accommodate your request based on demand.
- Snapshot sizes greater than 1,048,576,000,000 bytes (~ 976 GiB) are not supported.