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

Mac OS X : Display images in-line with terminal

Image
Backgound This time, this is a MacOS tip ! You have a list of files in the terminal window in front of you, some are pictures, some are texts. For text files, this is easy to quickly issue a "more" or "cat" so you immediately figure out what it is. For a picture, this is another story, you need an image viewer. Whatever the speed and simplicity of this editor, you need to load a 3rd party application and switch to it, this is not very handy. What if you could see this image directly from the terminal ? 
Read more