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
0 answers

Log shipping, logs are copied to the second server folder but not uploaded to the database

I am doing log shipping, but the second server is not uploading the logs to the secondary database. I try to get the error but it doesn't reflect any. The jobs run without problems. Any possible solution? Use official Microsoft documentation I would…
Gabriela.
  • 9
  • 1
0
votes
1 answer

The database is already fully recovered. RESTORE DATABASE is terminating abnormally

I've recently inherited the responsibilities of a DBA without the benefit of having any DBA training. We have a database (omitted name for security reasons) that is essentially setup to run in Standby mode to be used as a read-only database for…
Aeden Maddok
  • 1
  • 1
0
votes
0 answers

Log Shipping, secondary server error. Error 5 - Error 3201

I am making the configuration to make a Log Shipping, but when I click ok after filling in all the fields of the necessary configuration, the following error appears: Restoring backup to secondary database error 5, besides a mistake 3201. I already…
Gabriela.
  • 9
  • 1
0
votes
1 answer

Log shipping between 2 SQL server 2008 database servers without opening any ports?

Is it possible to set up Log shipping between 2 SQL server 2008 database servers without opening any ports? One of SQL server is in Data center and another on Local server room and both are connected with internet. we want to enable Log shipping…
Avishkar Meshram
  • 51
  • 1
  • 6
0
votes
0 answers

Is uncompressed transaction log file restore process faster then compressed in SQL SERVER

I am writing process to ship transaction log files from production SQL server to Read Only SQL Server. I am compressing transaction log in source DB, coping file to destination and restoring into Read Only instance. I do this in hourly…
Otar Melia
  • 1
  • 1
  • 1
0
votes
0 answers

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 primary DB. I have tried to research this before just…
Franco
  • 1
0
votes
0 answers

Log shipping restore job failing after a couple successful runs

I have log shipping on several databases that are working good and I have three that fail. They are all going from the same primary to the same secondary. I have mimicked the settings of the working databases to the nonworking databases. I resetup…
Ed Hall
  • 1
  • 2
0
votes
0 answers

Error in Restoring backup to secondary database using log shipping

I'm trying log shipping between two SQL VMs. The backup is getting generated properly but its not getting restore on secondary database. The error says that the restore job is not able to open the .bak file of the database. Below are the error…
Ankita Potdar
  • 67
  • 1
  • 9
0
votes
1 answer

Restoring the secondary server in log shipping

I am currently setting up log shipping for a client and have a question. The process of setting up the log shipping is pretty straight forward but I do not see much information about failing over to that secondary server event of DR. The secondary…
jdrpepper79
  • 1
0
votes
1 answer

Logstash XML file parsing - awkward event Splitting Problem on Conf Reload

I'm working with ELK 6.7.0 on docker with official images. This is my conf file: input { file { path => "/usr/share/logstash/logs/*.xml" type => "xml" sincedb_path => "/dev/null" codec => multiline { pattern => "" …
wizard
  • 583
  • 2
  • 9
  • 26
0
votes
1 answer

Log shipping a large database

I have Question on log shipping: I am migrating a VLDB (12TB) SQL database from a physical environment (server A) to virtual environment (server B), and from version SQL 2008 R2 to SQL 2014. The high-level plan for migration is to log ship from…
salty2468
  • 1
0
votes
1 answer

SQL Server 2016 reset recovery mode from 'Full' to 'Simple'

Can anyone help me diagnose why this may have happened? We've got log shipping configured and so the database is in 'Full' recovery mode. This has been working fine for ages, and then randomly it seems to have been reset to 'Simple' recovery, which…
Jordan Wallwork
  • 3,116
  • 2
  • 24
  • 49
0
votes
2 answers

Temporal Tables and Log shipping

We are building a system in our company which will need temporal tables in sql server and might need log shipping as well. I wanted to know if there are any unexpected impacts of log shipping on a temporal table that wouldn't happen on a normal…
Waleed Ahmad
  • 1
0
votes
1 answer

Any impact of changing SQL Server log shipping restore job schedule

On the SQL Server log shipping secondary database server, I have 2 jobs LS_Copy and LS_Restore. Current schedule: both jobs run every 30 minutes (all day) New schedule: I want to change the restore job to run every 30 minutes between 10:00 AM to…
Rahul Khanna
  • 137
  • 2
  • 8
0
votes
2 answers

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 that is, if my slave server becomes unavailable,…
Amir Masoud Mostofinejad
  • 23
  • 5
1 2 3 4
5
6 7 8