I have connected MS SQL Server Management Studio to my database hosted on Umbraco cloud, but Backup isn't in the context menu when I select my database. How can I create a local backup of my database?
From the point of view of trying to ensure cross SQL version compatibility I think the "Export Data-tier Application" approach is possibly the best.
Although I would ask yourself why do you need to do a backup of the Cloud database. When you launch your local copy of your website you can use Umbraco to transfer content from your live site to your local development site :-)
backup umbraco cloud database
I have connected MS SQL Server Management Studio to my database hosted on Umbraco cloud, but Backup isn't in the context menu when I select my database. How can I create a local backup of my database?
Hi Will,
The Umbraco Cloud documentation has 2 different approaches to getting a backup of your cloud database:
https://our.umbraco.com/documentation/Umbraco-Cloud/Databases/
They are listed at the bottom.
From the point of view of trying to ensure cross SQL version compatibility I think the "Export Data-tier Application" approach is possibly the best.
Although I would ask yourself why do you need to do a backup of the Cloud database. When you launch your local copy of your website you can use Umbraco to transfer content from your live site to your local development site :-)
Thanks
Nik
is working on a reply...