-
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 | 47052 Views | Created by Greg Y - Thursday, December 07, 2006 8:22 PM | Last reply by Harry SQL DBA - Saturday, February 19, 2011 5:43 AM
-
0 Votes
The replication agent failed to remove the file system object. Access to the path is denied.
I'm having a problem generating a new snapshot of a merge replication publication. Looking at replication manager it displays completed with a green tick but looking at the detail, it has got as far ...Unanswered | 3 Replies | 76 Views | Created by lb483 - Saturday, June 24, 2017 6:31 PM | Last reply by Hilary Cotter - 3 hours 49 minutes ago -
0 Votes
How to check snapshot agent job progress %
I am running transactional replication and looking for a script to see snapshot progress in % just like in replication monitor gui from management studio. Or at least clear answer that snapshot of all ...Proposed | 2 Replies | 63 Views | Created by ModusPonens030 - 16 hours 57 minutes ago | Last reply by Hilary Cotter - 3 hours 51 minutes ago -
0 Votes
Identity range issue importing a lot of data into a publication database
Issue I need to refresh a replicated database but I'm having an issue with the articles that have identity_support=1. Trying to import data into these tables (or re-enabling ...Unanswered | 5 Replies | 78 Views | Created by lb483 - Thursday, June 22, 2017 11:13 AM | Last reply by lb483 - Friday, June 23, 2017 4:16 PM -
0 Votes
ALTER PARTITION FUNCTION and Mirroring
Hi All, as I can see from documentation https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-partition-function-transact-sql : SQL Server does not provide ...Unanswered | 1 Replies | 59 Views | Created by Andrew Zakharkin - Friday, June 23, 2017 2:11 PM | Last reply by Hilary Cotter - Friday, June 23, 2017 2:22 PM -
0 Votes
Listing all Subscriptions on Subscriber
Hi All, Running SQL Server 2008 R2. I need to return a list of all subscriptions configured on a given subscriber, across all databases. All the ...Proposed | 4 Replies | 71 Views | Created by 2012S4 - Thursday, June 22, 2017 6:28 PM | Last reply by Bartosz Lewandowski - Friday, June 23, 2017 1:55 PM -
0 Votes
DR for MSSQL Database
I am doing a DR for my local DB. I used Transactional Replication model. I configured Publisher and distributor in my on-premises DB. While ...Proposed | 3 Replies | 85 Views | Created by DineshPDK - Thursday, June 22, 2017 2:32 PM | Last reply by Vikas Rana - Thursday, June 22, 2017 4:59 PM -
0 Votes
Verifying Distribution Agent Profile has changed
Good Morning, I have created a new distribution agent agent profile. I have applied that profile to my agents with my 'Change Existing Agents' button. When I look ...Answered | 2 Replies | 67 Views | Created by swt1974 - Thursday, June 22, 2017 1:29 PM | Last reply by Vikas Rana - Thursday, June 22, 2017 2:21 PM -
0 Votes
SSMS Version 17.1 View Synchronization Status Error SERVER INSTANCE NAME null value
Using SSMS 17.1 I ...Unanswered | 2 Replies | 83 Views | Created by Daniel L R Johnson - Wednesday, June 21, 2017 12:53 AM | Last reply by Teige Gao - Thursday, June 22, 2017 2:32 AM -
0 Votes
What are ports required for Merge Replication
Hi, Please let us know what are mandatory ports should be open for Merge Replication (SQL 2012) Regards, Nikhil ...Proposed | 3 Replies | 74 Views | Created by Nikhil P Desai - Wednesday, June 21, 2017 8:10 PM | Last reply by Hilary Cotter - Wednesday, June 21, 2017 8:27 PM -
0 Votes
Merge Replication Error-Requires Actual Server Name
Hi, We have two servers one at DC and other at DR. We want to configure MS-SQL merge replication between this 2 server. We are using MS SQL Server 2012 Enterprise ...Proposed | 1 Replies | 58 Views | Created by Nikhil P Desai - Wednesday, June 21, 2017 12:05 PM | Last reply by Hilary Cotter - Wednesday, June 21, 2017 12:12 PM -
0 Votes
Replication
The concurrent snapshot for the publication is not available because it is not fully generatedProposed | 2 Replies | 83 Views | Created by geggea - Tuesday, June 20, 2017 9:38 PM | Last reply by Hilary Cotter - Wednesday, June 21, 2017 11:37 AM -
0 Votes
Replication Setup
I am new to SQL Replication so forgive my basic questions here. Goal: Setup a merge replication with remote sqlexpress databases. These are stand alone systems and will most ...Proposed | 2 Replies | 136 Views | Created by Mark A Morton - Tuesday, June 13, 2017 7:21 PM | Last reply by Mark A Morton - Tuesday, June 20, 2017 6:35 PM -
1 Votes
Stopping replication on the production environment
What is the safe way to stop replication on the running production environment. I am going to drop replication completely using sql stored procedures. Because of ...Answered | 16 Replies | 147 Views | Created by ModusPonens030 - Monday, June 19, 2017 12:17 PM | Last reply by Hilary Cotter - Tuesday, June 20, 2017 2:54 PM -
0 Votes
Trying to consolidate two different server table data into a single table at another server.
Hello, I have three servers namely (Server1, Server2, and Server3). Server1 has a database named DB1, server2 has DB2, and server3 has DB3. ...Unanswered | 3 Replies | 84 Views | Created by TipsToKeep - Monday, June 19, 2017 1:36 PM | Last reply by Teige Gao - Tuesday, June 20, 2017 2:57 AM -
0 Votes
Tables are dropped from Subscriber after setting up Transactional/Merge replication
Hi, I am using transactional replication as well as merge replication in different tables to replicate data from one server to another. I have different data in both of the servers. ...Unanswered | 9 Replies | 186 Views | Created by TipsToKeep - Friday, June 16, 2017 6:45 PM | Last reply by Hilary Cotter - Monday, June 19, 2017 1:24 PM -
2 Votes
replication databases
Hi all, how to findout replication databases in sql server?Answered | 2 Replies | 2968 Views | Created by ravi working as 4 yr's of exp om sql server dba - Friday, February 03, 2012 9:09 AM | Last reply by Phea TCS - Monday, June 19, 2017 11:42 AM -
0 Votes
Snapshot Agent Job task fails due to missing double quote
Hi, In french version, when new snaphots agents are generated, the 1st task always fails because of missing double quote in task : sp_MSadd_snapshot_history ...Unanswered | 5 Replies | 130 Views | Created by Despujo - Thursday, June 15, 2017 8:44 AM | Last reply by Hilary Cotter - Thursday, June 15, 2017 1:10 PM -
0 Votes
The process could not connect to Subscriber 'xxxxxx'
Hi, i am getting issue in replication what i setup 1.Publisher on source DB for tables only 2.distributor is also on ...Proposed | 1 Replies | 116 Views | Created by Raghavendra Singh Yadav - Wednesday, June 14, 2017 10:00 AM | Last reply by Lin Leng - Thursday, June 15, 2017 6:34 AM -
0 Votes
SPs schema changes are not replicated (transactional replication)
Hi folks We have a transactional replication between a master server (M) and 2 subscribers used to only read data from the replicated DB (R1 and R2). Everything worked fine until ...Unanswered | 4 Replies | 146 Views | Created by Alin Selicean - Wednesday, June 14, 2017 9:34 AM | Last reply by Alin Selicean - Thursday, June 15, 2017 4:41 AM -
0 Votes
Unable to replicate across two SQL 2014 Database servers on different Win 2012 servers
Hello, We are trying to replication databases across from two different servers using SQL 2014 Server. Each server is configured with the ...Unanswered | 5 Replies | 328 Views | Created by Becks101 - Tuesday, May 23, 2017 10:34 PM | Last reply by Satish Kumar Gajula - Wednesday, June 14, 2017 3:18 PM - Items 1 to 20 of 11289 Next ›
