Answered by:
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
Friday, December 29, 2017 9:53 AM
Answers
-
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
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Saturday, December 30, 2017 1:35 PM -
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.
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Saturday, December 30, 2017 1:57 PM
All replies
-
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
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Saturday, December 30, 2017 1:35 PM -
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.
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Saturday, December 30, 2017 1:57 PM