-
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 | 48912 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
Changing Existing Transactional Replication Scenario
Hi, I think this may be my first question on MS SQL DBA work, so I appreciate any constructive criticism to my post. I am facing a restructuring of one of my ...Unanswered | 4 Replies | 90 Views | Created by Bill.Mentzer - Friday, October 19, 2018 8:49 PM | Last reply by Bill.Mentzer - 10 hours 5 minutes ago -
0 Votes
Schema-only Replication Problem
Hi all, The background = sql2014 publisher, merge replication , 500 SQL Express 2014 subscribers (user laptops). One publication with roughly 150 ...Answered | 4 Replies | 105 Views | Created by backtothefuture - Friday, October 19, 2018 10:07 AM | Last reply by backtothefuture - 14 hours 55 minutes ago -
0 Votes
SQL Server Table with huge data & Columns and not all the columns are unused.
Hi, We have a table which is of a huge size 300+GB and it is growing at a 25Gb per month. We have identified that there are columns which are not being ...Proposed | 4 Replies | 95 Views | Created by Reddy435 - Thursday, October 18, 2018 5:06 PM | Last reply by Hilary Cotter - 16 hours 11 minutes ago -
0 Votes
Pull transactional replication not picking up new articles
Hello replication experts, I have transactional replication set up in my enterprise SQL 2014 server. Publication has IMMEDIATE_SYNC and ...Proposed | 7 Replies | 278 Views | Created by sqlproddba - Monday, October 8, 2018 7:07 PM | Last reply by Mohsin_A_Khan - Friday, October 19, 2018 1:46 PM -
0 Votes
SQL 2017 returns "The merge process could not replicate one or more INSERT statements to the 'subscriber'."
Hi, We changed our replication system from SQL 2008 R2 to SQL 2017. This means we installed SQL 2017 developer edition with the latest CU on a brand new server. The subscriber ...Answered | 9 Replies | 318 Views | Created by Patrick Simons - Thursday, October 4, 2018 2:27 PM | Last reply by Hilary Cotter - Friday, October 19, 2018 12:18 PM -
0 Votes
Trouble adding articles to an Publication/Subscription that are part of Availability Groups
I was adding a few articles (a delta of 8 tables and 2 views) to an existing publication that is part of an AG (so is subscriber). e.g. -- Oct 16, 2018 - new ...Unanswered | 1 Replies | 99 Views | Created by RayG - Wednesday, October 17, 2018 5:01 PM | Last reply by Puzzle_Chen - Thursday, October 18, 2018 6:34 AM -
0 Votes
Transactional Replication - Error
Pub,sub & distr in same server : ServerA Database : DB1 (pub) Database : DB2 ...Proposed | 10 Replies | 225 Views | Created by KIRUBAKARAN J A - Monday, October 15, 2018 1:24 PM | Last reply by Puzzle_Chen - Thursday, October 18, 2018 6:26 AM -
0 Votes
Identity Range Check Problem
Hello all, This problem always happens whenever a merge replication is used and whenever a table has auto-number (also known as identity). [SQLSTATE 01000] ...Proposed | 4 Replies | 260 Views | Created by Salim Haddad - Monday, September 24, 2018 8:56 AM | Last reply by backtothefuture - Wednesday, October 17, 2018 2:54 PM -
0 Votes
SQL Merge replication Always running Job step2
Hi All, i'm new to sql replication and just want to check if it's normal that the job is always running step 2 the reason I am asking is that we use SCOM to monitor our SQL and it ...Proposed | 1 Replies | 78 Views | Created by Robert Pollock - Tuesday, October 16, 2018 11:52 AM | Last reply by Hilary Cotter - Tuesday, October 16, 2018 2:39 PM -
0 Votes
Updatable Subscriptions on SQL Server 2012
We have a primary web/database server (SQL Server 2012) which publishes data to our backup web/database server (also SQL Server 2012) subscriber using transaction replication. We want to be able ...Answered | 3 Replies | 179 Views | Created by SEMofWA - Thursday, October 11, 2018 10:25 PM | Last reply by Hilary Cotter - Monday, October 15, 2018 1:38 PM -
0 Votes
Setting up transactional replication fails with error 3933 on sp_addlogreader_agent when using a remote distributor
Hi, I've got the following set up: One server cluster (active/passive) Windows Server 2012 with SQL Server 2014 (12.0.5589.7) as ...Unanswered | 3 Replies | 313 Views | Created by JaggenSWE - Thursday, October 4, 2018 11:49 AM | Last reply by Ed Nygma - Sunday, October 14, 2018 7:00 AM -
0 Votes
Transactional replication is not syncing data
properties ->Re-Initialization all subscribers heading to configure snapshot agent which I don't need it. Is there any way to start sync? or alternative ...Answered | 2 Replies | 233 Views | Created by ashwan - Saturday, October 13, 2018 1:44 AM | Last reply by ashwan - Saturday, October 13, 2018 10:00 PM -
7 Votes
Copy or restore read-only database
Hello, I'm using SQL Server 2012. I have a read-only database and I have create a replica from it and a new database should be read-write I ...Answered | 18 Replies | 578 Views | Created by susja - Thursday, September 20, 2018 7:08 PM | Last reply by susja - Friday, October 12, 2018 7:28 PM -
0 Votes
Transactional replication
publication & sub & distri on same server Database 1 & Database 2 after setting transaction ...Answered | 1 Replies | 130 Views | Created by KIRUBAKARAN J A - Friday, October 12, 2018 8:58 AM | Last reply by KIRUBAKARAN J A - Friday, October 12, 2018 4:28 PM -
0 Votes
SQL Replication
i have two database DB1 & DB2 (dev server), replication setup is there from DB1 to DB2. week on week this two DB needs to restored (refreshed) from ProdDB ...Proposed | 6 Replies | 201 Views | Created by KIRUBAKARAN J A - Wednesday, October 10, 2018 1:12 PM | Last reply by Mohsin_A_Khan - Thursday, October 11, 2018 12:12 PM -
0 Votes
Replication and Log Shipping
I currently have a production database being backed up/restored into a data warehouse for reporting. I'm looking to update this more than nightly during the day so I'm looking at table level ...Answered | 9 Replies | 271 Views | Created by Ryan Tiebout - Friday, October 5, 2018 1:01 PM | Last reply by Puzzle_Chen - Thursday, October 11, 2018 6:40 AM -
0 Votes
Retrieving data from Distributor
Distributor settings => Connection it throws exception: TITLE: SQL Monitor ------------------------------ SQL Monitor encountered ...Answered | 3 Replies | 365 Views | Created by P0ZiTR0N - Thursday, September 6, 2018 4:35 PM | Last reply by P0ZiTR0N - Wednesday, October 10, 2018 8:52 PM -
0 Votes
Replication setup
Dear All, I want to set up Replication between 2 different versions of SQL Server, I want to know how much higher I can go e.g. if I had 2008r2, would I be able to ...Proposed | 5 Replies | 163 Views | Created by ti2 - Monday, October 8, 2018 8:18 AM | Last reply by Mohsin_A_Khan - Monday, October 8, 2018 3:51 PM -
0 Votes
Running sp_dropsubscription returns error msg 637 Cannot use SAVE TRANSACTION within a distributed transaction
Greetings I am hitting error ms 637 "Cannot use SAVE TRANSACTION within a distributed transaction" when I try to run ...Answered | 1 Replies | 148 Views | Created by Abeljdang - Sunday, October 7, 2018 3:04 PM | Last reply by Abeljdang - Sunday, October 7, 2018 3:27 PM -
0 Votes
Distribution agent could not apply a generated snapshot file
In my case , some main info as follows . after add a article into one publication , then manually execute sp_startpublication_snapshot to generate snapshot ,and with ...Unanswered | 7 Replies | 950 Views | Created by T.Encore - Sunday, March 8, 2015 11:12 AM | Last reply by sqlproddba - Thursday, October 4, 2018 2:00 PM - Items 1 to 20 of 11693 Next ›
