-
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 | 47683 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
Change in the Job Schedule
Hello, i am planning to implement the T-Replication with Partitioned tables, so as a part of regular schedule of jobs is there a way i can trigger the replication agent to replicate the changes ... -
0 Votes
Snapshot in transactional replication
Hi Friends, Although i have immediate_sync and allow_anonymous set to 0, when i am adding a new article and running snapshot, rather than creating snapshot for 1 ...Unanswered | 11 Replies | 140 Views | Created by S P P - Friday, December 01, 2017 2:38 PM | Last reply by SQLServer2k8 - 8 hours 22 minutes ago -
0 Votes
SQL 2012 to 2014 Replication - Agent message code 20084. The process could not connect to Subscriber
Hello, I am trying to set up a new transaction push replication from a SQL2012 to SQL2014 DB. We currently have one running and the new one will be running to an identically ...Answered | 7 Replies | 138 Views | Created by Albert S - Wednesday, December 06, 2017 10:10 PM | Last reply by Albert S - 18 hours 35 minutes ago -
0 Votes
Merge replication: Value of IDENT_CURRENT is greater than what was set @pub_identity_range and @identity_range during replication set-up
=(1) AND [ProductID]<=(10000001) OR [ProductID]>(10000001) AND [ProductID]<=(20000001). I can fix the issue by running: DBCC ...Unanswered | 3 Replies | 57 Views | Created by GB_12141581 - Friday, December 08, 2017 12:34 PM | Last reply by Hilary Cotter - Friday, December 08, 2017 5:22 PM -
0 Votes
Truncate Publisher table in Snapshot Replication
Hi, Can we truncate Published table in snapshot Replication. Please help.Unanswered | 5 Replies | 80 Views | Created by SqlShan - Thursday, December 07, 2017 5:45 PM | Last reply by Hilary Cotter - Friday, December 08, 2017 3:32 PM -
1 Votes
SQL server agent (MSSQLSERVER) service not starting and no messages indicating the cause
Hi, We are using SQL2014 for our application on Windows 10 and Windows 2016 systems. We are observing that SQL server agent is not starting after a system reboot. There ...Unanswered | 6 Replies | 99 Views | Created by PKuruganti - Thursday, December 07, 2017 2:13 AM | Last reply by PKuruganti - Friday, December 08, 2017 3:29 PM -
0 Votes
Accidentally dropped Replication system tables. How to restore those tables?
Hi, I had setup a pull subscription in SQL Server 2016. While cleaning up the tables which are NOT replicated at subscriber end, I had accidentally dropped the system tables ...Unanswered | 4 Replies | 86 Views | Created by Satheesh Kumar E P - Thursday, December 07, 2017 2:45 PM | Last reply by Bartosz Lewandowski - Friday, December 08, 2017 10:05 AM -
0 Votes
Predefined SQL Server alerts for replication are not triggered
I'm trying to setup alerts for replication. I am more interested in 2 predefined alerts 1- Replication: agent failure. 2- ...Proposed | 5 Replies | 214 Views | Created by Muhannad Alghamdi - Tuesday, November 14, 2017 8:16 PM | Last reply by Lin Leng - Tuesday, December 05, 2017 5:55 AM -
0 Votes
SQL Server - Real time replication with Oracle?
What are the best solutions available when considering replication to Oracle? Are any of them realtime? Do any involve queuing of updates. I've used ...Proposed | 3 Replies | 95 Views | Created by Bassrocks27 - Friday, December 01, 2017 7:48 PM | Last reply by Hilary Cotter - Monday, December 04, 2017 2:23 PM -
0 Votes
The distribution agent failed to create temporary files in C:\Program Files\Microsoft SQL Server\100\COM directory. System returned errorcode 5.
Hi All I understand that it tries to write in COM and it fail before writing, after giving access to that folder it fixed the issue, My question why does it ...Unanswered | 1 Replies | 113 Views | Created by MU DBA - Friday, December 01, 2017 5:40 PM | Last reply by Hilary Cotter - Friday, December 01, 2017 7:04 PM -
0 Votes
Publisher unable to connect to subscriber through Aliase name
Hi There, Application have a existing replication setup and they want to add a new subscriber now. The new subscriber supposed to be connected via aliase ...Unanswered | 2 Replies | 74 Views | Created by Chinmay Nayak - Thursday, November 30, 2017 6:00 PM | Last reply by Hilary Cotter - Friday, December 01, 2017 2:49 PM -
0 Votes
How to Configure Replication for Always On Availability Groups under SQL Server 2016 Standard Edition.
I would like to setting up Transactional replication on a database which is part of basic AlwaysOn Availability Group with No readable secondary Server 1 : ...Proposed | 3 Replies | 198 Views | Created by winter007 - Thursday, November 23, 2017 3:18 AM | Last reply by Teige Gao - Friday, December 01, 2017 9:16 AM -
0 Votes
Publication Properties - Snapshot Agent Security?
On the Publisher, I changed 'Snapshot Agent Security' to run under a Windows account, and now I want to change it back to 'Run under the SQL Server Agent service account', except now that radio-button ...Answered | 2 Replies | 71 Views | Created by philfactor - Thursday, November 30, 2017 6:32 PM | Last reply by philfactor - Thursday, November 30, 2017 7:10 PM -
0 Votes
MSSQL Transactional replication for HA
Hi All, I am quite new to MSSQL administration. I am trying to setup HA for my ticket tool (Manage Engine Servicedesk Plus MSP) which allows to use MSSQL. I dont know if this is the ...Answered | 5 Replies | 241 Views | Created by Aliasgar Lokhandwala - Monday, October 02, 2017 10:01 AM | Last reply by Hilary Cotter - Thursday, November 30, 2017 2:45 PM -
1 Votes
SQL SERVER- TRANSACTIONAL REPLICATION
Hello I am working on sql server 2008 Transactional(Peer to PEER Topology)replication monitoring.There I anm facing an error "The replication agent has not logged a ...Proposed | 1 Replies | 85 Views | Created by SUSMITHA PINKY - Thursday, November 30, 2017 1:49 PM | Last reply by Hilary Cotter - Thursday, November 30, 2017 2:43 PM -
1 Votes
SQL Server replication jobs recommended scheduling
I'm doing a transnational replication for many customers and I see that there are 3 jobs that get created with every publication: 1- a job for log reader agent 2- ...Unanswered | 2 Replies | 100 Views | Created by Muhannad Alghamdi - Wednesday, November 29, 2017 7:29 PM | Last reply by Muhannad Alghamdi - Wednesday, November 29, 2017 11:01 PM -
0 Votes
add a new subscription to an existing publication
We are using SQl 2008 push replication and distributor is on its own physical server. We have an existing publication and one subscriber already established and running in production. ...Proposed | 7 Replies | 3408 Views | Created by Ocean Deep - Thursday, June 06, 2013 5:18 PM | Last reply by Hilary Cotter - Wednesday, November 29, 2017 4:22 PM -
0 Votes
Merge replication applying every generation instead of the most recent snapshot
We make heavy use of merge replication and appear to be having a problem with the addition of new subscribers. This is manifesting as the new subscriber taking a great deal of time to complete the ...Proposed | 4 Replies | 103 Views | Created by lb483 - Tuesday, November 28, 2017 5:06 PM | Last reply by Hilary Cotter - Wednesday, November 29, 2017 4:13 PM -
0 Votes
Increase in bandwidth usage after service pack applied
Hi, We're experiencing a weird issue that I may have identified a possible cause of. We're seeing various versions of SQL server, 2008, R2, 2012, 2014 (don't have enough running ...Unanswered | 1 Replies | 82 Views | Created by Marsegg - Tuesday, November 28, 2017 10:06 PM | Last reply by Hilary Cotter - Wednesday, November 29, 2017 3:19 PM -
0 Votes
Replication Database in the same server
Hello, I want to establish the replication of two databases with the same structure but not the same data on the same server in order to create an archive of an ...Proposed | 1 Replies | 75 Views | Created by walid.djama - Wednesday, November 29, 2017 2:58 PM | Last reply by Hilary Cotter - Wednesday, November 29, 2017 3:17 PM - Items 1 to 20 of 11466 Next ›
