Tagged in

SQL Live Mount

Rubrik -  - Easing Regulatory Compliance with Queryable Recovery

General Tech

Easing Regulatory Compliance with Queryable Recovery

As organizations continue to ramp up their efforts to collect and analyze more data, a variety of privacy and data protection regulations have been set to support users’ personal information. In many cases, organizations must now rework their data protection strategy to comply with these new laws while also leveraging the business value of data.   As a Cloud Data Management company, Rubrik wants to make it easier for our customers to deal with all aspects of protecting and managing their data, and facilitating compliance is a critical aspect of that. Backup and recovery can be an especially challenging part of privacy compliance. In this blog post, I’ll focus on selective restores in light of these regulations–though they’re very handy in any DBA’s toolbox. Under the Hood Recovery is an important aspect of many privacy and data protection requirements. Rubrik’s Live Mount feature makes queryable data recovery and selective restores for databases quick and easy. Rubrik initially built this capability for VMs and has expanded it over time to include workloads like traditional physical and virtual relational databases. At a high level, Live Mount makes use of the performance and storage capabilities of the Rubrik cluster to instantly mount the…
Rubrik -  - Performing DBCC Health Checks with SQL Server Live Mount

Product

Performing DBCC Health Checks with SQL Server Live Mount

For many organizations, Microsoft SQL Server supports their most critical applications and has become a key component for modernizing their data center. However, managing and protecting SQL workloads is often a cumbersome and inefficient process. That’s why Rubrik pioneered Live Mount capabilities for SQL Server, which enables SQL recoveries and clones in seconds. Rubrik’s SQL Server Live Mount brings many benefits to organizations and is best known for providing fast item-level recovery. But Live Mount is also a powerful tool for accelerating app development, supporting many testing and development scenarios. Under the Hood of SQL Server Live Mount Many Rubrik customers chose to utilize SQL Server Live Mount for testing and development use cases due to its high efficiency. With Live Mount, there is no need to provision storage resources for point-in-time (PIT) database copies, nor is there a need to wait for complete PIT copies to traverse the network. This efficiency is achieved by utilizing Rubrik’s resources as the underlying storage that hosts our database file structure. The PIT backups, along with any transaction logs, are replayed and presented to the SQL Server of choice via an SMB 3.0 share. The RBS then creates a new database on the…
Rubrik -  - Instant Recovery with SQL Live Mount

Architecture

Instant Recovery with SQL Live Mount

Rubrik Alta, our ninth and largest product release, expands our focus on creating the complete enterprise data management solution. With this goal comes the need to offer instant data access and recovery wherever that data resides. That’s why we at Rubrik are excited to introduce SQL Server Live Mount, a groundbreaking capability that no other solution has ever offered. SQL Server Support Overview Before diving into our Live Mount technology, it’s important to understand how Rubrik supports SQL Server. Just like many other facets of Rubrik, our SQL support is designed around simplicity and efficiency. To protect databases with Rubrik, the user merely installs the Rubrik connector onto the SQL Server host. The connector is lightweight, requires no restarts upon installation, and will automatically upgrade itself in the future as needed. Once installed, the connector auto-discovers all SQL Server instances and databases on the host. From then on, databases can be assigned SLA Domains, have manual snapshots taken, and be easily recovered. Because our connector is highly integrated within the host, we can use an initial full backup along with intelligent block mapping inside the connector to provide incremental forever backups. This method utilizes the network as efficiently as possible…