-
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 | 50281 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
distribution..MSPublications table shows publisher_id = 1
Hi, I am running the query below for serveral years on different customers with an intention that distribution..MSpublications.publisher_id is always equal to ...Unanswered | 16 Replies | 860 Views | Created by Imran Ali(Enghouse) - Friday, March 15, 2019 12:07 PM | Last reply by Mauricio Moura - Wednesday, April 17, 2019 10:56 PM -
0 Votes
DBCC Checkdb
Maintenance Plan: DBCC Checkdb Duration: 00:00:00 Status: Warning: One or more tasks failed. Details: Check Database ...Unanswered | 5 Replies | 340 Views | Created by Avyayah - Monday, April 15, 2019 10:17 PM | Last reply by Robin Shanab - Wednesday, April 17, 2019 6:16 AM -
2 Votes
AlwaysOn problems
Hello, Cold you please help, can't find information in documents. I am implementing AlwaysOn async on sql server 2017 enterprise. Initial data ...Answered | 6 Replies | 168 Views | Created by MariamG - Tuesday, April 16, 2019 1:12 PM | Last reply by MariamG - Tuesday, April 16, 2019 3:08 PM -
0 Votes
Old snapshot files not being deleted from working directory
Greetings, the old snapshot files are not deleted from the working directory share for the transactional replication we have set up. Job "Distribution clean up: distribution" is running, and ...Answered | 6 Replies | 614 Views | Created by Abeljdang - Friday, April 12, 2019 9:10 PM | Last reply by Dedmon Dai - Tuesday, April 16, 2019 7:38 AM -
1 Votes
SQL Snapshot Replication
Fellow SQLers, Can someone explain if sql snapshot replication does a complete refesh from publisher to subscriber every time snapshot cycle is run? Or, if after the initial ...Answered | 6 Replies | 332 Views | Created by mg101 - Sunday, April 14, 2019 4:45 PM | Last reply by Tom Phillips - Monday, April 15, 2019 7:12 PM -
0 Votes
OLE DB provider "SQLNCLI11" for linked server "\sqlexpress" returned message "Login timeout expired". [SQLSTATE 01000]
Processed 379 pages for database '_x_x', file '_x_x_Log' on file 1. [SQLSTATE 01000] BACKUP LOG successfully processed 379 pages in 0.410 seconds (7.219 MB/sec). [SQLSTATE ...Answered | 1 Replies | 187 Views | Created by Avyayah - Monday, April 15, 2019 4:18 PM | Last reply by Hilary Cotter - Monday, April 15, 2019 5:21 PM -
1 Votes
SQL Server Job Failure
Executed as user. ...QLSTATE 01000] (Message 0) /* Executing Step: 1, DbBackup_ _AutoProductMfgTest*/ [SQLSTATE 01000] (Message 0) Execute [\sqlexpress]. ...Answered | 2 Replies | 304 Views | Created by Avyayah - Thursday, April 11, 2019 10:35 PM | Last reply by Av111 - Friday, April 12, 2019 6:43 AM -
1 Votes
Transaction replication table counts
Hi I am running sql server 2018 to 2014 replication. I need to validate both side tables whether raw counts are equal. I am not expecting to select count(*) from table name. ...Unanswered | 12 Replies | 567 Views | Created by ashwan - Monday, April 1, 2019 4:54 AM | Last reply by ashwan - Friday, April 12, 2019 4:26 AM -
2 Votes
Error on P2P replication from one server to another but not reversely
Hi all, Our set up is 2016 SQL server and we are using P2P transactional replication among our four servers. Recently one of the servers is ...Answered | 7 Replies | 446 Views | Created by JasperMSSQL - Tuesday, April 9, 2019 12:04 AM | Last reply by Puzzle_Chen - Friday, April 12, 2019 2:33 AM -
0 Votes
merge replication issue
Hi Team, i am new to replication we have merge replication in my environment we are getting below error in replication monitor subscriber server,any one help me out how to resolve ...Answered | 2 Replies | 249 Views | Created by Nasar babu - Wednesday, April 10, 2019 5:54 AM | Last reply by Nasar babu - Wednesday, April 10, 2019 7:02 AM -
0 Votes
SQL Server 2012 - Table Replication
1) What Happens if Subscriber Database Restarted Automatically or Network Failure Occurred between Publisher and Subscriber Databases , Do I need to reconfigure the Replication for All databases again ...Answered | 15 Replies | 470 Views | Created by OwaisKhan80 - Friday, April 5, 2019 12:21 PM | Last reply by OwaisKhan80 - Monday, April 8, 2019 11:17 AM -
0 Votes
Could not find stored procedure "" merge replication error
Hi, Getting the below after performing some schema updates. Only appears to be affecting one subscription. Other subscriptions to the same publication database are fine. Can't ...Proposed | 7 Replies | 329 Views | Created by ailurophobic - Wednesday, April 3, 2019 1:44 PM | Last reply by Hilary Cotter - Wednesday, April 3, 2019 3:19 PM -
0 Votes
is it possible to configure transaction replication between a database a, and a database b, when the tables and column names are different between the 2 databases?
is it possible to configure transaction replication between a database a, and a database b, when the tables and column names are different between the 2 ...Unanswered | 3 Replies | 388 Views | Created by TSRam - Sunday, March 31, 2019 5:35 PM | Last reply by Cathy Ji - Tuesday, April 2, 2019 1:41 AM -
0 Votes
problems with SQL Server transactional replication
Hi All, I'm hoping someone can shed some light on a problem I'm experiencing with our SQL Server transactional replication. Before I go into detail, can I advise ...Unanswered | 12 Replies | 541 Views | Created by AgentZI - Thursday, March 21, 2019 12:44 PM | Last reply by Hilary Cotter - Monday, April 1, 2019 1:54 PM -
5 Votes
Encrypting Replication flow
[Initially Posted in Security Forum, posting it here for a better response] I am trying to encrypt replication flow, in two different ways: 1) In both Log Reader ...Answered | 11 Replies | 504 Views | Created by Lokesh Vij - Friday, March 29, 2019 12:40 PM | Last reply by Lokesh Vij - Monday, April 1, 2019 1:15 PM -
0 Votes
Set Up SQL Transactional Replication Between Two Computers in Non-Trusted Domains
Does anyone have instructions on configuring transnational Replication Between Two Computers Running SQL Server in Non-Trusted Domains ? Most of the threads are referring to below ...Proposed | 1 Replies | 337 Views | Created by MiamiKK - Friday, March 29, 2019 11:42 PM | Last reply by Hilary Cotter - Saturday, March 30, 2019 12:23 AM -
0 Votes
Move publisher and subscriber DB's to another drive on same server
I am planning to move publisher and subscriber DB's to another drive on same server and I am planning to follow below steps Stop SQL ...Proposed | 1 Replies | 377 Views | Created by SQLKSH - Thursday, March 28, 2019 11:26 PM | Last reply by Cathy Ji - Friday, March 29, 2019 6:39 AM -
0 Votes
SQL 2016 Peer to Peer Transactional update-update Conflict Issue Due to Reboot?
Dear all, We are using SQL 2016 Peer to Peer Transactional replication in our environment. The p2p replication is configured among 4 nodes with rectangle like topology with ...Unanswered | 6 Replies | 410 Views | Created by JasperMSSQL - Monday, March 25, 2019 5:52 PM | Last reply by JasperMSSQL - Thursday, March 28, 2019 1:23 PM -
0 Votes
"Stand Alone" Replicated Database
I understand basic replication methods but I need help with the viability of setting up a particular situation. The Non-Technical Situation We have an ...Answered | 4 Replies | 333 Views | Created by bmorebri - Wednesday, March 27, 2019 4:41 PM | Last reply by bmorebri - Wednesday, March 27, 2019 6:00 PM -
1 Votes
Replication error: Specify the actual server name (Replication.Utilities)
I was trying to setup transactional replication between two servers A (Azure) and B (Local). I setup A as the publisher and distributor. From B, when trying to connect to ...Proposed | 10 Replies | 550 Views | Created by Balu-Admin - Wednesday, March 20, 2019 6:20 AM | Last reply by Hilary Cotter - Wednesday, March 27, 2019 12:59 PM - Items 1 to 20 of 11814 Next ›
