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.
9 freelancer chào giá trung bình$38 cho công việc này
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.
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!