Rubrik : Download MS SQL DB Files



Background

When migrating MS SQL database to another location, or even in the cloud, you may want to have the MS SQL database files. It might not be the current version of the running files, it could be what you have recently backed up on the Rubrik appliance. There is a way to generate and download the original data files from a Rubrik snapshot. But, what if you have 48 DBs on 3 differents Rubrik cluster ?

API to the rescue !

As always, the answer is in the API stack ! This is a two ways process. First, you need to generate the files and then, download them from the generated URL.


I have created a script interfacing those 2 API calls, you can find it on my GitHub here.

Here is the script in action : 


This is generating 1 zip file per database. It contains 2 files : the data and the log files.

Once you have the files, this is easy to attach them in any MS SQL instance using MS SQL Studio. Of course, you first need to extract the produced archive. Simply copy the files to their final destination and choose Attach from the SQL Studio.



That's it ! ;)

Comments

Post a Comment

Thank you for your message, it has been sent to the moderator for review...

What's hot ?

ShredOS : HDD degaussing with style

Image
Background Have you ever had the need to properly erase HDD or SSD before disposing them ? Or selling them ? You do not want to have someone else playing around with your data right ? What we usually do is using a bootable Linux Live CD and use dd style command to write random data on the disk right ? But what if you have 10 disks in your machine ? What if you need a report to proof the world that wiping is a success ? I came across this challenge recently.
Read more

Nutanix : CVM stuck into Phoenix

Image
Background Last night, I was in my monthly upgrades process for my clusters. I was about to catch up with all the versions. I was about to start the last run of patches, so I ran the LCM inventory for the last time. Of course I was doing something else in parallel - LCM is so time consuming, you'd better parallel tasking. When I came back to the LCM inventory screen, I saw 6 pre-checks errors : Cassandra down, network down, connection timeout, .... Most scary : node removed from Metadata Ring.
Read more