Find Jobs
Hire Freelancers

Automated azure database backup and onsite restore script

$250-750 USD

V teku
Objavljeno pred približno 7 leti

$250-750 USD

Plačilo ob dostavi
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]
ID projekta: 13224025

Več o projektu

7 ponudb
Projekt na daljavo
Aktivno pred 7 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
7 freelancerjev je oddalo ponudbo s povprečno vrednostjo $552 USD za to delo
Avatar uporabnika
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.
$722 USD v 10 dneh
4,9 (6 ocen)
4,3
4,3
Avatar uporabnika
Hello there, I am interested in your project, and will like to complete this for you. please contact me for further details Regards, Tarandeep
$356 USD v 2 dneh
4,9 (14 ocen)
4,0
4,0
Avatar uporabnika
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
$580 USD v 5 dneh
5,0 (2 ocen)
3,3
3,3
Avatar uporabnika
A proposal has not yet been provided
$400 USD v 3 dneh
4,9 (2 ocen)
2,2
2,2
Avatar uporabnika
Hello! I can write such script for you. Will you provide me with access to your infrastructure, or I should just create something similar on my own?
$750 USD v 21 dneh
5,0 (2 ocen)
1,8
1,8
Avatar uporabnika
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
$555 USD v 10 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED STATES
Loganville, United States
5,0
2
Plačilna metoda je verificirana
Član(ica) od apr. 8, 2016

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.