Hi guys,
I need help!
My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis
Please how can this be achieved?
Hoping to get a positive response
Thanks
Hi guys,
I need help!
My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis
Please how can this be achieved?
Hoping to get a positive response
Thanks
If you are using virtual machines, you can copy the whole server. If not you could try with SQL Server Always ON tech to get a secondary replica. If you're using a SQL Server Std edition, secondary replica will be read-only. Due the SQL Server connection string has been hard-codified on X3 parameters, you cannot take advantage of file-over technologies, but at least you have a duplicate of your SQL Server.
I'm using a 3rd party tool that allows me to run a replica of my servers in case of disaster.
If you are using virtual machines, you can copy the whole server. If not you could try with SQL Server Always ON tech to get a secondary replica. If you're using a SQL Server Std edition, secondary replica will be read-only. Due the SQL Server connection string has been hard-codified on X3 parameters, you cannot take advantage of file-over technologies, but at least you have a duplicate of your SQL Server.
I'm using a 3rd party tool that allows me to run a replica of my servers in case of disaster.
*Community Hub is the new name for Sage City