Option to restore one or more db from snap to cluster. Right now, it involves manual dump and restore
Currently we can only restore full cluster from backup like snap using GUI interface. If we want to restore one or more specific db, it needs manual dump and restore from backup. if we have an option to restore specific db to cluster through GUI interface, it will be very useful.
![](https://secure.gravatar.com/avatar/65e82a915ebb07ae6b5aae0eaf3e96dc?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
-
Milosz commented
It's a key core feature for us, bumping as well.
-
Geoffrey commented
I vote for this feature again.
This feature is very useful in the context that we need to recover or revalidate the contents of a database at a specific time without having to recover the entire cluster.
Saves time and money.
Hoping that this time will be the right one.
-
Matthew commented
I'm bumping this, as perhaps after 4 years, someone will check this out.
-
RuthvikReddy commented
Hi all,
There used to be a queryable backup option back in the day,
Would love to see if it can be brought back!This is a key feature that is required !!!
-
Matthew commented
Upvoting, because a large health insurance client is specifically requesting this feature.
-
Giuseppe Iamele commented
agree, feature (specify specific database or collection) it was requested by our customer to optimize cost and time to take/restore backup.
-
Andrei Mihalciuc commented
Current process of restoring a full cluster snapshot requires a lot of time (which is critical during DRP) and resources. It also very brittle due to a number of manual steps required. Having a possibility to restore specific collections would simplify the process significantly.
-
Lennart Tondeleir commented
This would be a very useful capability to have.
-
Lennart Tondeleir commented
This feature would really help smoothen out DRP procedures. Upvoted!
-
Jim commented
This would be a great feature to have.
-
Jim commented
This would be a very useful feature for us.
-
Ola commented
Upvoting the request, received the feedback from Customer that this feature would be very useful
-
Sanket commented
This is important feature request to have backup at collection level. Everybody does not need snapshot of the entire database which could be of very large size and If I want to restore specific collection then there is a long process of getting rid of all non-required collections.
-
CMI commented
I second this request. Due to the backup being a full cluster snapshot, including oplog and other internals, its size is much larger than our actual data. Being able to just backup the contents of one or more databases would lead to smaller backups that are likely also faster to restore.
-
Geoffrey commented
Hello,
The Atlas portal/API offers the ability to restore a complete database instance from snapshot or restore point. However the scope of this restoration covers the entire instance.
It would be a great asset to be able to restore a simple database from snapshots (encrypted or not). Currently, restoring a database (not a cluster) is a heavy workload that requires outputting data to a local workstation.
Thanks.
-
Veronika commented
I agree, we need to be able to restore individual databases from a cluster snapshot, instead of everything.
-
Arvind Pai commented
upvoting this request.
-
Yong commented
At this time the Cloud Backup snapshot restore completely wipes the destination. I would like to have a function to restore only a specific collection.
-
Mark commented
It is efficient and reduces overhead to store many small databases on the same cluster. However currently we also sacrifice RTO (and the ability to refresh dev/qa from backup) because we are unable to restore individual databases. Having the ability to restore an individual database from snapshot would allow us to more easily support small databases.
-
Raja commented
Hello Team,
This is Raja Selvam,
I would like to get more details on Clod backup.
Lets say suppose i would like to get yesterday's backup from one of the collection.
I do not want to restore the backup into another new cluster.
I do not want to download the backup since my Data will be around 1 TB, Incase if I go for download option this will take 1 day.This solution also not working since we have to load the data to s3.
https://docs.atlas.mongodb.com/backup/cloud-backup/export/Can we have option for cloud backup like legacy backup in feature. We ate tottaly blocked because of this dis adv in atlas. Even for single doc data validation we are creating a M60 cluster with 1 TB data which will take 1 to 2 hours near also cost effective.
Please provide the best solution for the same
Sample ticket : https://support.mongodb.com/case/00900476