Stack Overflow
Stack Overflow

Questions tagged [log-shipping]

Log shipping is a process in various SQL server implementations that creates periodic log files of your primary database that can be applied to other (secondary) copies of the database. This secondary database can then be used for failover or reporting.

Log shipping is a process in various SQL server implementations that creates periodic log files of your primary database that can be applied to other (secondary) copies of the database. This secondary database can then be used for failover or reporting.

114 questions
1
vote
2 answers

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 setup another read-only slave DB for reporting…
Shahaf
  • 413
  • 5
  • 11
1
vote
0 answers

How to removed crashed node in SQL Server 2012 Log Shipping?

My DR site server crashed and they built a new one with a new IP. I added the new node but I am unable to remove the old one (since it is no longer there). The log shipping to my new node is working fine. Any ideas on how I can remove the…
Kevin T
  • 45
  • 1
  • 7
1
vote
1 answer

log ship wizard in SQL 2012 Std not showing compression option

I cannot find the compression option in the log shipping setting page. the version of the SQL is Microsoft SQL 2012 Std.
user1172579
  • 575
  • 1
  • 7
  • 22
1
vote
0 answers

how to rename a secondary database in log shipping?

I want to rename secondary log shipping database in SQL Server 2008. Can anyone help me how to do this? Thanks in advance
johnwalker10
  • 45
  • 8
1
vote
2 answers

Database Mirroring and Logshipping

I have setup both mirroring and and log shipping on 8 databases of about 10 GB each size on same instance, but now when I want to mirror another database it very long to display the Database Properties page. Any suggestion for this problem.
ABD
1
vote
1 answer

SQL Server 2008 log shipping keeps getting out of sync

I have inherited a SQL Server 2008 live server with a hot swap-able backup server which has transaction logs shipped every 15 minutes from multiple production servers. One of the production servers keeps getting out of sync, when I came it the last…
DotN3TDev
  • 138
  • 9
1
vote
1 answer

Signaling Flume source to stop if the sink unreachable

I'm trying to use Flume to ship my access logs to a Spark cluster. But there're a bunch of limitations that forces me to write a custom application (or a Flume source) to read the log files. What I'm trying to do is to get Flume client to signal…
Emam
  • 620
  • 1
  • 6
  • 12
1
vote
3 answers

Mirroring , Log shipping SQL Server 2005

I am tasked with setting up a disaster recovery for one of our system. The primary server is in FL and the secondary is in Germany. The application is a global application within my company. I am not sure if I should use Log shipping or Mirroring.…
premtemp
  • 11
  • 2
1
vote
1 answer

How do we setup a remote Standby / Read-Only database to accept Log Shipping?

We have two SQL 2008 servers on different networks that will soon have a VPN connecting them. Soon is 2-3 weeks. If that were in place now we could easily setup Transaction Log Shipping (or other method) of keeping the destination (Standby /…
Rick
  • 21
  • 5
1
vote
1 answer

MERGE vs DROP Table and Rebuild Indexes in SQL Server

I have a "log shipped" copy of a database that lives at a third party. Log shipping runs every 15 minutes at which time all connections to the database are dropped. The database is used for reporting purposes. I have decided to pull some of the…
Josh Miller
  • 620
  • 3
  • 11
1
vote
1 answer

Log Shipping vs Replciation Vs Mirroring in SQL server 2012

I have a SQL Server 2012 database which currently used as a transactional database and reporting database. The application reads/writes into the same database and the reports are also generated against the same database. Due to some performance…
Amey
  • 1,216
  • 18
  • 28
1
vote
1 answer

How to copy SQL log shipping files to AWS EC2 instance

I am using SQL Server 2008 R2 and would like to log ship from my local data center SQL instance to a log shipping target SQL Server running in AWS EC2. What is the best way to copy the log ship files from the local SQL Server to the remote EC2…
Pete Lunenfeld
  • 1,557
  • 3
  • 19
  • 32
1
vote
2 answers

Monitoring Log Shipped Databases

I need a consistent way to monitor databases that are read-only log shipped copies of production databases. In the past I have relied on the following methods: Set the job that restores logs to the database kick off another job as its last…
Registered User
  • 8,357
  • 8
  • 49
  • 65
1
vote
1 answer

SQL server 2008 Log shipping Failback

I need to set up log shipping for about 10 databases. The primary server is accessed by our website and the secondary server is a BI server. What I am struggling to figure out at moment is the best way to handle a “failback” situation once a…
MarcoF
  • 205
  • 2
  • 12
1
vote
0 answers

Logstash input as Database

As logstash is a very good shipper tool for real time data from log file,tcp,upd. Like that, i have a requirement to track database insertions values in real time. Mean, if some record are added in DB, it should reflect immeditely to Logstash. How…
raju lama
  • 21
  • 2
1 2
3
4 5 6 7 8