Questions tagged [log-shipping]

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

67 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
0answers
31 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
1answer
1k 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
1answer
738 views

Log Shipping always fails, after a while

I have a problem with Transaction Log Shipping on the SQL Server 2014 edition. I have to log ship 4 databases, 2 of them are fine and the other 2 ALWAYS fail but not at first. When it fails, SQL ...
3
votes
0answers
219 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
145 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
358 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 ...
2
votes
0answers
86 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
2answers
390 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 ...
2
votes
0answers
751 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
534 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
147 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
104 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
396 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
245 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 ...
2
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 ...
1
vote
0answers
25 views

Can we change Log Shipping backup file naming convention

Seems the Log Shipping backup files naming convention (especially the date-time stamp in the name) is followed by UTC time, i believe that is default and standard. I would like to clarify on ...
1
vote
0answers
69 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
234 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
42 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
143 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
64 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
29 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
109 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
1answer
83 views

SQL server log shipping - dry-run data modification script on secondary then resume log shipping

Am log shipping a large, busy DB from server A (primary) to server B (secondary). Nightly backups are taken, as well as diffs every X hours, and transaction logs are shipped and restored every 15 ...
1
vote
0answers
269 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
270 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
1answer
108 views

Transaction log rollback broke Log Shipping chain?

Is it correct that performing a transaction log restore to a previous point in time will break the log shipping chain? If this is correct, is there a way to recover from this situation without having ...
1
vote
0answers
361 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
0answers
36 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
24 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
47 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
76 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
117 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
129 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

What is the simplest method to get a Readable Copy of the database, one having more historic data

I am hoping to get some input as to what the best replication method/tool would be for my situation. I have to make a new system and the business needs are as follows : They need to have access to ...
0
votes
0answers
11 views

Elastic search data synchronization with different databases

We are using elastic search hosted in AWS for apps wide search in our organization. We had initially dumped our existing data using logstash. However, we are struck at keeping the Elastic DB in sync ...
0
votes
0answers
17 views

Resetting log shipping after a dry run?

I'm in a unique situation and trying to figure out how to "reset" log shipping back to 2 secondaries after a dry run of a migration. A little background is needed to explain more. I am practicing a ...
0
votes
0answers
24 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
25 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
18 views

Log Shipping and Transactional Replication

Is it possible to have a Log Shipping Secondary database be a publication database for transactional replication? In my research I discovered the the database for log shipping has to stay in no ...
0
votes
0answers
84 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
98 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 ...
0
votes
1answer
26 views

“Pausing” log shipping to allow normal DB use. Is this process valid?

I am in the process of migrating a server to AWS. Right now it is just for Dev/QA work, but will eventually be turned into our production server. It is a 2 node AG. Server is all up and running, ...
0
votes
1answer
56 views

Adding another Secondary Log Shipping location

I've seen a few variations of this question, but no clear cut answers to my situation. I have an existing log shipping setup, and want to add a secondary server. Here is how I understand what will ...
0
votes
0answers
145 views

When restoring logs in log shipping, when does the restoring stop

We are using LS for reporting purpose. LS backup runs on primary every 15 minutes. On Secondary nightly restore via LS restore job is done daily at 10 PM. While the nightly restore job is running, ...
0
votes
1answer
271 views

Email SSMS Log Shipping Status Report

We use Log Shipping to allow Business Analysis users to query data. I would like to email the Log Shipping Status report to users to see last time data is refreshed. When I Right Click on Server--&...
0
votes
0answers
21 views

Log Shipping - Determining Rows Modified After a Restore

The company I'm doing some work for is using log shipping to sync a production database with a secondary. Is there any way I can determine the rows that were inserted, updated or deleted after a ...