Skip to main content

Microsoft SQL Server

Compatibility

SQL Server Compatibility

VersionSupport
SQL Server 2019
SQL Server 2022

Supports Web, Standard, Express, & Enterprise editions.

Operating System Compatibility

  • Supports Windows Server 2016 & above.
  • Supports Windows 10 & above.
  • Supports x86, x64, & AMD64 architectures.

Supported Recovery Models

Supports Full, Bulk-Logged, & Simple recovery models depending on the backup type.

BackupSupport
Full
Differential
Transaction Log
Full (Copy Only)

Creating a backup

The first and foremost step involves creating a backup. In the platform selection, select Microsoft SQL Server 2019 or Microsoft SQL Server 2022 depending on your server version.

Petti - Windows Server Client (Connecting)

Setting up the Backup Client

  1. Sign in to Petti's Dashboard.

  2. Navigate to the Downloads on the website and download the latest x86 client for Windows.

    Petti - Download MS Sql Server Client

  3. Extract the package to a directory of your convenience and run the setup.cmd file.

  4. During installation, enter the password of the current logged-in user when prompted.

    Petti - Windows Server Client (Installation)

  5. You will see a similar output when the installation is successful.

  6. Securely transfer a copy of your Saavi file to your server.

    Petti - Windows Server Client (Config)

  7. Open Petti.exe to launch the application and click on the Config button to set the configuration.

    • Integration Token: You can copy & paste the token from the created backup in your dashboard.

    • Databases: The name(s) of the database(s) to be backed up, separated by commas. Names are case-sensitive. You can also specify a single database name.

    • Saavi: Select your Saavi file on the server.

    • MS SQL Server Name: Name of your SQL Server for Windows Authentication. If you have a single SQL Server installed, it is most likely localhost.

      Finding SQL Server Name via SSMS: If you don't know the correct name, you can find it by opening SQL Server Management Studio. Copy the Server name from the Connect to Server window.

      Petti - SQL Server Management Studio for finding SQL Server Name

  8. Save the configuration. It will automatically reconnect in a few seconds. If not, please wait 30 seconds and click the Resync button.

    Petti - Windows Server Client (Connected)

  9. If there are no issues, you should see a "Connected" indicator followed by stats.

Verifying connection from the dashboard

Get back to the dashboard to see if the created backup is online. It might take a minute or two depending on various factors. Kindly be patient. Integration is complete when the backup is online in the dashboard. In a couple of minutes, you should see your first snapshot.

Petti - Dashboard Backup Online

If you encounter any challenges with the aforementioned steps, please do not hesitate to reach out to us for assistance.

Known Limitations

  1. Only Windows authentication is supported. If you require support for other authentication methods, kindly contact us by email (shiv@petti.in) stating your requirements.
  2. Snapshot sizes greater than 1,048,576,000,000 bytes (~ 976 GiB) are not supported.