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. "
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.
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
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, 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.
![Log Shipping Configuration with SQL Server 2012 [HD]](http://i.ytimg.com/vi/NdxJgKpy0Cs/mqdefault.jpg)
![[LIVE] : ONE ลุมพินี 88 | คู่เอก "ป้อมเพชร vs อัสลามจอน"](http://i.ytimg.com/vi/1ZqTVVbMgbo/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.
good video and clear instructions thenk
Very good video and clear instructions.
merge replication is possible in two different city through the agent on the behalf of static ip
thank you very much.. this helping me so much
Great, thank you very much for the detail video
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.
"
Thank you so much sir.
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
Need one help... Is there any way to pause replication and i can refresh subscriber full database and then resume replication
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.
Thanks nice tutorial
It's good explanation
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
Thank You !!
Awesome Video !! Keep it up Dude !!
Excelent Work
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)
How to use this concept?? On SQL Cluster HA configuration...
Nice video
not bad. you should describe subscription briefly.
Can we set the dB name to be same for the publisher DB and the subscribed DB
How many secondary servers we can add in logshipping??
Excellent
Thank you
Full data is not replucate
How to slove replication issue
good one
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