Automated azure database backup and onsite restore script
$250-750 USD
In Progress
Posted about 7 years ago
$250-750 USD
Paid on delivery
We have a process that we need to automate. Once a week, we backup our 18+ databases in SQL Azure, which saves them to our Azure Storage, then we download them to a local server, unpack and restore on that local server.
Today that process is mostly manual. We would like to automate that using a combination of Powershell, azure management API, and SqlPackage.exe.
The process should allow us to schedule using windows task scheduler.
The process should kick off a backup of each database, monitor that backup, handle errors by emailing a notification to a preconfigured account, once the backup is done, download the backup to the local machine, remove the old local database instance, then run the sql package tool to restore.
As a bonus, it would be nice if we could run a script on the restored database afterward as part of the process.
An example of a powershell script used to export SQL Azure db can be found at [login to view URL]
Hi,
My name is shanalal, I have 9+ yr experience in software development(.Net & SQL Server) and also 2.4 Yr experience in azure technology.
I am interested in your project, i have give you the best solution. I have experience in azure sql & power shell scripting. If you start a chat we can discuss more.
Hi,
Yes, this automation can be simply achieved in powershell. I assume your smtp server can be accessible to send out email alerts. I have my Azure Subscription so I can develop scripts without dependency on you and later test those scripts in your environment.
I have worked on Test Lab Automation project last month where I created an Azure Automation to restore Test VMs to a base configuration state.
I have 11+ years of experience as full stack developer and solution designer. Relevant Azure experience is 4+ years.
Please ping me to discuss more on your project.
Thanks
Prasoon
Hello! My name is Maksim, from Kiev, Ukraine (UTF + 2)
I will be very brief for you. We have big experience with high-level enterprise solutions and want to confirm our reputation in your eyes.
I want to propose you our large expert team who have a strong experience with Azure and they can automate that process.
Will be glad to cooperate and construct the partnership with you! Our CTO can answer technical questions and to give some advice (Removed by Freelancer.com Admin)?
Kind Regards
Maksim Maksimchuk
CEO IntoBi