SQL复制疑惑 [英] SQL replication doubts
问题描述
刚才我读了SQL REPLICATION链接
http://www.codeproject.com/Articles/215093/Replication-in-MS-SQL-Server
它是一个理解目的的绝佳链接，但经过它我心里有些疑惑，我想让我们问一下，看看有人可以提供帮助..
1.假设我正在使用拉复制，如果这个复制没有被提交或者它被提交了一半，会发生什么。有没有办法知道这个，如果这个工作失败，我可以给某人发电子邮件。
2.让我们说作为订阅者我只想读取来自的数据经销商，但它应该在每天早上5点复制，我应该做什么。
3.或者如果不可能，用户应该采取哪种行动来运行这个想法每天早上5点。
4.如果我每天早上只需要读取数据并在前端显示数据，哪种复制策略非常适合我的场景。
请帮帮我...
谢谢你，
SUNIL MALI。
SHOUTING删除 - OriginalGriff [/ edit]
Just now i read SQL REPLICATION link
http://www.codeproject.com/Articles/215093/Replication-in-MS-SQL-Server
Its a superb link for understanding purpose, but after going through it i had some doubts in my mind, i thought lets just ask and see if somebody can help..
1. Lets say i am using pull replication, what happens if this replication doesn''t get commited or it gets half commited. is there a way to know this, can i send email to someone if this job gets failed.
2. Lets say as a subscriber i just want to read data from distributor but it should be replicated at every day at morning 5, what i should do.
3. or if not possible which action user should take to run this think at every day 5 morning.
4. Which replication strategy well suits my scenario, if i just need to read data every morning 5 and show that data on my front end.
Please help me...
Thanks Regards,
SUNIL MALI.
[edit]SHOUTING removed - OriginalGriff[/edit]
推荐答案
不要在快速答案下发布此内容 - 如果您从文章中获得了代码，那么该文章底部会显示一条新消息按钮，这会将电子邮件发送给作者。然后他们会被告知你希望与他们交谈。
在这里发布这个依赖于他们匆匆而过并意识到这是为了他们。
Don''t post this under Quick Answers - if you got the code from an article, then there is a "new message" button at the bottom of that article, which causes an email to be sent to the author. They are then alerted that you wish to speak to them.
Posting this here relies on them "dropping by" and realising it is for them.
这篇关于SQL复制疑惑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
