Tagged in

SQL Live Mount

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…