Workflow for walking through an item level recovery with Rubrik for SQL Server database.

sql-demo.sql

-- Show files
SELECT name, physical_name AS current_file_location,(size *8) /1024 AS size_MB
FROM sys.master_files

-- Good data
SELECT * FROM AdventureWorks2014.Sales.SalesPersonQuotaHistory;

-- Uh oh....
DELETE FROM AdventureWorks2014.Sales.SalesPersonQuotaHistory;

-- It's gone all right
SELECT * FROM AdventureWorks2014.Sales.SalesPersonQuotaHistory;

-- Show files
SELECT name, physical_name AS current_file_location,(size *8) /1024 AS size_MB
FROM sys.master_files

-- Restore time
INSERT INTO AdventureWorks2014.Sales.SalesPersonQuotaHistory
SELECT * FROM LM_Demo.Sales.SalesPersonQuotaHistory;

-- Thanks, Rubrik!
SELECT * FROM AdventureWorks2014.Sales.SalesPersonQuotaHistory

-- Empty the Messages window for the next run
SET NOCOUNT ON