Questions tagged [log-shipping]

Transferring log records from a source database system to one or more destination systems.

69 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
0answers
68 views

Can Azure Backup Server backup databases participating in Log Shipping?

We have a number of log-shipped SQL 2017 databases which we wish to start backing up using Microsoft Azure Backup Server (locally and to the cloud) on a 15 minute schedule. Does anyone know if it is ...
3
votes
2answers
689 views

Log Shipping Copy Job Fails once in a while

I have configured log shipping at multiple database server with monitored server(separate server) and all of them are running fine without any issues. One particular server has 7 database and the ...
3
votes
1answer
2k views

How to fix an odd LSBackup job error in Log Shipping?

Configuration: LSPrimary01 - Log Shipping Primary LSSecondary01 - Log Shipping Secondary OddServer03 - This server is not part of the LS configuration, the odd man out Sean\LSServiceAccount - The ...
3
votes
0answers
271 views

VSS Writer : RESTORE VERIFYONLY FROM VIRTUAL_DEVICE breaks log shipping

Log shipping has been working for a very long time, but now and then it breaks. I found it sometimes breaks (causes the transaction log to become corrupt and I get the message : "media family on ...
3
votes
0answers
147 views

Need a way to prevent log shipping from kicking users out

We have SQL Server 2012. A service we use requires us to use log shipping, however we are tired of having users being kicked offline every 15 minutes. Are there any creative ways to get around this (...
3
votes
0answers
374 views

How to copy SQL Server 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 Server instance to a log shipping target SQL Server running in AWS EC2. What is the best way to copy the log ...
3
votes
0answers
1k views

SQL Server Database Hot Backups: Which Technique(s) to Use for Multi-Level Replication?

I'm reading the many other posts here about mirroring vs. replication, but I'd still appreciate it if someone with some experience would weigh in. My small development team needs to have local ...
3
votes
1answer
5k views

Issues with Log Shipping

First time at posting a question on here, so please bear with me and I'll try and detail all the information. Currently, I'm log shipping from SQL 2012 Standard Edition (11.0.3000) (lets call it ...
2
votes
0answers
141 views

How can I safely kill this spid that is running on the master database?

I have a secondary logshipping database that is blocked by a pending restore. There is no process (spid) on this database itself, but I found a spid related to this database, that runs on the master ...
2
votes
0answers
774 views

Log Shipping and Ola's Hallengren's Scripts - Can they work in unison?

I have a single instance database server with several databases. Some do not require log shipping and some do require log shipping. Is there a way to edit Ola's LOG backup job to ignore the ...
2
votes
0answers
640 views

SQL Server Log Shipping: Does the native log shipping support encryption of the tlog backup?

SQL Server 2014 Std Edition We use the built in SQL Server encryption for our db backups (sql server backup to disk) -- works great. We would like to implement encryption for the tlog backups (which ...
2
votes
0answers
155 views

LOG BACKUP is TRUNCATING in Log Shipping

I had configured Log shipping from INSTANCE1 to INSTANCE2. For the past few days, am able to find that the log backup is truncating only at the midnight. Due to this, LSRestore Job in INSTANCE2 got ...
2
votes
0answers
1k views

What does 'Could not find a log backup file that could be applied' means on log shipping?

Skipped Log Backup File ..... Could not find a log backup file that could be applied to secondary Database What does this mean? I've configured a log shipping. To test, I created 2 tables, put ...
2
votes
0answers
108 views

SQL Server 2014 Log shipping - column error

I'm trying to set up log shipping between two instances of SQL Server 2014 Dev edition. Backup and copy jobs work flawless, but the restore one keep failing with the following error: An error ...
2
votes
0answers
423 views

Log shipping restore delay of a minute between iterations

On a test database running Log Shipping jobs the initial Restores to catch up performed the first time I run the Restore job seem to have a 1 minute or so Wait time built in. I would have expected ...
2
votes
0answers
248 views

Can the same database be log-shipping secondary and primary at the same time?

Here is my scenario: Database DB1 on Server1 is log shipping primary in data center. Database DB1 on Server2 is log shipping secondary; Server2 is in remote location. Logs are shipped from data ...
1
vote
0answers
123 views

Log Shipping restore job failed, DBNAME is not in NORECOVERY/STANDBY mode

My log shipping job stopped suddenly. I'm getting this error: 2020-04-17 14:46:36.42 ----- START OF TRANSACTION LOG RESTORE ----- 2020-04-17 14:46:36.53 Starting transaction log restore. ...
1
vote
0answers
137 views

Cross Domain log shipping not working

I know there are many blog posts similar to this, and I have read them all and as far as I can tell things are setup correctly, but I still get invalid username or password when kicking off the copy ...
1
vote
1answer
373 views

Log Shipping Backup grey in Transaction Log Shipping Status

I have slow network that makes configure log shipping via GUI always timeout, so I generate script and run it in both primary server and secondary server. The scripts work fine but the primary ...
1
vote
0answers
59 views

Log shipping 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 ...
1
vote
0answers
244 views

Log Shipping with minimum synchronization gap

We will have an application that will go live soon. I will be using Log Shipping for Disaster Recovery but I am confused about the Job scheduling. The transaction logs will be taken every 10 minutes ...
1
vote
0answers
72 views

Spin up an extra sql azure instance to reorganize/rebuild indexes with no downtime

We have a pretty large sql azure database, over 300GB. Many tables have been altered over time and we would like to create fresh indexes, including clustered ones. Of course we would like to minimize ...
1
vote
1answer
30 views

Publication shows up in secondary server

I have created log shipping and the primary server is also used for transactional replication. Now after creating log shipping I have noticed the publisher shows up on the secondary and it wont let ...
1
vote
0answers
119 views

Log Shipping Job Failed

I have a transaction log shipping configured. Job activity monitor shows that both Copy and Restore steps have failed, however, I see that backup files are in fact copied across to the secondary ...
1
vote
0answers
310 views

A transactional log backup could not be generated because database is in either NORECOVERY mode or STANDBY mode

We have configured Always on Group Database with Full Recovery mode and secondary replica is in sync mode with primary server.Now we have configured logshipping in primary server to supply t-log ...
1
vote
0answers
300 views

Log shipping jobs are not executing

I have configured log shipping between instances, everything was working fine, but recently I have noticed that time on my secondary server differs from time on primary server. I changed time ...
1
vote
0answers
375 views

SQL Server 2012 - log shipping issue

I'm sort of new to SQL Server so bear if the doubts are silly. I have configured log shipping for my DR purpose. SQL Server 2012 is the version. Today I encountered the following error in my log ...
1
vote
1answer
39 views

Is log shipping good for periodic synchronization?

I have Postgresql 9.3 server on both my laptop and my desktop at home. I keep identical data on both system. Sometimes I work on the database on my laptop while other times I work on the database on ...
1
vote
0answers
2k views

What Open Ports are Necessary for SQL Server Log Shipping to Secondary on the Internet

Our secondary server will be on the other end of an always on IPSEC tunnel. We need to instruct our customer's firewall/VPN/Server team (they are responsible for the primary). What I've gathered so ...
1
vote
0answers
25 views

Log Shipping causes high context switches

MSSQL - I have setup log shipping on many databases being sent to 2 different servers in NORECOVERY mode. This is causing crazy context switches on the main server. Is this normal? 16 Cores without ...
1
vote
0answers
48 views

Log shipped database server user SID is created automatically

We have a production server "prod" which has a user say 'test' that lets the users connect to the application and a logon trigger which stops them from connecting to the server through SSMS. I ...
1
vote
0answers
96 views

Please explain log-shipping delta

I am trying to understand how Delta is monitored in log-shipping. We have log-shipping monitoring in place and I am seeing delta increases sometimes for random instances and it drops once database is ...
1
vote
0answers
120 views

Resuming log shipping, do I just restore the db over itself?

I have log shipping set up. I then bring all the databases online on the secondary machine, so log shipping can't restore anymore. A bit later on I want to resume log shipping. I was told before ...
1
vote
0answers
137 views

Log Shipping Monitor Stored Procedure returning Null

I have log shipping setup. When I EXEC sp_log_shipping _monitor it returns all null values even though log shipping appears to be working fine. last_restored_file NULL last_copied_file NULL
0
votes
0answers
22 views

SQL Server performance issue (Log Shipping became slow)

I'm facing the problem that MS SQL Server 2016 suddenly become slow. For example, restore log process (log shipping). I can see LASTWAITTYPE is PAGEIOLATCH_EX in SYSPROCESSES table during the process. ...
0
votes
0answers
25 views

SQl Server log shipping monitor security configuration and update problems

I'm setting up log shipping between instances A and B with the instance C as a monitor. The shipping itself is working fine but I'm somehow unable to make the monitoring work. The log shipping status ...
0
votes
1answer
46 views

log shipping error

i have several databases log shipped from primary to secondary servers. most work fine however i have one that fails after 1 or 2 cycles. log shipping is on a 15 min schedule. i have been trying to ...
0
votes
0answers
44 views

In SSIS, how to force an open connection to to SQL Server while package is executing (hint: its not retainsameconnection=true)

We have an SSIS package with an OLE DB connection to a SQL Server database. The database restores every 15 min from log shipping unless a connection is open. When the SSIS package runs (takes ...
0
votes
1answer
33 views

how to failover in log shipping?

I am reading the book 'Pro SQL Server 2019 Administration' from Carter, where in the Log shipping section he mentions: "Unlike other high availability and disaster recovery technologies, an ...
0
votes
0answers
10 views

Can't recover old master Postgresql using pg_rewind

I have 2 Postgresql-12 DB, db01 and db02. we synchronise master db01 with slave db02 using wal shipping logs. We had issue on filesystem of db01 and we hade te restaure the VM image. The issue ...
0
votes
0answers
21 views

What can cause log shipping copy step to occasionally fail with access denied?

Have sql agent job for log shipping copy step that fails every once in a while with "Reason: access is denied" but no other detail. Here is what the failing step looks like: "C:\Program ...
0
votes
1answer
40 views

SQL server Log Shipping

I have two node SQL server standard failover cluster. I need to setup single node DR using log Shipping method. Want to ask after switch over to DR how we can setup, plan so that application can ...
0
votes
0answers
17 views

Log Shipping Monitor Server Miss match

I'm receiving an LSAlert that my log ship database hasn't been updated. During digging I found that the log_shipping_primary_secondaries references the proper name of the secondary server, while ...
0
votes
1answer
65 views

Can I change database compatibility level from 80 to 90 or higher with log shipping?

I have a database on SQL 2008 R2 with compatibility level 80 and I want to change it to 90 or 100. I assumed that after changing, I may find a regression in our application's performance. Many backups ...
0
votes
1answer
56 views

what is the impact of changing log shipping schedule timing jobs?

I have two severs primary and secondary log shipped server , after configuring it, I noticed that the latency of last copied file and last restored file increased and the alert of monitor sever fired ...
0
votes
0answers
67 views

WAL Archival not working in PostgreSQL V9.4.9 DB server

Our DB servers are on VM, during planned server restart for system patch deployment our Master DB server crashed. We have taken the clone of Primary Slave VM and restore the Master DB using last ...
0
votes
0answers
31 views

Log shipping - Secondary Server

I am not a SQL Server DBA but I need some advise. I am having a problem with a prod server that’s being pounded by constant queries and data mining. I have a second server that I would like to setup ...
0
votes
1answer
54 views

How to calculate quantity of WAL in db without archiving?

I would like to find out a quantity of WAL files which are being used in PostgreSQL database in last 24h. I was assigned to do Log-shipping but before I do it I want to know how many WAL files are ...
0
votes
0answers
107 views

Differences Between Setting Up Transaction Log Shipping through Wizard vs Scripts

There appears to be a fairly significant difference after setting up transaction log shipping (in Standby/ Read-Only mode) through the SSMS wizard, which generates jobs that then call on outside .exe ...
0
votes
1answer
243 views

Restarting primary SQL Server instance with log shipping

I have configured log shipping with 20 minutes for backup, copy and restore. If i need to restart my primary server. do I need to stop all jobs (backup, copy and restore)? Please advise. Regards ...