Live Mount - Item Level Recovery
Last updated
Last updated
You will now focus on Item-level recovery from the live-mounted DB on the same host. However, you can perform live mounts of any databases on any host for other use cases.
To get started, delete an item, such as a table, from the StandAlone_AdvWorks database using the scripts provided in the next steps.
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.
Select the Show_File_Location SQL query file from C:\Users\demo.RUBRIK\Desktop\SQL Demo Scripts.
Select Show File Location.sql script and click Open.
Execute the query by clicking on Execute from the ribbon functional area.
This script shows the live-mounted database location. Observe the output. The output shows the file is actually located on Rubrik and not in your storage.
Next, open the Delete Table SQL query file from C:\Users\demo.RUBRIK\Desktop\SQL Demo Scripts and execute it.
This script will delete the contents of Person.EmailAddress table from AdventureWorks database.
Next, open the Recover From LM SQL query file from C:\Users\demo.RUBRIK\Desktop\SQL Demo Scripts and execute it.
This script displays the output of the deleted table and then recovers the Person.EmailAddress table from StandAlone_AdvWorks-LM database to StandAlone_AdvWorks. The script also displays the output of the recovered Person.EmailAddress table in AdventureWorks database.
Go back to Google Chrome, and on RSC, navigate to Live Mounts from the top menu.
Select MSSQL Database.
Select (...) ellipse at the right end and select unmount.
From the pop-up, select UNMOUNT to start the unmount process.
Navigate to Events from the top menu. Verify that the unmount is successful.
Rubrik’s Live Mount extends beyond recovery use cases. The feature also enables easy, accelerated test/dev without impacting production.
Exceptional job, on successfully recovering the contents of one of the tables.
