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 freelances font une offre moyenne de 38 $ pour ce travail
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 t Plus
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 have good knowledge of oracle SQL and I am currently working as a ETL developer. I am looking for this database administrator job.
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 Plus
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!