Configure Transactional Replication in SQL Server 2012 Step by Step [HD]

  Рет қаралды 121,075

SQLServer Log

SQLServer Log

Күн бұрын

Пікірлер: 33
@mainoddinkhazi5148
@mainoddinkhazi5148 9 жыл бұрын
Hi Manzoor, Its really helped me a lot to understand and configure the transnational replication. Great work. thanks a lot man.
@Lolo_NwanyiOma
@Lolo_NwanyiOma 9 жыл бұрын
Thank you very very much, this was a neat and easy to understand Tutorial.
@PeterPRGN
@PeterPRGN 2 жыл бұрын
good video and clear instructions thenk
@lundhM
@lundhM 6 жыл бұрын
Very good video and clear instructions.
@e99roll_s
@e99roll_s 4 жыл бұрын
thank you very much.. this helping me so much
@smartjames003
@smartjames003 4 жыл бұрын
Great, thank you very much for the detail video
@skgunda
@skgunda 9 жыл бұрын
Thank You !! Awesome Video !! Keep it up Dude !!
@anandprakash2478
@anandprakash2478 5 жыл бұрын
merge replication is possible in two different city through the agent on the behalf of static ip
@premvardhand6315
@premvardhand6315 4 жыл бұрын
Thank you so much sir.
@tsegaeyesus5387
@tsegaeyesus5387 6 жыл бұрын
Thanks nice tutorial
@noorhirjee2274
@noorhirjee2274 8 жыл бұрын
Good Video. Two questions , how to create a network path and from where did you get the local account name for the process account. Thanks
@RakeshLevine
@RakeshLevine 4 жыл бұрын
It's good explanation
@deepikajoshi639
@deepikajoshi639 Жыл бұрын
Need one help... Is there any way to pause replication and i can refresh subscriber full database and then resume replication
@nelsonazolukwamprojects
@nelsonazolukwamprojects 4 жыл бұрын
I got this error: "A .NET Framework error occurred during execution of user-defined routine or aggregate "sp_scriptdropdelreconciliationproc_sqlclr": System.Data.SqlClient.SqlException: The locale identifier (LCID) 8192 is not supported by SQL Server. "
@EUgamingZone
@EUgamingZone 6 жыл бұрын
Sir, I have a question. If an organization have multiple branches and each branch have local server. But main central database server is placed an another place e.g Headoffice. So what is a solution to update all clients data to each other on each transaction and also update main central server. and central server also have two server one is live and one is for backup. Thanks in advance.
@SweetyJagan
@SweetyJagan 8 жыл бұрын
Hi Manzoor, Prodcution standard edition 2012 (publisher) and report server 2016 web edition(subscriber) is this environment eligible for replication? (snapshot and tran repl) Please suggest
@thurasoe2749
@thurasoe2749 5 жыл бұрын
Hi Manzoor very good presentation. If i want to extend replication how can i do. I means. i have replication tableA last 2 month. now i want to replication to another tableB and tableC. How can Update?
@wengfu1141
@wengfu1141 4 жыл бұрын
Can we set the dB name to be same for the publisher DB and the subscribed DB
@naveedshah15
@naveedshah15 5 жыл бұрын
Excelent Work
@ankitchouhan2795
@ankitchouhan2795 4 жыл бұрын
How to use this concept?? On SQL Cluster HA configuration...
@AshishSingh-kg1jf
@AshishSingh-kg1jf 8 жыл бұрын
How many secondary servers we can add in logshipping??
@jugalvaja9236
@jugalvaja9236 5 жыл бұрын
Nice video
@fagi5
@fagi5 8 жыл бұрын
hey friend, At last it gives me this error how to solve it... An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ No active subscriptions were found. The publication must have active subscriptions in order to post a tracer token. (Microsoft SQL Server, Error: 21488)
@YouTickTech
@YouTickTech 6 жыл бұрын
Excellent
@nayeemchowdhury2497
@nayeemchowdhury2497 7 жыл бұрын
not bad. you should describe subscription briefly.
@foodiegowda5690
@foodiegowda5690 6 жыл бұрын
Thank you
@tirusamadi9377
@tirusamadi9377 5 жыл бұрын
Full data is not replucate How to slove replication issue
@Ahoq4585
@Ahoq4585 8 жыл бұрын
good one
@najju0
@najju0 8 жыл бұрын
Hi, I was trying to setup replication. So i went ahead and configured my distributor and then carried on with my Publisher configuration. Once i finished up with the publisher i tried starting the snapshot and log reader agents. I get a red cross on my server in the monitoring screen and this is the eror message i get: Login failed for user 'NT Service\SQLAgent$MSSQLSERVER3'. I know this is something related to the DB roles as db ownership but i am unable to solve this issue. Please help Thanks
@SgtKamer
@SgtKamer 7 жыл бұрын
Najeeb - I know your post is over 6 months old but I just saw your question. Here's how I solved a similar issue like you described. Go into the properties of your database and select the "Files" selection in the left hand pane; then ensure there is an "Owner" set for the files. Mine was blank on both the Publisher and Subscriber and once I set them the issue was resolved. BTW I set the owner on both to [sa]. Hope this helps.
@kubanychbekazhymbekov2660
@kubanychbekazhymbekov2660 6 жыл бұрын
help me
@prasannakumarlk5948
@prasannakumarlk5948 3 жыл бұрын
ESILm
SQL Server Replication - Part 1
24:42
metamanager
Рет қаралды 122 М.
КОНЦЕРТЫ:  2 сезон | 1 выпуск | Камызяки
46:36
ТНТ Смотри еще!
Рет қаралды 3,7 МЛН
Wednesday VS Enid: Who is The Best Mommy? #shorts
0:14
Troom Oki Toki
Рет қаралды 50 МЛН
Непосредственно Каха: сумка
0:53
К-Media
Рет қаралды 12 МЛН
Replicate Tables between Instances of SQL Server using SQL Replication
14:55
SQL Server Management Studio Tips & Tricks
13:25
SQLMaestros
Рет қаралды 16 М.
SQL Server Transactional Replication  A Deep Dive - Drew Furgiuele
1:05:32
High Availability Disaster Recovery Virtual Group
Рет қаралды 14 М.
Microsoft SQL Server Performance Tuning, Live
54:30
Brent Ozar Unlimited
Рет қаралды 117 М.
КОНЦЕРТЫ:  2 сезон | 1 выпуск | Камызяки
46:36
ТНТ Смотри еще!
Рет қаралды 3,7 МЛН