-
2 VotesReminder - please indicate if a reply has answered your question.
How do I indicate a post answered my question? If a post has answered your original question, please indicate this by clicking on the "Mark as Answer" button ...Sticky | 4 Replies | 51238 Views | Created by Greg Y - Thursday, December 7, 2006 8:22 PM | Last reply by Harry SQL DBA - Saturday, February 19, 2011 5:43 AM
-
0 Votes
strTargetFolder value null
Hi, i executed a Transaction Replica with pullsubscription using T-SQL: ON Publisher = Distributor declare @c_dbname ...Proposed | 2 Replies | 134 Views | Created by jangarSA - Friday, June 21, 2019 3:47 PM | Last reply by jangarSA - 3 hours 35 minutes ago -
0 Votes
Transactional Replication
Why i can't see Subscriptions in Local subscription folder on Publication servers. This is PUSH subscription. I didn't find any replication errors. Please find the ...Unanswered | 1 Replies | 95 Views | Created by VijayKSQL - Monday, June 24, 2019 11:09 PM | Last reply by Dedmon Dai - Tuesday, June 25, 2019 8:23 AM -
0 Votes
restarting distributor/distribution agent
I have two servers involved in replication of a database with the following roles. They are Windows 2012 R2/SQL 13.0.3341.0: Server 1, publisher Server 2, ...Unanswered | 2 Replies | 85 Views | Created by rossb2 - Monday, June 24, 2019 1:05 PM | Last reply by Cathy Ji - Tuesday, June 25, 2019 6:57 AM -
0 Votes
Export a request (automatically)
C:\Users\hca\Desktop\fichier.txt' also i tried some things linked to it (Grant execute on xp_cmdshell , using a proxy account), maybe i did it bad but i'm not sure but ...Unanswered | 2 Replies | 133 Views | Created by hugocarpyro - Friday, June 21, 2019 9:00 AM | Last reply by Hilary Cotter - Friday, June 21, 2019 1:24 PM -
0 Votes
Adding Articles to Merge Publication - Snapshot?
When a table is added to an existing publication, is there a way to generate and apply a snapshot and re-initialize for the new table only? I ask because I am never quite sure ...Answered | 2 Replies | 432 Views | Created by Dick Campbell - Thursday, June 20, 2019 12:47 PM | Last reply by Dick Campbell - Friday, June 21, 2019 10:18 AM -
0 Votes
Can replication handle the load?
I have transactional replication setup between our on-premises SQL 2017 server (Publisher & Distribution) and a SQL 2017 server (Subscriber) in our Azure extended domain. 100Mbs up and down for ...Unanswered | 1 Replies | 161 Views | Created by bfsmith9 - Wednesday, June 19, 2019 7:38 PM | Last reply by Hilary Cotter - Wednesday, June 19, 2019 9:19 PM -
0 Votes
Updating BLOB Values
I have a table named advert04d and I have a blob field named GraphicRef. I am using the code below to update the blob field but this doesn't ...Unanswered | 1 Replies | 188 Views | Created by Mike Smith 2222 - Tuesday, June 18, 2019 10:33 PM | Last reply by Dedmon Dai - Wednesday, June 19, 2019 3:32 AM -
0 Votes
The timestamps prepended to the output lines are expressed in terms of UTC time.
Dear All, I have set up a Transnational Replication on an sql 2008 r2 and I keep receiving the following error message: The timestamps ...Proposed | 2 Replies | 295 Views | Created by ti2 - Friday, June 14, 2019 9:49 AM | Last reply by Hilary Cotter - Monday, June 17, 2019 5:37 PM -
0 Votes
Replicate SQL 2008R2 --> 2016 . Error 8144
0 rollback tran (Transaction sequence number: 0x000822BB000035BF004D00000000, Command ID: 1) Error messages: Procedure or ...Unanswered | 1 Replies | 193 Views | Created by SysAdm.MAC - Thursday, June 13, 2019 7:14 PM | Last reply by Hilary Cotter - Thursday, June 13, 2019 7:49 PM -
0 Votes
Unwanted MStran_PAL_role created as part of replication
Hi, We use Source Control on some of our databases. After creating a publication on one database, we noticed that there were two new roles added. These were named ...Proposed | 3 Replies | 277 Views | Created by DanBlackburnDBA - Tuesday, June 11, 2019 8:43 AM | Last reply by Hilary Cotter - Thursday, June 13, 2019 7:48 PM -
0 Votes
Using Change Tracking (CT) with merge replication
Good Morning/Afternoon, We have a database with merge replication set up for approx 500 subscribers, who each sync via a pull, perhaps 2 or 3 times a day, so approx ...Unanswered | 6 Replies | 382 Views | Created by backtothefuture - Monday, June 3, 2019 1:46 PM | Last reply by Hilary Cotter - Wednesday, June 12, 2019 1:42 PM -
1 Votes
Looking for a SQL Server solution for data replication
As a DBA, I have two SQL Server 2016 SE and looking for a solution to meet our business requirement for one critical application: Two parallel systems located in different ...Answered | 7 Replies | 402 Views | Created by Nasha - Saturday, June 8, 2019 12:33 AM | Last reply by Shanky_621 - Wednesday, June 12, 2019 5:50 AM -
0 Votes
Transactiona l replication issue
Hi, I am getting below issue. This is SQL Server 2014 with Tranactional Replication. this is working fine from past 6 months, even we didn't renamed servers. This issue was ...Answered | 17 Replies | 482 Views | Created by VijayKSQL - Friday, June 7, 2019 11:09 PM | Last reply by Dedmon Dai - Wednesday, June 12, 2019 2:18 AM -
0 Votes
Error adding a monitoring server to a log shipping configuration
I am setting up log shipping for a database and have hit an error at the "monitor server" stage. I used the GUI to create the T-SQL that needs to be executed and it ...Answered | 1 Replies | 342 Views | Created by lb483 - Friday, June 7, 2019 9:35 AM | Last reply by lb483 - Friday, June 7, 2019 6:58 PM -
1 Votes
Connection error in Subscription between my SQL server and Azure database
Hello, i'm having a lot of trouble with doing a replication between a SQL Server 2014 and Azure. I use a remote desktop to connect to the SQL Server machine and there, i start doing ...Answered | 2 Replies | 315 Views | Created by Arturo NS - Tuesday, June 4, 2019 8:50 PM | Last reply by Arturo NS - Wednesday, June 5, 2019 3:25 PM -
0 Votes
MERGE Replication only running under the "Verbose History Agent Profile"
I have a client with a merge replication setup that has 5 different subscribers and a ton of articles. While this setup is less than optimal, it has been running for quite a while. It is ...Unanswered | 3 Replies | 369 Views | Created by jlainc - Saturday, June 1, 2019 8:13 PM | Last reply by YKN123 - Wednesday, June 5, 2019 9:28 AM -
0 Votes
Windows SQL server no longer listening on port 5022 after installation of windows patches
We installed May's windows patches on one of our SQL Server and after that it has stopped SQL relplication (mirroring). Server is no longer listening on Port ...Proposed | 2 Replies | 292 Views | Created by M_C_7 - Monday, June 3, 2019 1:52 PM | Last reply by Dedmon Dai - Tuesday, June 4, 2019 5:58 AM -
0 Votes
limitation on number of nodes in peer to peer replication
if we are using a peer to peer replication in SQL Server 2016 environment is there any limitation in number of nodes that can make peer to peer topology ? and what is the ...Proposed | 1 Replies | 264 Views | Created by Oula Alshiekh - Sunday, June 2, 2019 9:45 AM | Last reply by Dedmon Dai - Monday, June 3, 2019 2:46 AM -
1 Votes
sp_replstart
Hi, Due to a disaster, I had to restore production publisher database (which was a transactional publisher as well a merge publisher) to an earlier point ...Unanswered | 3 Replies | 1487 Views | Created by Mayaaa - Sunday, November 30, 2014 9:39 AM | Last reply by CJ Julius - Thursday, May 30, 2019 11:03 PM -
1 Votes
Having issues in SQL AlwaysOn Replication + Multi-subnet Setup.
Hello, I setup an SQL AlwaysOn Replication in a Multi-subnet. I followed this article (h t t p ...Answered | 3 Replies | 1315 Views | Created by Jasper Levi Meneses - Wednesday, September 14, 2016 10:34 AM | Last reply by chiranjeevivamsy - Thursday, May 30, 2019 8:58 PM - Items 1 to 20 of 11870 Next ›
