I am used to backing up my SQL database every night.
The problem is that when the hardware breaks, I lose all the work for a day. Because I only backup every 24 hours.
I would like to know how I can improve this, if there is a way to keep a SQL Server database constantly cloned on another Server.
So when my hardware breaks again, I don't lose any data.
Also, i like to know if it is necessary to have other server, or there are cloud services for this purpose.
Reading on the internet, could it be that what I need is called "SQL Replication"?
I need expert assistance. I need advice.
Thank you.
I m a database administrator with 10 years of experience in this industry.
I read your project details and I understood your needs ,I can do what you want in the deadline just contact me and we can discuss more about the project.
Hey,
I have good experience in SQL database administration. I have worked on similar kind of DR setups before. Please initiate chat to discuss further.
1. 10 Years of experience
2. Expert in ASP.net,C#.net,VB.net,Sql server,MySql,MS Access,Crystal Report
3. Worked in almost 150 projects.
4. Dedication, timely execution and perfection is our key Skill.
I can assist you with this process. For this, it will be enough to give access to the servers. I have 10 years of experience in sql replication and data recovery.
I have been working on ms sql server for 10+ years and have been in touch with sql server since it's 2000 version , currently i am using sql server 2016 standard based on your scenario replication is a choice also if you have sql 2012 + then always on availability cluster can be used however this require windows server On both sides
Hi,
I am SQL DBA with 9 years of experienceand implemented lot high availabilty option and can help you in your requirement, please connect to proceed.
This can be done to a cloud or for low cost using SQL capabilities. Would be happy to provide the solutions that will solve this issue for you. Hope you find the right freelancer. Cheers!