Configure Transactional Replication in SQL Server 2012 Step by Step [HD]
ฝัง
- เผยแพร่เมื่อ 7 ก.ย. 2024
- Description:
This video is about How to Configure Transactional Replication in SQL Server 2012 Step by Step with No Step Skipped [HD].
You can refer complete Text Tutorial on my website: www.SQLServerLog.com
You can join me on social networks:
Facebook: / sqlserverlog
Linkedin: / sqlserverlog
Google+: www.google.com/...
Twitter: / sqlserverlog
![How to Configure Credentials in SQL Server [HD]](http://i.ytimg.com/vi/F6vOQcWWxYo/mqdefault.jpg)
![🎤 ไปกันต่อออ! จับฉลากร้องเพลง x P’ #XXSIVK [EP.2] (1/2) เพลงของใครจึ้งสุดน้าา 💓🎤 #MXFRUIT](http://i.ytimg.com/vi/mLI_K0sAS4o/mqdefault.jpg)
![[LIVE] : ONE ลุมพินี 78 | คู่เอก "ปกรณ์ vs ฟาบิโอ"](http://i.ytimg.com/vi/LSOmgl0Th2c/mqdefault.jpg)
Hi Manzoor,
Its really helped me a lot to understand and configure the transnational replication.
Great work. thanks a lot man.
Thank you very very much, this was a neat and easy to understand Tutorial.
Very good video and clear instructions.
good video and clear instructions thenk
thank you very much.. this helping me so much
Great, thank you very much for the detail video
Thank you so much sir.
merge replication is possible in two different city through the agent on the behalf of static ip
Thank You !!
Awesome Video !! Keep it up Dude !!
It's good explanation
Thanks nice tutorial
Need one help... Is there any way to pause replication and i can refresh subscriber full database and then resume replication
Thank you
Excellent
Excelent Work
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
Nice video
good one
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?
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.
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.
"
How to use this concept?? On SQL Cluster HA configuration...
not bad. you should describe subscription briefly.
Can we set the dB name to be same for the publisher DB and the subscribed DB
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)
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
How many secondary servers we can add in logshipping??
Full data is not replucate
How to slove replication issue
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
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.
help me
ESILm