Last post Dec 30, 2017 01:57 PM by PatriceSc
Dec 29, 2017 09:53 AM|progy85|LINK
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?
Dec 30, 2017 01:35 PM|DA924|LINK
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
Dec 30, 2017 01:57 PM|PatriceSc|LINK
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.