Tagged Questions
1
vote
1answer
49 views
SQL Server-MySQL master-master replication
We are looking into setting up a master-master replicated MSSQL database and I am interested to hear of any potential pitfalls that we may run into along the way and generally any advice that you ...
2
votes
1answer
55 views
Is replication from SQL Server 2008 to PostgreSql possible?
Is it possible ? Sql Server as publisher(master) and PostgreSql as slave(subscriber) ? Any type of replication really.
1
vote
2answers
34 views
Modifying replication distributor & publisher
I have a SQL Server 2008 transactional replication setup as follows:
192.168.100.1 <-- Distributor
192.168.100.2 <-- Publisher
192.168.100.3 <-- Subscriber
Our network team want to change ...
0
votes
3answers
126 views
Transfer 1 million records from one table to another
I want to replicate 1 million rows from table1 to table2. I have written a job with a query like this:
delete from table1 OUTPUT *.delete into table2
I am executing this job every one hour, but it ...
0
votes
2answers
74 views
which sql server edition is good for practice [closed]
Which SQL Server (free/trail) would be good to install, which requires minimum resource and have maximum features. I mean, I can practice mirroring,logshipping and replication. I found this link, but ...
1
vote
1answer
64 views
SQL Server replication conflicts after migration from 2000 to 2008
I got a suggestion over at Stackoverflow to post here....greatful for any and all help.
Please bear with me I think this might take a while to explain. For many years now my company has hosted a ...
2
votes
0answers
51 views
How can we achive the replica of databases for SQL Server?
I have been working in VB6 to VB.NET migration project.In VB6 project they have individual databases (access db .mdb) for every user now we made that to centralized database using SQL Server.
In the ...
2
votes
0answers
144 views
Why do I get “The initial snapshot for publication is not yet available.”?
We are using Transactional Replications with updatable subscriptions. 1 publisher, 1 subscriber.
SQL Replication started encountering a constraint error on 3/6 at 10AM because people at two different ...
3
votes
0answers
98 views
How to replicate from SQL Server 2000 to SQL Server 2008 R2?
I have SQL Server 2000 as publisher and SQL Server 20008 R2 as subscriber.
I want to replicate data from SQL Server 2000 to SQL Server 2008 R2 on a different machine.
Primary key fields are not ...
1
vote
0answers
206 views
SQL Server Troubleshooting Replication and Long-Running fn_dblog query
I am trying to get (pull) Transactional Replication working again for a subscriber.
Currently, in Replication Monitor I am seeing messages in the Publisher to Distributor tab and the Distributor to ...
1
vote
0answers
121 views
Transactional Replication Over Domain
I am trying to setup transactional replication in SQL Server 2008 R2 on two servers on separate domains. I am able to create the distributor, create the publication, and create the subscription, ...
2
votes
1answer
77 views
Does sp_droparticle @force_invalidate_snapshot=1 invalidate the entire snapshot?
Forgive this simple SQL Server question, but if I just want to remove a single stored procedure from snapshop replication (2008 SQL Server R2), if I call sp_droparticle, will it invalidate the entire ...
2
votes
1answer
134 views
What causes Transactional SQL Server Replication to need to be rebuilt/re-initialised
In a company I've recently joined we have two SQL Server instances, connected via transactional replication. I'm a developer and hadn't really come across SQL replication before so am a complete ...
3
votes
2answers
309 views
Two way replication
I have a little problem...
I have this case:
2 server instances
2 Databases
1 Table (5 columns)
From server 1 I created publication to replicate all columns of tables I have in DB1.
From server ...
2
votes
1answer
84 views
SQL Server 2008 with SP1 Updating to SP3
I am considering applying this Service Pack 3 in a SQL Server 2008 with SP1, however I was not able to find if there are any drawbacks in this process, specially regarding to Replication Services and ...
2
votes
1answer
174 views
Merge replication SQL Server 2008 publisher with SQL Server 2012 subscriber
is this somehow possible to have SQL Server 2008 publisher with a SQL Server 2012 subscriber for merge replication?
1
vote
1answer
29 views
what are the implications of setting up a subscriber as a publisher?
We have application database (APP_DB) that creates a "live copy" of itself via transactional replication (push) to a database (COPY_DB) on a separate server. This COPY_DB is used for reporting and ...
1
vote
1answer
36 views
Merge Replicate, reinitialise with a different part of the data
I have a set of database with merge replicate configured between them.
The publisher is an aggregate of three sets of data.
Call them set 0, 1, and 2
There are subscribers that grab one set of the ...
0
votes
2answers
113 views
SQL Server 2005 replication for a data warehouse
We are trying to implement some kind of Data Warehouse at my current employer.
Most of our data is in a SQL Server 2005, but we might also integrate some Access databases and some databases in a SQL ...
2
votes
1answer
122 views
Post replication powershell script - on subscriber
I need to execute a command before a replication executes on the publisher, and after, on the subscriber.
I seem to have it working on the publisher, by adding another step in the replication agent.
...
3
votes
2answers
142 views
Cleaning up transaction replication del/ins/upd stored procedures?
I'm referring to the ones that start with:
dbo.sp_MSdel...
dbo.sp_MSins...
dbo.sp_MSupd...
I've noticed they are not removed when I run exec sp_dropsubscription on the Publisher then run ...
0
votes
1answer
283 views
Resuming Replication w/ Database Mirroring when Principle is unavailable
I'm trying to setup a disaster recovery scenario and I'm stuck at this particular point. Here's what I've done so far:
A) Created principal database on Server A and and mirror on Server B
...
1
vote
1answer
351 views
Merge replication - can't create snapshot – timeout
I have a SQL Server 2008 database, and I need a merge replication because I want to sync with mobile devices afterwards.
So I created a replication but when it comes to start the snapshot agent, the ...
2
votes
0answers
76 views
How unsafe is it to change the data source of repl_distributor on a publisher
I have a long story that I will condense to a few bullet points that leads up to my question
Reporting Server (SQL 2008) is distributor/subscriber cluster for a SQL 2000 Transactional Publication
...
3
votes
0answers
58 views
How Much Overhead Does Web Sync Add?
I am running merge replication in SQL2012 using web sync.
Has anybody done any experiments to compare the performance of web sync to connecting to replication using a straight TCP/IP connection?
...
4
votes
2answers
451 views
Log Reader replication agents are constantly restarting
I am recreating (push) transactional replication from a SQL 2000 instance to a SQL 2008 instance which I had to break in order to do a db migration. The 2008 instance is both the distributor and a ...
2
votes
0answers
201 views
SQL Server 2008 replication scenario
First of all sorry about my english, and most importantly, my database ignorance, I'll do my best ;)
Until now, the scenario that I have is as follows:
In a server under our LAN, we have a database ...
4
votes
2answers
433 views
Replicate DB2 table to SQL Server 2008
I need to replicate data from a DB2 database into a SQL Server Database (along the lines of about 80 tables). I can create an SSIS package, to just flat copy the data from one to another pretty easy, ...
3
votes
4answers
429 views
What options exist for copying data between servers on a regular basis?
My apologies if this has already been answered. I've searched SO and of course here on DBA, and am surprised to find no close matches. Specifically, I'm looking for a solution which survives schema ...
1
vote
1answer
250 views
replication warning: transactional replication latency alert not working
I have set up a predefined replication alert (as outlined here) in SQL Server 2008 and the alert for Replication Warning: Transactional replication latency does not appear to work. This is triggered ...
2
votes
1answer
377 views
Replicating Triggers
I am doing some analysis on merge replication and triggers for a project.
I have two tables, Product and Audit that I am replicating.
I have an update trigger on the Product table which is ...
7
votes
1answer
329 views
Transactional replication from SQL Server 2000 to 2008
I have legacy databases on two SQL Server 2000 servers that I am trying to replicate to a SQL Server 2008 R2 database using transactional replication.
The 2008 server is not in the same LAN, so I am ...
4
votes
2answers
410 views
replication monitor: why is current average performance poor?
I am a replication rookie. We have a very simple transactional replication set up in SQL Server. I am looking at the Replication Monitor on the subscriber and one of my subscriptions show Poor ...
2
votes
1answer
304 views
New foreign key and merge replication
We are experiencing an issue when creating a new foreign key to an existing table, which is being replicated to another SQL Server 2008. More specifically, we are adding a new foreign key to this ...
2
votes
1answer
607 views
PK Violation after transactional replication
I have an application set up with transactional replication being pushed to a standby machine that will be used for emergency failovers. The replication appears to be working, any inserts made to ...
0
votes
1answer
76 views
Re-subscribing to a merge publication after edits made offline
Hypothetical Question - To help scenario planning.
Let's say I have a 2008 R2 Merge Publication with 5 active subscribers. The publication is deleted and all subscriptions are removed. A week or so ...
0
votes
1answer
47 views
Copy snapshot files from Publisher, Paste and Apply on subscriber in SQL Merge Replication
I read an excellent article about copying the snapshot files for Transactional replication from Publisher to Subscriber and Apply them on subscriber.
...
3
votes
1answer
483 views
Sql Server 2008 Replication “Generate Scripts” option not available
All,
On Sql Server 2008, I have Transaction Replication going from Server1 to Server3 (with Server2 as distribution).
I have an option to "Generate Scripts" on Publication on Server1. But I do not ...
0
votes
3answers
137 views
Alternative of replication in internet disconnection period of time
Hi I'm looking for an alternative of merge replication that work without internet connection, something like red gate sql data compare but not in uniq direction.
0
votes
1answer
37 views
Copying a subscribed database to the publisher server
I have two servers.
I have installed a merge replication in the publisher (Server A) and I have added two subscriptions with the same database name.
- One on the publisher itself and the seconde one ...
1
vote
2answers
87 views
Controlling the order in which merge articles are applied by snapshot at initialization?
I have a replication scheme that was created several months ago. Since that time the schema has had a variety of changes. All existing subscriptions were updated as these changes were made as the ...
2
votes
3answers
331 views
SQL Server 2008r2 replication from multiple sources
I am currently rearchitecting an application so that each of seven businesses will have there own "live" SQL Server 2008 database and at scheduled times during the data the data from all seven ...
3
votes
3answers
2k views
How do i set up an Alert that tells me when a replication of data failed?
I've got Database Mail setup and tested fine. Alerts do work when I stop and start the replication agent job, but I cannot get it to throw any alerts when data moves from a publisher db to a ...
0
votes
1answer
80 views
Merge Replication Invalid Object ( on an object that no longer exists ) ComErrorException
My merge replication scheme has suddenly started failing. When trying to sync it complains that there is an invalid object. 'dbo.myfunction'. The function used to exist but was removed. There was ...
1
vote
1answer
91 views
Why is replication attempting to distribute NULL values into Identity columns
We are sporadically getting this error:
Explicit value must be specified for identity column
in our replication environment. I have checked the transaction command that is reporting the error and it ...
-1
votes
1answer
125 views
Sql Server Agent REPL Jobs
I know that replication uses Sql Agent jobs to pull subscriptions. Are these jobs supposed to stay in an 'executing' state? (Sql 2008 SP1)
1
vote
2answers
350 views
Microsoft SQL 2008 Cluster with replication
i am in the process of setting upi a SQl Server 2008 64 bit Failover cluster.
A lot of the database queries that we are running during the days are db intensive and lock a lot of the tables while ...
0
votes
1answer
1k views
Run SQL Server Snapshot Agent automatically
I am trying to setup automatic transactional replication. Basically I have some script files that are executed after each other. They set up a replication from one server to another and this works ...
2
votes
2answers
765 views
How To Restore A Replicated Database
I am replicating our live database using transaction replication. This is basically to have a backup copy of our database in the case of server failure.
The replicated database is read only, so I ...
3
votes
1answer
158 views
How Commit works in a transactional push replication with updatable subscribers
I want to know if in a transactional push replication with updatable subscribers, a commit is only done when all subscribers have succeeded to make it, or if it only guarantees the correct commit in ...
