Export a Copy of a Standalone SQL Database
Last updated
Last updated
Your SQL Databases often support critical workloads, which can require a lot of testing or development efforts on the production data. Let's discuss how Zaffre can take advantage of the export option to create a standalone copy of one or many databases that can be used without affecting the live production data.
To get started on the export operation, first navigate to Inventory > All > SQL Server Databases.
Navigate to sql1.rubrik.lab > MSSQLSERVER > WideWorldImporters.
Select the most recent day with green checks in the calendar.
Move the slider close to the last log time or select any snapshot. Click (...) ellipse and select Recover.
Select Export and then click NEXT.
Choose sql2 as the compatible host.
Select MSSQLSERVER as compatible instances.
Add WideWorldImporters_exported as the name, select Advanced Method, and choose the default restore path.
Click Export.
Click EVENTS from the left middle panel. Verify on the Events page that the export operation has been completed.
NOTE: It takes about a minute for the Events page to show the export operation
Now, you can verify the exported copy of the database on sql2 host.
From the desktop taskbar at the bottom, double-click the Microsoft SQL Management studio.
Select SQL2 as the Server name.
Click Connect. Expand Databases and verify WideWorldImporters_exported is listed as one of the databases.
Your SQL Databases often support critical workloads, which can require a lot of testing or development efforts on the production data. The export option is a common use case for using a production database snapshot as the source to spin up dev/test clones.
Great job, on successfully exporting your MS SQL database. On to the Live Mount option now!
