Find Jobs
Hire Freelancers

Real Time Database Mirroring = Windows Server

$10-30 USD

Completed
Posted about 8 years ago

$10-30 USD

Paid on delivery
I have Microsoft SQL Server 2012, and have two windows servers both with Microsoft SQL Server 2012. One of the servers is the production server that is hosting my website and database. The other one is supposed to be a back up database, so that if my real one ever goes down I can just use my second server. I need to make sure the data between my real and back up sql databases are always the same/real-time transfer.
Project ID: 10154804

About the project

17 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
A proposal has not yet been provided
$55 USD in 2 days
5.0 (27 reviews)
5.2
5.2
17 freelancers are bidding on average $179 USD for this job
User Avatar
Hi, I'm ready to do this job for you , please give me access to your server so that I could apply High Availability between your server. thanks, hafiz
$25 USD in 1 day
5.0 (7 reviews)
4.8
4.8
User Avatar
Total 5 years of experience as a MS SQL DBA in a Datacenter. Activities performed are configuring high availability solutions like Failover Cluster, Always On Availability Group, Database Mirroring, Log Shipping. Also involved activities like Performance Tunning, Security Management, Backup, Restoration, installations, service pack upgradation, resolving issues. Also having 9 years of experience in .NET development
$30 USD in 1 day
5.0 (24 reviews)
4.3
4.3
User Avatar
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$25 USD in 3 days
4.9 (15 reviews)
3.6
3.6
User Avatar
Hello, I have more than 16 years of experience as SQL Server database administrator. There two or three ways to implement what you are requesting, the best approach will depend on some things that have to be verified (licensing, platforms, etc), I can do all things for you.
$30 USD in 3 days
5.0 (6 reviews)
2.2
2.2
User Avatar
hi, i offer to you alwayson feature. let me know. i'm expert. regards, yuri
$333 USD in 5 days
5.0 (2 reviews)
1.5
1.5
User Avatar
HI, if both servers are in network and is in Active directory domain, we can simply set snapshot replication between both sql server it will sync both database at every 5 sec(you can change it to 1 sec if needed) that way both database will be in sync. i have been doing in my daily job so will be easy for me. Thanks
$35 USD in 5 days
5.0 (1 review)
1.1
1.1
User Avatar
I am efficient enough to do this. My skill and experience is perfect for this assignment. If I am awarded i will start working as early as possible. And, finish the job within time.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am a database administrator and I am in this domain for the last 9 years. I have worked extensively on backup and restore solutions and setting up DRs and migration other than all the database administrative tasks for SQL Server. Currently I am a full time employee in an MNC and working as a technical lead and managing a globally distributed team in US and India. Although I feel that the project budget is too small for this task, I would like to help you out on this budget as I want to start off on Freelancer. I don't want to false commit but the solution would depend on your requirement: Can you answer these questions: 1. Do you really want a real time data transfer or a small delay of a few minutes is fine? 2. How much transaction happens on the first database? 3. Would the secondary copy be purely treated as a backup Or do you want to use it for some other purpose like reporting etc? 4. How many databases do you have on the first server? What is the overall size of all the databases. Let me know if you want any other details or have any questions for me.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Have a good exposure in configuring DR setup with real time data trasnfer between server in Banking domain. Consider this as my proposal and do reach out to me so that we can discuss further.
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have extensive experience in Database replication, High availability and clustering. I have done lot of projects locally in bid enterprises. you can hire my services trustfully.
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Since you have 2 servers .... you can implement AlwaysOn AG...this way you will have both high availability and DR.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have 14 years of experience with SQL Server and I have been participating of some projects of SQL Server High availability. In your case is possible to deploy a cluster solution using SQL Server Alwayson or may Log shipping that is simpler than Cluster.
$2,222 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Berkeley, United States
4.9
26
Payment method verified
Member since Feb 16, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.