Closed

Backup SQL Server database

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.

Thank you.

Skills: Microsoft SQL Server, SQL, Database Administration, Azure, Amazon S3

See more: how to restore database in sql server, how to take sql server database backup using command prompt, backup all databases sql server management studio, how to backup database in sql server 2012, statement 'backup database' is not supported in this version of sql server., sql server backup and restore step by step, sql server backup schedule, how to backup sql database automatically, net backup sql database, automated backup sql server express, backup sql database windows application, ping sql server database, set automatic backup sql server 2008, automatic backup sql server database, setup automatic backup sql server 2005 express database, auto backup sql server database, automatic backup sql express database, sql server database backup cnet code, database backup sql server 2000 desktop application, automate backup sql express database

About the Employer:
( 124 reviews ) Mercedes, Argentina

Project ID: #27966802

28 freelancers are bidding on average $48 for this job

(17 Reviews)
5.6
neosaransh

Hi. Greetings. Cloud soltuions architect and linux expert. Will provide a reliable and quick backup solution for sure. Give me a message so we can discuss. Thanks.

$10 USD in 1 day
(12 Reviews)
5.2
tutulsoft

-- 20 years SQL server expert , i can discuss your backup issue for any hardware failure ............

$30 USD in 1 day
(20 Reviews)
5.2
AliSafder

Hi, My name is Ali and I can work on it with immediate availability. I have 12 years of experience in .Net, Sql Server. There can be two solutions 1) As you said that backup things on other server cloning. 2) Take More

$20 USD in 7 days
(35 Reviews)
4.9
SqlDevelopment

I can effectively help you to handle data consistency. I am Senior MS SQL Developer with 10+ years of experience and highly advanced professional expertise.

$100 USD in 1 day
(24 Reviews)
4.2
harihut

Hi Sir, I am core SQL Server DBA with 10+years of experience ,kindly check my profile. I have done 1000+ Installation, backup configurations of SQL Server in my career . I am proficient in SQL Server Administration an More

$20 USD in 1 day
(13 Reviews)
4.2
Programmer59

Hello Sir, I am professional developer with having more than 7 year's experience in this field also I read your project description and I am interested in it but still we need some more information Can we discuss the p More

$100 USD in 7 days
(7 Reviews)
3.8
ShafirR

Hi ! When viewing your jobs details, it really jumped out at me. In my current Professional Microsoft SQL Server DBA role, I have extensive experience with Configure Sync SQL Server database with Cloud Server, as well More

$30 USD in 1 day
(9 Reviews)
3.6
(1 Review)
3.2
mumarsami

I am senior IT professional with over 15 years of experience with databases and data warehouses. As per your project description I have all the required skills and experience. If you hire me I will be able to do all y More

$30 USD in 7 days
(8 Reviews)
3.5
drkamine

Hello, i'm an expert IT with more 15 years of experience in IT industry . i'm certified Cisco networking professional 300-100 and 300-115 and Linux professional lpi 101, 102 and RHCSA and VCP 4, 5,5.5 and Data Center a More

$30 USD in 7 days
(5 Reviews)
3.4
sukh0v

Hello, I am system admin with 9 years of experience and I can provide you with a script that can backup dbs every time u need. Also there is a way to clone whole mysql server to some remote data container.

$26 USD in 1 day
(3 Reviews)
2.3
mehmetdinc0159

Hello. I have good idea. we can use the Azure database. Then you will not lose the database. Can we disucss this in more detail? Thanks.

$30 USD in 7 days
(1 Review)
2.1
nguyenhuukhoinw

Hello. I know that u have problems with mysql backup. I would like to help you give advices. Feel free pm me.

$30 USD in 1 day
(2 Reviews)
1.5
(1 Review)
0.6
SantiagoBernabe

You have 2 ways: 1 Put database in log mode and do log backup ever 10 minutes for example you will lost only 10 minutes of data 2 Make a always on infraestructure. Is more expensive (need a license to do that) but y More

$30 USD in 7 days
(0 Reviews)
0.0
pardhureddy999

I am the azure expert with 7 years of experience in onprem and cloud DevOps. We can take the backup using some automation tools and copy in storage accounts or else we can use some other backup Machanisam

$35 USD in 1 day
(0 Reviews)
0.0
hassangeek

Reading your requirements, the simple solution would be to setup a log shipping from source to the destination. You will need another server where the TLOG generated every 15 minutes will be shipped over to the destina More

$30 USD in 7 days
(0 Reviews)
0.0
migrateazuresql

@ Lead Azure Sql data DBA\Sr. SQL DBA @70-743 MS Azure cloud data design and implementation @MS Azure SQL Trainer, Azure Sql migration consultant Worked with large enterprises for about 12+ years and has a wide range More

$30 USD in 5 days
(0 Reviews)
0.0
waqas7pk

Hi, Have a good day! I am professional database administrator having 5+ yrs experience I am also configure MS SQL standby for disaster recovery with no data lose. I am done sql server database switch over.

$40 USD in 7 days
(0 Reviews)
0.0