All Questions
Tagged with log-shipping replication
9 questions
0
votes
0
answers
19
views
Can you SQL replicate tables from a logged-shipped secondary DB to a separate third DB?
Can you SQL replicate tables from a logged-shipped secondary DB to a separate third DB?
The idea is to offload some long running scripts from those tables, and if possible avoiding touching the ...
- 1
0
votes
2
answers
156
views
Does my master server crash using Log-Shipping Synchronous Replication in Postgresql when the replica is down?
I'm searching for HA solutions without load balancing in the master-slave model, using postgresql. My favorite solution so far is log shipping synchronous replication. But I have one main concern, and ...
0
votes
1
answer
412
views
SQL to SQL data replication
I have a 300 GB MSSQL 2016 production database on a server and i will need to make a copy of this database on another server for reporting purposes.
On the production database, there are normal ...
- 304
0
votes
1
answer
600
views
SQL Server log shipping : any way to skip some transactions without breaking LSN?
I was able to set up log shipping from Primary to Secondary database. I need then to cleanup some old data from Primary database but I need that data in Secondary for reporting.
So my idea was to ...
- 21
1
vote
1
answer
2k
views
SQL Server full copy of database for read operations
Please advise what suits my problem better. I have a highload web app hosted on the same server where SQL server is hosted. I also have SQL Service reporting running on the same server, generating ...
- 4,652
0
votes
2
answers
1k
views
Mix transactional replication and log shipping?
I've replicated a large database (close to 1TB) to three remote servers using pushing transactional replication. The subscribers are read-only. A lot of data is inserted and updated (from other ...
- 29.1k
1
vote
2
answers
4k
views
PostgreSQL - using log shipping to incrementally update a remote read-only slave
My company's website uses a PostgreSQL database. In our data center we have a master DB and a few read-only slave DB's, and we use Londiste for continuous replication between them.
I would like to ...
- 443
5
votes
1
answer
1k
views
Help on choosing which SQL Server 2008 scale-out solution to pick (replication, ...)
I am currently crossing the jungle of SQL Server scale-out technologies like replication, log-shipping, mirroring... I have the following constraints on my choice:
I want the read-only load to be ...
- 171k
4
votes
4
answers
575
views
Backing up SQL Database for Reports
I'm looking for some help/suggestions for backing up two large databases to one server dedicated to reports. The situation is;
My company has two databases for its internal website. One for the UK ...
- 107