Questions tagged [log-shipping]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
81 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 ...
0
votes
1answer
74 views

In what order does sqllogship.exe process groups of log files?

In what order does sqllogship.exe processes groups of log files based solely on filename order or does it does it do it based on file timestamp primary sort then filename secondary sort? It appears ...
0
votes
1answer
195 views

LogShipping replicated database

We use transaction replication to replicate our production database to another server(server 1) for reporting purpose. For a standby copy, we also logship the main database to another server (server 2)...
0
votes
1answer
132 views

Log Shipping Server Restart Problem

I have Log Shipping setup from Primary Server A to Destination B. Server B is both Destination and Monitoring server. Yesterday, we restarted both servers around the same time for patching. On the Log ...
-2
votes
0answers
40 views

How do I put a database in Standby / Read Only mode? [duplicate]

I have a database that I accidentally took out of Standby / Read only mode. It was part of a log shipping across SFTP. Now I can't apply more logs to it. Do you know how to get it back into a ...
0
votes
2answers
403 views

Log Shipping failover when Primary is not accessible

Log Shipping Fail-over I have set up log Shipping with Cluster. In this scenario I want to simulate a situation when the whole cluster becomes inaccessible. My Steps for fail-over will be Copy and ...
0
votes
1answer
44 views

In SQL server during Log Shippping which portion (active\Inactive) of the Log file (.ldf) backup is taken and further restored in SQL Server [closed]

I am confused, like if we take the backup of the whole log file, wont it clear the transaction log though we have copy only backup. In log file we have 2 parts, like active and inactive logs, in ...
0
votes
1answer
96 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
451 views

SQL Server Log Shipping restore fail - The Log Is too recent to apply

The restore is missing a backup log, and the "physical_device_name" of the missing backup log is "NUL". This is a Transaction Log that gets made out of sequence with the log shipping backup job. I can'...
2
votes
1answer
29 views

Why are my Log Ship Jobs Blocking Each Other

I have 5 databases at a DR site all being log shipped to once a minute using the built in SQL Server log ship jobs. The server is running SQL Server 2017. For the last week the log shipping keeps ...
7
votes
1answer
10k views

Creating Users on secondary server in log shipping

I have a production Server say ServerA I have setup log shipping to ServerB which is left in read-only mode. The purpose of this log shipping is to lower the load on production server for some ...
0
votes
1answer
460 views

Strange Log Shipping Error Message

Environment and Server Details: 12.0.4457 Windows Server 2012 R2 standard VMWare Virtual Machine Dell Equal Logic SAN SQL Error Log Message: The log shipping secondary database ServerName....
1
vote
1answer
233 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 ...
0
votes
3answers
973 views

Does MSSQL Log shipping truncate the transaction log?

I have setup log shipping on a database in Microsoft SQL Server 2012. I was having issues with my secondary server and I found that this was probably due to a scheduled backup job messing up the log ...
3
votes
1answer
737 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 ...
0
votes
1answer
40 views

SQL Server Log Shipping for Server Migration - What's the final step?

Working with a server running SQL Server that was the log shipping target for two other servers as part of server consolidation/migration. In other words, server B was log shipping to server A and ...
2
votes
2answers
389 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 ...
0
votes
1answer
25 views

Does this plan work as a Failover strategy-SQL Server 2016 Standard Edition

We have two SQL Server 2016 Standard edition (standard edition due to budget issues) configured one as primary sql server and another one as fail-over server. I have implemented Transactional ...
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 ...
0
votes
1answer
1k views

Configuring log shipping with one primary and two secondary instances

I have three SQL Server instances (SQLInstance-1, SQLInstance-2, and SQLInstance-3).I want configure three (or more) servers: SQLServer-1 – primary SQLServer-2 – secondary SQLServer-3 – secondary I ...
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 ...
0
votes
1answer
269 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--&...
1
vote
1answer
208 views

Tail log backup query in log shipping reversal

I am doing log shipping failover and failback configuration in SQL Server 2008 R2 environment. During the Failover, I am taking the tail log backup of primary database with query: Script to backup ...
4
votes
0answers
30 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 ...
1
vote
1answer
201 views

SQL Server best option for low-cost high-availability and queryable secondary?

We have a heavily used database server (SQL 2012 Web edition) which is currently a single point of failure (nightly backups and no additional hardware provisioned!) The server has a constant stream ...
2
votes
2answers
58 views

