By default, Subscribers to transactional publications should be treated as read-only, because changes are not propagated back to the Publisher. However, transactional replication does offer options that allow updates at the Subscriber.
In this video, i have shown a demo on how to handle error, if subscriber deletes a record without knowing to publisher.
Part 1: • Replication in SQL server - Part 1 || Term...
Part 2 : • Replication in SQL server - Part 2 || Snap...
Part 3 : • Replication in SQL server - Part 3 || Tran...
Поделиться в:
Доступные форматы для скачивания:
Скачать видео mp4
Информация по загрузке:
Скачать аудио mp3
Похожие видео
array(20) {
["mALhebet2dA"]=>
object(stdClass)#5640 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "mALhebet2dA"
["related_video_title"]=>
string(93) "Replication Error during Configuration || Steps to Troubleshoot Replication Error || SQL DBA"
["posted_time"]=>
string(21) "4 года назад"
["channelName"]=>
NULL
}
["-T-yHABqJTI"]=>
object(stdClass)#5643 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "-T-yHABqJTI"
["related_video_title"]=>
string(159) "Репликация на SQL-сервере — Часть 2 || Репликация моментальных снимков на SQL-сервере || Ms SQL"
["posted_time"]=>
string(21) "4 года назад"
["channelName"]=>
NULL
}
["DZ89wxVwSN4"]=>
object(stdClass)#5638 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "DZ89wxVwSN4"
["related_video_title"]=>
string(83) "How to Capture deadlock in SQL server | Trace deadlock | SQL interview Q&A | Ms SQL"
["posted_time"]=>
string(21) "2 года назад"
["channelName"]=>
NULL
}
["lqYyYaJp9Wk"]=>
object(stdClass)#5648 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "lqYyYaJp9Wk"
["related_video_title"]=>
string(72) "Replication in SQL server - Part 4 || Peer to Peer Replication || Ms SQL"
["posted_time"]=>
string(21) "3 года назад"
["channelName"]=>
NULL
}
["PL-xn4QSr30HZEx3bBnFLgjVj8aJ2zRrSu"]=>
object(stdClass)#5632 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(34) "PL-xn4QSr30HZEx3bBnFLgjVj8aJ2zRrSu"
["related_video_title"]=>
string(32) "MS SQL DBA MOCK INTERVIEW SERIES"
["posted_time"]=>
string(0) ""
["channelName"]=>
NULL
}
["m28K21Widn0"]=>
object(stdClass)#5650 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "m28K21Widn0"
["related_video_title"]=>
string(66) "SQL Server Transactional Replication A Deep Dive - Drew Furgiuele"
["posted_time"]=>
string(19) "8 лет назад"
["channelName"]=>
NULL
}
["PLMNie3F2gQ9ZljIxI4xuLWIv9PfFT3IU9"]=>
object(stdClass)#5636 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(34) "PLMNie3F2gQ9ZljIxI4xuLWIv9PfFT3IU9"
["related_video_title"]=>
string(6) "Ms SQL"
["posted_time"]=>
string(0) ""
["channelName"]=>
NULL
}
["D7j62Bqeyzg"]=>
object(stdClass)#5647 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "D7j62Bqeyzg"
["related_video_title"]=>
string(171) "Часть 1. Как устранить неполадки, связанные с медленно выполняющимися запросами в SQL Server. Авт..."
["posted_time"]=>
string(19) "5 лет назад"
["channelName"]=>
NULL
}
["uDFX1YHfRqo"]=>
object(stdClass)#5626 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "uDFX1YHfRqo"
["related_video_title"]=>
string(111) "Настройка производительности Microsoft SQL Server в реальном времени"
["posted_time"]=>
string(19) "6 лет назад"
["channelName"]=>
NULL
}
["raG-Rhth35U"]=>
object(stdClass)#5644 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "raG-Rhth35U"
["related_video_title"]=>
string(33) "Real World SQL Server Replication"
["posted_time"]=>
string(21) "3 года назад"
["channelName"]=>
NULL
}
["FPSb50ELebs"]=>
object(stdClass)#5639 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "FPSb50ELebs"
["related_video_title"]=>
string(45) "SQL DBA Mock Interview for 8 Years Experience"
["posted_time"]=>
string(25) "3 месяца назад"
["channelName"]=>
NULL
}
["OMMLP5UngvA"]=>
object(stdClass)#5645 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "OMMLP5UngvA"
["related_video_title"]=>
string(99) "Мобильным интернетом все не ограничится. Сергей Бойко"
["posted_time"]=>
string(20) "21 час назад"
["channelName"]=>
NULL
}
["tQ5SdB-_Rkg"]=>
object(stdClass)#5633 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "tQ5SdB-_Rkg"
["related_video_title"]=>
string(98) "[Detailed/Advanced] Effectively troubleshoot SQL Server transactional replication latency (Part 1)"
["posted_time"]=>
string(19) "1 год назад"
["channelName"]=>
NULL
}
["zhtpwsCapn0"]=>
object(stdClass)#5631 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "zhtpwsCapn0"
["related_video_title"]=>
string(39) "Types of Backup in SQL Server || Ms SQL"
["posted_time"]=>
string(21) "4 года назад"
["channelName"]=>
NULL
}
["6SJ539vYc-4"]=>
object(stdClass)#5629 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "6SJ539vYc-4"
["related_video_title"]=>
string(140) "Пробное собеседование на должность администратора баз данных SQL (5 лет опыта)"
["posted_time"]=>
string(27) "9 месяцев назад"
["channelName"]=>
NULL
}
["3nF93zDC4q8"]=>
object(stdClass)#5630 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "3nF93zDC4q8"
["related_video_title"]=>
string(60) "Troubleshoot latency in SQL Server transactional replication"
["posted_time"]=>
string(21) "2 года назад"
["channelName"]=>
NULL
}
["h1Su_qyqXVE"]=>
object(stdClass)#5627 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "h1Su_qyqXVE"
["related_video_title"]=>
string(72) "How to Troubleshoot Different scenarios in Always on Availability Groups"
["posted_time"]=>
string(21) "3 года назад"
["channelName"]=>
NULL
}
["Oe_ARGsplvw"]=>
object(stdClass)#5628 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "Oe_ARGsplvw"
["related_video_title"]=>
string(94) "⚡️ Удар по истребителям? || Угроза жизни президента"
["posted_time"]=>
string(21) "4 часа назад"
["channelName"]=>
NULL
}
["kI6N79Q0wU4"]=>
object(stdClass)#5616 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "kI6N79Q0wU4"
["related_video_title"]=>
string(69) "Решаю SQL задачи из Сбер и VK на Junior и Middle"
["posted_time"]=>
string(27) "6 месяцев назад"
["channelName"]=>
NULL
}
["zgIt5VWYG1Y"]=>
object(stdClass)#5617 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "zgIt5VWYG1Y"
["related_video_title"]=>
string(0) ""
["posted_time"]=>
string(20) "10 лет назад"
["channelName"]=>
NULL
}
}