All Questions
Tagged with replication sql-server-2008
110
questions
6
votes
3answers
769 views
Keeping data in old Database (SQL 2008) identical to new Database (SQL 2016)?
I am moving database to new server.
New server has SQL Server 2016 running, current server has SQL Server 2008.
I need to have backup/fallback plan in place for few weeks (in case something goes ...
1
vote
2answers
297 views
The merge process could not connect to the Publisher ' '. Check to ensure that the server is running. (
I have 2 servers with 2 kinds of replications between them.
One is Transactional and the other is merge.
The Transactional replication is working fine but in the merge replication, I'm getting error ...
1
vote
1answer
14 views
Switch publisher - subscriber side
I have 2 server using merge replication. One acts as a Publisher and one acts as a Subscriber.
One day I want to switch the side, publisher become subscriber and subscriber become publisher. In my ...
2
votes
2answers
547 views
SQL Server : cannot add subscriber to publication
I am trying to configure replication as per the official tutorial from Microsoft. In the section Create a subscription to the transactional publication, see step 5.
The name of the subscriber ...
1
vote
1answer
2k views
Two-step Replication between SQL 2008 and 2017
I am currently using transactional replication from several SQL 2008 publishers to a central 2014 subscriber/distributor. I need to replicate this data to a 2017 server, which would require a 2017 ...
1
vote
2answers
1k views
Syncing data between onprem and Azure SQL
I have the following
Scenario: an on-premise SQL Server 2008 R2 and an app using it as db. I want to create an Azure SQL database that will be synced (asynchronous replication) with the on-premise ...
0
votes
1answer
113 views
Two-way replication between SQL Server 2005 and SQL Server 2008
We currently have a SQL Server 2008 and SQL Server 2005 participating in one-way transactional replication of a single database.
If possible we would like to set this up as a Two-way replication. ...
2
votes
0answers
31 views
Is sp_stoppublication_snapshot considered a undocumented procedure or is my searching just bad?
I am trying to start and stop the replication snapshot via t-sql. I found sp_startpublication_snapshot, and doing a trace while hitting the stop on the snapshot from inside SSMS I see it calls ...
1
vote
1answer
3k views
Removing replication
I want to remove replication as we are not going to use it further. I want to know what steps should we follow to remove the replication like:
Which jobs to stop
Delete subscription and publisher
......
1
vote
1answer
5k views
MERGE running slowly
I created MERGE statements to transfer differences with a minimal set of required columns from production db into a staging database. The merged tables are planned to be used by different reporting ...
0
votes
2answers
628 views
A way to syncronize data in sql express
I have 2 servers, one with SQL standard and the second one is express.
I wanted to know if there is any tool or any way to synchronized the databases and making it work like replication without the ...
0
votes
0answers
35 views
Would snapshot replication avoid the “repl table shuffle” when making schema changes?
I support an application that sits upon a SQL 2008 database and has an admin tool that allows app admins to do some field customization. This issues an ALTER TABLE command when saved, and since the ...
3
votes
1answer
50 views
Clarification on Database Replication
SQL Server 2008
I have to do database replication which is a new for me.
Goal is have mirror database on servers 2 and 3.
When we set up database replication in the Server 2, 3 from Server # 1, ...
1
vote
0answers
211 views
How to manage old replication issue
Background
We are using SQL Server 2008 and we had a merge replication configured (before i joined the company). After that they stopped using it and the didn't delete it and configured transactional ...
1
vote
0answers
373 views
Unicode character replication MSSQL to MYSQL in Symmetric DS
I'm doing replication from MSSQL to MYSQL using symmetricds and it is working fine.
Now , the problem is:
In the SQL Server table , I have a column defined as NVARCHAR(20) which accepts unicode ...
7
votes
1answer
3k views
Move live SQL Server database to a new server
I have a production server running SQL Server 2008 Web Edition, and it has to keep running 24x7 with almost no down time, and it's the time for us to move to a more advanced server hardware, also it's ...
2
votes
1answer
301 views
How to manually invalidate a pull merge replication snapshot from the publisher
XY Problem background info:
I have a pull replication publisher in which I want to add or alter a index and have those changes be applied to the subscriber.
The solution to that problem I would like ...
1
vote
1answer
2k views
What User Level is needed for Transactional Replication
I've been setting up Transactional Replication between two database servers I have running. My first experiment with setting it up I simply used SA and local Admin account for all of the agents. ...
0
votes
3answers
1k views
Keeping an up to date copy of a SQL Server database on another server [closed]
We outsourced some of our business functions to another company. That company makes use of the same software as we do and we would like to keep a update to date copy of their database on our servers ...
1
vote
0answers
149 views
Why database replication fails when database mirroring is broken?
I'm trying to understand what effect database mirroring can have on replication in SQL Server 2008.
Here is current environment: (don't ask me why it was done this way or to change it)
Server A: SQL ...
1
vote
1answer
614 views
I couldn't see Conflict tables in replication monitor SQL Server 2008 R2 in Merge Replication
I work with merge replication in SQL Server 2008 R2. In the replication monitor I can't see conflict table, I must to see conflict tables in "MSmerge_conflicts_info", please help me.
How to see ...
1
vote
1answer
2k views
Problem Getting Simple Replication to Work in SQL Server 2008/2012
I can't resolve a problem with replication. The publisher/distribution side seems just fine, but when I subscribe and view in the replication monitor I always get this error: "a required privilege is ...
1
vote
2answers
900 views
Deciding on a replication strategy
We have several dozen small-medium (<1Gb) databases on our SQL Server 2008R2 (Standard Edition) server, with one or two more being created every month. The server itself is a fairly well spec'd box ...
3
votes
1answer
7k views
How to generate replication snapshot without locking tables
When I reinitialize subscription and generate new snapshot it locks all tables and makes the database unusable for a very long time (never waited it out).
Is there anyway to do this without locking?
0
votes
0answers
1k views
Subscription fails with Incorrect syntax near '9'
In my Distributor To Subscriber History I get the following error:
Command attempted:
9
(Transaction sequence number: 0x0018E94F0000207A006200000000, Command ID: 59)
Error messages:
Incorrect ...
2
votes
1answer
598 views
sqlcmd returning NUL instead of NULL for tinyint column
sqlcmd -E -d MyDatabase -Q "sp_helpsubscription" -s "," -o file.csv -W -u
Column 23 which is suppose to be a tinyint (subscriber_type) is output as NUL instead of NULL when the value is NULL.
I ...
3
votes
1answer
119 views
Centralized master data shared among other several DBs
I'm researching and investigating about all possible ways to create a master data database for my portfolio of applications.
To give you a quick overview, an example will come in handy:
I want to ...
0
votes
0answers
217 views
Transactional Replication
SQL server 2008 R2.
I have set up transactional replication on 40 tables in a database (other tables don't replicate).
There was an issue in the morning and it is fixed now. I resynchronised the ...
0
votes
2answers
1k views
Having DB Mirroring and Replication together
Can anybody help me understand why do one go combination of Database Mirroring + Replication.
Why can't I just have Database mirroring for high availability of my database. What is the need of ...
1
vote
4answers
258 views
Backup from Server1 and restore it to Server2?
IF we have two Servers installed with SQL Server 2008 instances,
Server1 has three drives C, D and E with 100, 500 and 500 GB respectively
and Server2 has three drives C, D and E with 100, 300 and ...
1
vote
1answer
856 views
SSIS v/s Replication v/s logshipping
I have 2 SQL server instances, on different servers.
One is Production instance and gets lots of reads and writes daily.
Another one is for external applications to use a copy of few of the tables ...
1
vote
1answer
61 views
Moving large database to another drive, how to measure performance before, and setup some type of replication for fast fail back?
Sorry if this is kind of more than question at a time, but here goes.
Running SQL Server 2008 on windows server 2008 as well. We have a large database just over 200gb right now (it holds images of ...
0
votes
2answers
3k views
How to remove orphaned Log Reader Agents from Replication Monitor?
How do I remove the two Log Reader Agents with errors from the Replication Monitor?
As you can see, the job does not exist (Error message produced by right click > Properties on errored Log Agent ...
3
votes
1answer
337 views
Merge replication issue : conflicts with new data
I set up merge replication with SQL Server 2008, I am having issues when creating new data on clients and trying to synchronize with the remote server.
Pulling data from the server works fine. But ...
4
votes
1answer
702 views
SQL Server DR, mirroring or virtualise and mirror
I have a client with a small business server 2008 Premium installation. This obviously includes SQL Server 2008 standard on a separate 2008 server. On the SQL we run several line of business ...
1
vote
1answer
927 views
Replication error: the principal “dbo” does not exist [duplicate]
I have replication set up between two servers. This morning I came in and it was failing. I was getting these errors:
Error messages:
The process could not execute 'sp_replcmds' on 'PSQL3'...
5
votes
2answers
693 views
Updateable Subscriptions: Rows do not match between Publisher and Subscriber
I have transactional replication with updatable subscribers set up in SQL Server 2008. It has 3 subscribers and 1 publisher. I had to setup replication again due to some errors related to the database ...
3
votes
1answer
745 views
Transactional Replication - Snapshot metrics
I have an application that is using Transactional Replication. We are using snapshots to initialize the subscriptions. All publishers and subscribers are using SQL Server 2008.
Due to the way our ...
3
votes
2answers
1k views
Data sharing between client and server two ways
One of my Silverlight applications is running. This Application is using one central database (SQL Server 2008) and three other client databases (SQL Server 2008) in server other locations.
Our ...
1
vote
1answer
3k 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 ...
6
votes
1answer
4k 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.
2
votes
2answers
2k 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
2answers
2k 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 ...
3
votes
1answer
147 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 ...
7
votes
2answers
23k 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 ...
5
votes
1answer
974 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 ...
5
votes
1answer
2k 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 ...
2
votes
0answers
756 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, ...
3
votes
1answer
1k 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
1k 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 ...
