real time sync mssql

Question

User932259438 posted

Hi,

I have two disk. One is on machine, another is on another location as Google Drive, DropBox and I want real time sync mssql.
What I want to do is if any change data in my database I need this sync immediatelly in real time to update in another location.

Backup in schedule is not ok because the disk can be broken during this time and I need data with real time.

What is best way for this?

Regards

Answer 1

User1120430333 posted

https://msdn.microsoft.com/en-us/library/ms131093.aspx

Because of the SQL Server integration with the .NET Framework common language runtime (CLR), you can use any .NET Framework language to create CLR triggers. This section covers information specific to triggers implemented with CLR integration. For a complete discussion of triggers, see DDL Triggers

http://www.c-sharpcorner.com/blogs/calling-web-service-from-sql-server-using-sql-clr

Answer 2

User753101303 posted

Hi,

That is you can't even tolerate to lose the last minute? It's a bit unclear if you are looking for a replication solution or if this is rather to ensure high availability. Try  https://docs.microsoft.com/en-us/sql/relational-databases/replication/sql-server-replication or maybe https://technet.microsoft.com/en-us/library/ms190202(v=sql.110).aspx

A first step could be to start with improving progressively for example by adding log backups if not done already and improve further as needed based on which cost/benefit you are ready for.

Edit: try to give details about what you need rather than how you think it should be done. You need to have a minimal loss of data should your disk crash? It is then basically a cost vs which downtime and data loss you can tolerate.