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
0
votes
1 answer

sql log shipping

Our log shipping routine failed and was 3 days out of date, so I manually restored the transaction log from the primary database into the secondary database. The database seemed to restore all ok but now the secondary database is not showing as…
user2859298
  • 1,373
  • 3
  • 13
  • 28
0
votes
0 answers

Why my Log Shipping not break due to LSN mismatch?

I configured log shipping from SQL Server 2008R2 to 2012 Server, secondary Server database recovery state is restoring and log shipping works good. One day I take log backup manually through query ‘backup log db name to disk=’path.trn’ As per role…
Jason Clark
  • 1,307
  • 6
  • 26
  • 51
0
votes
1 answer

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 stop logs backup job, clean up data in Primary and…
VV01K
  • 21
  • 3
0
votes
1 answer

SQL log shipping restore failed and index performance stats, capture stats

Please help me here, WE have production SQL server 2008 R2 having database MicrosoftDynamicsAX database, on which I have tried to configure log shipping twice. but failed twice, Upon configuration, The backup job on Primary Runs fine every 15…
Rams_v
  • 35
  • 4
0
votes
1 answer

SQL Server log shipping out of sync error

I have SQL Server 2008 R2, configured for log shipping. But backup, copy, restore are successful. But alert at primary and monitor instance say, out of sync error 14421. I have schedule of 15 min set for all 3 jobs. and alert set for 3times=45…
Rams_v
  • 35
  • 4
0
votes
1 answer

Log Shipping Transaction Log Backup Job runs continuously

As part of our DR solution, we have attempted to enable log shipping for a heavy transaction load database. While the configuration completes successfully, the first transaction log backup job to kick off after the completion of the log shipping…
Kim
  • 1
  • 1
0
votes
2 answers

Change the secondary database into normal mode

Is it possible to change the secondary database from warm standby/read only to normal mode? Will it stop the logshipping?
user3709209
  • 61
  • 2
  • 10
0
votes
1 answer

What happens on the primary when log cannot be restored on the secondary on Log Shipping

I would like to setup a log shipping but I have a concern as to what would happen if the restore operation on the secondary would fail for some reason. I want the primary database keep working no matter what happens on the secondary database - even…
Stackoverflowuser
  • 203
  • 3
  • 12
0
votes
1 answer

log shipping replication in one machine

We have install postgresql version 9.3 in ubuntu. We want to ask is it possible to do log shipping replication in one machine with different port? We also tried that process in one machine but still get an error in slave such as warning :…
Najwa
  • 21
  • 4
0
votes
2 answers

sql server tlogs backup

my scenario is that i had log shipping configured between two sql servers and because of an issue the restore stopped few days back. Since the retention period has already expired and the purge job has already deleted the logs from the primary…
user8189
  • 79
  • 1
  • 10
0
votes
1 answer

sql server log shipping space consumption

I have implemented sql server logs shipping from hq to dr server The secondary databases are in standby mode . The issue is that after configuring it , my dr server is running out of space very rapidly I have checked the log shipping folders where…
user8189
  • 79
  • 1
  • 10
0
votes
2 answers

Logs guaranteed delivery using Logstash/Redis in shipper node

What do you think folks, about placing Redis in each Logstash shipper node to ensure a guaranteed logs delivery?
Ben
  • 69
  • 1
  • 5
0
votes
1 answer

Configuring Log Shipping For Multiple Server

Can any body explain quick way to configure logshipping for 50 databases on multiple servers?. I know how to configure log shipping but i want the quickest way to configure log shipping say for 50 databases on multiple server? Can any one provide me…
prags
  • 17
  • 2
  • 6
0
votes
1 answer

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 from production sql instance. At the moment we have…
come2searcher72
  • 1
  • 1
  • 1
0
votes
4 answers

Postgres HA (based on WAL-shipping) fails

I'm hoping someone can help me a WAL-shipping and warm standby issue. My standby system runs happily for weeks, then all of a sudden it starts looking for .history files that don't exist. It then craps out and I can't successfully restart it without…
sbleon
  • 1,685
  • 2
  • 13
  • 20
1 2 3 4 5 6
7
8