Using SQL Server 2017, can log backups be safely taken on primary when using Log Shipping or Availability Groups?

We have a CommVault server taking log 15-minutely log backups of our primary (on-premise) DBs (combined with full nightlies), for point-in-time restores. We want to enable high availability for DR ...
2
votes
2answers
340 views

Slow select Queries on Log shipping standby server

We have a database in primary DC around 15 TB with partitioned tables with largest one around 7 TB. To avoid users from reporting a LS set up was done for above database in different DC where the LS ...
0
votes
0answers
235 views

sqlserver lsalert job does not update it's out-of-sync counter

I am getting 14421 error messages and ended up reading the following KB Here is the part I'm referring to : Problems either with the Backup job or Copy job are most likely to result in "out of ...
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
1answer
33 views

Log shipping backup

I m confused with backup for log shipping,by taking full backup(not copy- only) in primary ,does it affect the log backup LSN chain and cause log shipping not to work? If it does not affect LSN chain, ...
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 ...
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 ...
1
vote
1answer
68 views

Restoring .trn files on a regular basis to a backed-up database

We have been given a .bak file of a database from our vendor on a completely different network. They are placing their .trn files every 15 minutes on a sftp for us to pickup and write to the .bak file ...
3
votes
2answers
1k views

Unexplained log ship slow down

I have a number of SQL 2008 instances all running Microsoft SQL Server 2008 (SP4) (confirmed with select @@VERSION on the servers in question). They run on either Windows Server 2008 or Windows ...
3
votes
1answer
1k views

log shipping backup fails every so often on only one server

I was asked to change the DFS share for our log shipping on all our SQL servers (SQL 2008 on windows 2008) to point to the new share due to some IO issues on the previous one. But now, ocassionally, ...
1
vote
1answer
34 views

Log Shipping between 2 AGs

I'm having one AG with two nodes (active-passive) in one data center and another AG with two nodes (active-passive) in a different data center. I need to have log shipping enabled between these two ...
2
votes
1answer
115 views

Log Shipping and Daily Backup

My SQL Server 2012 DR setup is a mess. We've had a maintenance plan in place from the beginning that takes a daily full backup, with hourly log backups. Recently, we set up log shipping to an off-site ...
1
vote
1answer
73 views

Log shipping always failing with NUL

I have configured a log shipping for our company's primary database to restore on a separate server, with the restored database serving as report database. The problem is that every few days, the log ...
2
votes
2answers
83 views

Failover strategy for SQL Server 2016 Standard Edition

I am using SQL Server 2016 Standard Edition. I have two database servers, SQL01 and SQL02 with only one database, and I am utilizing transactional replication for bringing data from SQL01 to SQL02. ...
1
vote
2answers
214 views

Log Shipping Alternative [closed]

In our current environment we have about 40 databases on one instance all being log shipped and configured as Standby/Read Only. About 90% of those are for reporting purposes and others for read only. ...
0
votes
1answer
88 views

How to succesfully set up sp_AllNightLog to create a Reporting Server?

I would like to set up a secondary, mirrored SQL Server for reporting purposes. The reporting database doesn't have to be up to date with the primary and can generally lag behind the production ...
0
votes
2answers
45 views

Accumulated logs - Log shipping SQL Server

If I have a log shipping scenario where a report runs for 30 minutes and the log shipping is set up for not killing the connection, and because of that, the restore will fail, the question is if all ...
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 ...
1
vote
1answer
44 views

Setting up sp_AllNightLog using Azure Blob Storage [closed]

Has anyone setup Brent Ozar's sp_AllNightLog using Azure Blob Storage? Trying to start incorporating both but not sure of the steps or how to get started. Any tips or links to similar operations?
1
vote
0answers
67 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 ...
-2
votes
1answer
173 views

Can I use log shipping between different editions of SQL Server 2016?

Will log shipping work between different editions? Primary is SQL Server 2016 SE and Secondary is SQL Server 2016 EE. If not, how else can I set up high availability for this combination of servers?
0
votes
0answers
23 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 ...
4
votes
1answer
106 views

Is it possible to use just one shared folder for log shipping?

I wonder if it is possible to use one shared folder(only in source database) instead of two (one in source db and another in destination db). That's Server1 will store its t-log backups there and ...
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 ...

1
2 3 4 5 6