Live Mount to Create an Online Copy of a Standalone SQL Database
Last updated
Last updated
Let's discuss how Zaffre can take advantage of the Live Mount option, which creates a new database from a point-in-time copy of the source database, running on Rubrik storage. RSC provides a Samba share of the new database directly from the Rubrik cluster storage layer to the SQL server selected during the restore procedure. Live Mount significantly reduces the recovery time for the database.
To get started on the Live Mount operation, first navigate to Inventory > All > SQL Server Databases.
Navigate to sql1.rubrik.lab > MSSQLSERVER > StandAlone_AdvWorks.
Select the most recent day with green checks in the calendar.
Click (...) ellipse and select Recover.
Select Mount and then click NEXT.
Choose sql1.rubirk.com as the compatible host.
Choose MSSQLSERVER as the compatible instance.
Type StandAlone_AdvWorks-LM as the Live Mount database name.
Click Mount.
Click EVENTS from the left middle panel. Verify on the Events page that the Live Mount operation has been completed.
NOTE: It takes about a minute for the Events page to show the Live Mount operation
From the desktop taskbar at the bottom, double-click the Microsoft SQL Management studio.
Select SQL1 as the Server name.
Click Connect.
Expand Databases and verify StandAlone_AdvWorks-LM is listed as one of the databases.
Using Rubrik Live Mount, you can significantly reduce the recovery time for the database, and it provides the ability to quickly perform item-level recovery or patching testing for rolling updates to the production environment!
Great job, on successfully Live Mounting your MS SQL database. You will now recover a table using the live mount!
