Find Jobs
Hire Freelancers

Automated azure database backup and onsite restore script

$250-750 USD

진행 중
게시됨 약 7년 전

$250-750 USD

제출할때 지불됩니다
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: 13224025

프로젝트 정보

7 제안서
원격근무 프로젝트
활동 중 7년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
7 이 프로젝트에 프리랜서들의 평균 입찰은 $552 USD입니다.
사용자 아바타
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 10일에
4.9 (6 건의 리뷰)
4.3
4.3
사용자 아바타
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 2일에
4.9 (14 건의 리뷰)
4.0
4.0
사용자 아바타
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 5일에
5.0 (2 건의 리뷰)
3.3
3.3
사용자 아바타
A proposal has not yet been provided
$400 USD 3일에
4.9 (2 건의 리뷰)
2.2
2.2
사용자 아바타
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 21일에
5.0 (2 건의 리뷰)
1.8
1.8
사용자 아바타
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 10일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED STATES)
Loganville, United States
5.0
2
결제 수단 확인
4월 8, 2016부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.