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.

Taidot: Microsoft SQL Server, SQL, Tietokannan hallinto, Azure, Amazon S3

Näytä lisää: 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

Tietoa työnantajasta:
( 124 arvostelua ) Mercedes, Argentina

Projektin tunnus: #27966802

28 freelanceria on tarjonnut keskimäärin $48 tähän työhön

(17 arvostelua)

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 1 päivässä
(12 arvostelua)

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

$30 USD 1 päivässä
(20 arvostelua)

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 Lisää

$20 USD 7 päivässä
(35 arvostelua)

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 1 päivässä
(24 arvostelua)

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 Lisää

$20 USD 1 päivässä
(13 arvostelua)

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 Lisää

$100 USD 7 päivässä
(7 arvostelua)

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 Lisää

$30 USD 1 päivässä
(9 arvostelua)
(1 arvostelu)

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 Lisää

$30 USD 7 päivässä
(8 arvostelua)

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 Lisää

$30 USD 7 päivässä
(5 arvostelua)

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 1 päivässä
(3 arvostelua)

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 7 päivässä
(1 arvostelu)

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

$30 USD 1 päivässä
(2 arvostelua)
(1 arvostelu)

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 Lisää

$30 USD 7 päivässä
(0 arvostelua)

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 1 päivässä
(0 arvostelua)

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 Lisää

$30 USD 7 päivässä
(0 arvostelua)

@ 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 Lisää

$30 USD 5 päivässä
(0 arvostelua)

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 7 päivässä
(0 arvostelua)