Find Jobs
Hire Freelancers

Automated azure database backup and onsite restore script

$250-750 USD

En curso
Publicado hace alrededor de 7 años

$250-750 USD

Pagado a la entrega
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 del proyecto: 13224025

Información sobre el proyecto

7 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
7 freelancers están ofertando un promedio de $552 USD por este trabajo
Avatar del usuario
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 en 10 días
4,9 (6 comentarios)
4,3
4,3
Avatar del usuario
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 en 2 días
4,9 (14 comentarios)
4,0
4,0
Avatar del usuario
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 en 5 días
5,0 (2 comentarios)
3,3
3,3
Avatar del usuario
A proposal has not yet been provided
$400 USD en 3 días
4,9 (2 comentarios)
2,2
2,2
Avatar del usuario
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 en 21 días
5,0 (2 comentarios)
1,8
1,8
Avatar del usuario
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 en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Loganville, United States
5,0
2
Forma de pago verificada
Miembro desde abr 8, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.