Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-replication]

104 questions
0
votes
2 answers

SQL Server 2008 R2 Replication log reader could not execute sp_replcmds

This log reader agent worked perfectly for several months until the user referenced in the error was removed from the domain. After that time the error 'The process could not execute 'sp_replcmds' on 'SERVER'' was received with more detail 'Could…
user49352
  • 123
  • 2
  • 4
  • 12
0
votes
2 answers

Fault tolerant DBMail with PostgreSQL Replication - what are my options here?

I'm currently planning a more fault tolerant setup for my organizations Mail setup. We currently have two machines available in different datacenters, that we're planning to use for this, one being a physical host, the other being an lxc "VM". The…
juwi
  • 573
  • 1
  • 5
  • 14
0
votes
1 answer

Server mirroring strategy questions SQL Server replication, MySQL replication, file replication, etc

I'm working as an application developer for a company that I've been with for for some time. The business would like to mirror their existing windows server (server A) to a new server (server B) with the main aim of providing redundancy where either…
gbro3n
  • 259
  • 4
  • 14
0
votes
1 answer

MS SQL New Publication Wizard - Unable to connect to server 'Server Name'

I am trying to create a new publication. SQL Standard 2008 windows 2008 r2. I am logged into the sql server management studio on the server that sql is installed. I have logged into the sql server using the computer name. I right click on local…
ChickenFur
  • 479
  • 2
  • 5
  • 15
0
votes
1 answer

Replication on system databases

Is it possible to replicate system databases? I only ask because I had an issue previously (described here) that appeared to be impossible but has come back up again this week. This time TempDB log was growing quickly and according to…
Ddono25
  • 165
  • 3
  • 13
0
votes
2 answers

How to keep Ms-SQL database always UP: mirroring or replicationg?

I have several Tb databases in the Windows Server 2008. I would like to keep alive the service when the server is failing or the raids are needs to be rebuild. Which model to choose Replication or Mirroring? And how to setup that the alive server…
Arman
  • 575
  • 2
  • 8
  • 18
0
votes
2 answers

What server hardware are people using for replicated mongodb servers?

Since mongodb, couchdb are for horizontal scaling and have inbuilt support for replication, what hardware is being used for them ? Specifically looking for hardware for replicable mongodb instances. Server models etc. would really help. Adding…
PlanetUnknown
  • 149
  • 1
  • 7
0
votes
2 answers

Replication keeps popping up on SharePoint databases

My typical discovery scenario: We receive an alert that the transaction log is growing quickly. We are in Simple Recovery so I go to check it out. Log is already sized to 100GB and is at 80% capacity. I run the "Whats using my log files" script…
Ddono25
  • 165
  • 3
  • 13
0
votes
1 answer

What is the best of two approaches to achieve DB Replication?

we have two approaches to achieve DB Replication: Master-Master replication. Master, 1 Primary Slave, 1 Secondary slave. I am planning to analyze these two approaches and prepare a comparison report with a recommendation.Currently, I have setup…
vijay.shad
  • 129
  • 2
  • 6
0
votes
1 answer

Performance lag for database replication

My company is really sensitive about keeping up the performance on our core system. Our users also have a requirement to replicate or mirror all data to another location (in another location within city limits) in case a disaster happens. A software…
Ludwi
  • 293
  • 1
  • 7
0
votes
3 answers

synchronize 2 mysql servers (all databases + users)

We want to sync 2 mysql servers with eachother (products & qa system). We would like to sync all databases, data and users of the production machine to a secondary mysql machine. What would be the easiest and best way to do this…
solsol
  • 1,121
  • 8
  • 21
  • 31
0
votes
3 answers

What would cause SQL 2008 Log Reader Agent to fail with "This process could not execute 'sp_replcmds' "?

I've seen this error message in other posts. They didn't seem to help resolving our issue. We are trying this with two SQL Server 2008 servers. I backed up my database from the source server and then restored it on our destination server. We setup…
Rick
  • 45
  • 3
  • 7
0
votes
0 answers

What is the efficient way to copy large database from one server to another?

I have a SQL server's full database backup job that runs daily at night. Currently, I need to stay up late every night to copy that backup file (around 300GB in size) to 5 servers in different locations over the Internet via FTP. I use FileZilla but…
Parkeralex
  • 1
  • 1
0
votes
1 answer

Real time synchronization of databases with different data structure

I'm rewriting a legacy web application. At some point in time, I want old and new app, to work in parallel, on databases with different structure (both mysql). The troublesome part is that the databases needs to be synchronized, preferably in real…
Maarduk
  • 133
  • 6
0
votes
1 answer

Can Oracle GoldenGate work between different version of Oracle

Can we use Oracle GoldenGate to sync data between different versions of Oracle ? Our source database is 11.2.0.4 and target is 19.0.0.0
oradbanj
  • 161
  • 1
  • 1
  • 6
1 2 3 4 5
6
7