Backup SQL Server database -- 2
Budget: $10 – $30 USD
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.
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.