BACKUP SOLUTION

Backup and Restore your
Microsoft SQL Server

Protect SQL Server 2005 through to SQL Server 2019.
Quickly restore data with fast, easy recovery.

Try Comet for Free What is Comet?

No temporary disk
space required

Compatible with SQL
Server 2005 and later

Remotely browse
databases from the web

Key Features to Protect your Microsoft SQL Server

Backup Features

Backup Features

  • Temporary spool space not required
  • Support for backing up multiple instances from the SQL Server
  • Available instances automatically listed for selection
  • Full database export by default, with fast, efficient data deduplication to optimize bandwidth and storage space
  • Option to perform incremental, differential, and log-based backups with configurable log truncation
  • Backup to your own storage locations
Restore Features

Restore Features

  • Restore to the same or another SQL Server
  • Restore from any past backup snapshot up to your configured retention policy
  • Restore file format can be imported with industry-standard tools such as SQL Server Management Studio
  • Supports SIMPLE recovery mode for quick recovery, using Comet-generated incremental chunks
  • Supports FULL recovery mode for point-in-time log recovery, using MSSQL-generated increments or differential increments
Management Features

Management Features

  • Connect to the server using Windows authentication or native SQL Server authentication
  • Live browse your SQL databases from the Comet Server web interface
  • Instant credential validations using 'Test connection' feature
  • Secure, military-grade encryption during backup, transit and at rest
  • Flexible scheduling
  • Backup / restore job logs and custom email reporting
  • Customize pre and post commands

Centralized Management with Comet’s Intuitive User Interface

Your system’s data is secure, easily discoverable and always accessible

  • Protected Item view - Microsoft SQL Server

  • Authentication using Windows or SQL

  • Include and exclude databases

  • Scheduling down to the minute

  • Restore only the data you need

Frequently Asked Questions about Microsoft SQL Server Backup

How does Comet backup large Microsoft SQL databases with no spooling?

+

Comet uses VDI to create a virtual disk device within the Microsoft SQL Server itself, and then performs a regular T-SQL BACKUP statement into the virtual disk device. All writes to this device are transparently redirected into Comet’s chunking engine. This allows Comet to read data in Microsoft SQL Server’s native backup format without requiring any temporary space on the local PC.

Where can I backup my Microsoft SQL data to?

+

Comet supports many storage destinations including Amazon S3, Google Cloud Storage, Wasabi, Backblaze B2, or you can bring your own hard drives or FTP/SFTP server.

Can I set my own schedules for Microsoft SQL backups?

+

Yes, Comet allows customizable backup scheduling. We also have 9 customizable retention range policies to choose from and customizable email reporting.

Can I run multiple backups on the same machine at the same time?

+

Yes, you can run multiple backups on the same machine at the same time.