How To Replicate Same Folder, Same SQL Database from a Production Server to a Data Recovery Server Automatically

SOLVED

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

Parents
  • +1
    verified answer

    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.

  • 0 in reply to Mcnets

    Thanks,  Considering the 3rd party tool you use, can you pls share documentation to that so I can read

Reply Children