Rubrik for Microsoft SQL Server

Data security that will leave you more resilient

Secure hundreds or even thousands of databases from cyber-attacks and operational errors without compromising the performance you need to operate at scale.

request a demo

Protecting Microsoft SQL Server at Scale

Watch now

BENEFITS

Safeguard against ransomware

Keep attackers out of your backups so you know that your data is available and recoverable when you need it most.

Leverage Purpose-Built Tools

Rubrik SQL Server protection leverages the same native SQL Writer Service you trust, while providing additional security capabilities to protect your data at scale.

Unify Management

Whether you are protecting a standalone SQL instance, a failover cluster, an Always-On availability group, or even an encrypted database, Rubrik has your databases covered across on-premises and the public cloud.

Data Protection at Limitless Scale

SQL Server environments come in all shapes and sizes. Regardless if you have hundreds of large databases, thousands of small databases, or both, Rubrik was designed to deliver the performance you need to operate at scale.

ebook

Modern Data Protection for Databases

This guide explores what modern database protection entails, examining the difference between the legacy and modern approach in four areas essential for successful data protection.

Download now

Keep databases secure

Protect SQL databases from any situation

Rubrik Zero Trust Data Security simplifies compliance and keeps your data readily available. Rapidly recover from cyber-attacks and operational failures with ease.

Database dashboard

Monitor the state of your current SQL Server backups, including your latest recovery points. Experience near real-time reporting of snapshots and log backups across your on-premises and cloud environments.

Reporting

Compliment your use of the Database Dashboard with a diverse set of reports that can help you improve operations, plan for growth, and inspect compliance details. Reports can be modified, saved, and automatically distributed for team visibility.

Zero Trust Data Security

Protect Your SQL Server Data

Immutability

Our immutable file system prevents your data from being read, modified, or deleted once it is written. This protection is built-in to Rubrik and can’t be disabled.

Logical Air-Gap

To keep your backups from being discovered by attackers, Rubrik leverages proprietary protocols and authenticated APIs to ensure secure data access.

Multi-Factor Authentication

To prevent intrusion from compromised credentials, Rubrik supports multi-factor authentication, time-based one-time passwords, and single sign-on to verify user identity.

Role-based access control

Granular permissions can be created to grant least-privilege access based on a user's role. This reduces the potential impact of an attack if a bad actor manages to steal your credentials and gain access.

Get Your Time Back

No more manual scripting or job scheduling

Quit worrying about whether you’ve left a database unprotected. Automatically discover and protect your SQL Server databases on-premises or in the cloud, regardless of their deployment configurations.

Automated discovery

Rubrik automatically discovers all of your hosts, instances, databases, failover clusters, and availability groups wherever the Rubrik Backup Service (RBS) is installed. And because they are discovered as they are created, that means no more having to add your environments manually.

Automated protection policy engine

Assign SLA policies to your SQL Server that define backup frequency, retention, replication, and archival. Then have all of your instances and databases inherit the policy. A simple yet powerful way to manage the protection of your existing databases while ensuring new databases are being protected as they are created.

white paper

Databases Protection for Dummies

Learn how to accelerate backup and recovery speeds, protect against ransomware, and bridge the gap between backup and database administrators.

Download white paper

Manage the details

Granular database protection

Different policies can be assigned at the host, instance, and database levels. You can even have multiple overlapping levels of protection with the most granular policy taking priority.

Log Management

Manage the frequency and retention of your transaction log backups directly from your SLA policy.

Copy Only Backups

If your transaction logs backups are being managed by another process or system, Rubrik has you covered. Our Copy Only mode leaves your transaction logs untouched.

SQL Clustering

For your Failover Cluster Instances and Always-On availability groups, you can control which node to take a backup from. And because Rubrik is cluster-aware, you don’t have to worry about backups being taken twice from separate nodes.

Scale Your Protection

Protect thousands of databases with ease

Rubrik is grounded in the SQL Writer Service but also provides a number of innovative tools to help you seamlessly manage your protection at scale.

Database batching

Do you have multiple databases running on a single host or instance? Our intelligent batching process can capture multiple databases in a single snapshot but store them as individual backups for faster and more efficient operation.

Change block tracking

Proactively scans and fingerprints VSS snapshots to identify the changed blocks on large individual databases, as well as dense database deployments.

Incremental forever

SQL Server does not natively support incremental-forever backups, but Rubrik does. Rubrik is able to offer this capability through the use of block mapping with either change block tracking or VSS scan and fingerprint methods.

Database sharding

Divide large SQL backups into smaller files, helping reduce the risk of incomplete, failed, or lengthy backup times. Automatically distribute the smaller files across parallel streams to boost your ingest performance.

Flexible Recovery Options

Rapid Data Access

With Rubrik, executing a recovery means specifying your desired recovery time and selecting the recovery method. This kind of rapid access enables you to support use cases like granular object level recovery and test/dev refresh.

Live Mount

Host a read/write version of your database directly from the Rubrik Cluster without the need to provision additional storage when creating database clones.

Export

Create a copy of a database without overwriting the original. A production database snapshot acts as the source to clone a copy for testing or development.

Restore

Have a corrupted database and need to restore to a specific point-in-time? Rubrik can drop the original database and create a new database on the same instance with the same name and file structure.

Log Shipping

SQL Log Shipping is a commonly used technique to keep a secondary database up-to-date, however native tools can often require manual configuration steps. Rubrik on the other hand can automate the configuration tasks on the primary and secondary SQL Servers.

Cross Version Restore

Whether for testing or restoring backups that haven’t been accessed in a while, it's not uncommon to restore backups to different versions of SQL Server. Rubrik supports restoring databases to the same or new SQL Server version.

ㅤ

‎‎‎‎ㅤ

Rubrik Live Mount

Get the most out of your data

Database Consistency Checks

Checking for database corruption can take up valuable compute resources and time. But with Rubrik, you can automate a DBCC check with Live Mount and our APIs or SDKs. You can even receive daily status reports or get notified if corruption is detected.

Test/Dev Refresh

Test and development environments need to be continually reset for application development. Leveraging our API and SDKs, you can call on Rubrik backups from an Ansible Playbook to automate a weekly refresh with a few lines of code.

Recovery to a Specific Log Sequence Number (LSN)

Recovering to a specific transaction or set of transactions can be more time consuming and tedious than you would like. Rubrik provides the ability to recover to a specific Log Sequence Number from our API.

Object Level Recovery

There is nothing more frustrating than waiting for a full database restore when you only need to query or recover a few tables. With Rubrik Live Mount, you can perform granular restores of specific rows and tables, and even use multiple Live Mounts to examine when specific data changed.

We stopped doing backups during the day for our highly transactional SQL databases due to application stun. Rubrik diminished the app stun effect, allowing us to go from snapshotting our databases once every night to once every six hours.

Steve Bunch
Server and Storage Manager
Read customer story

Sensitive Data Monitoring & Management assists with PCI-DSS compliance efforts. We can now automate classification of sensitive data, like credit card information, passport data, & other PII, to better understand our risk posture & assign data ownership.

Kevin Mortimer
Infrastructure Services Manager
Read customer story

Resources

Explore more of our resources

VIEW ALL RESOURCES

Rubrik for Oracle and Microsoft SQL Server Datasheet

Rubrik simplifies data protection for databases while providing immediate access with near-zero RTOs, fast object-level recovery, and unlimited database clones in seconds for application development