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
votes
1answer
28 views

Move logship database file

I want to move a ldf file from one drive to another. Some idiot who is definitly not me restored the log file to the wrong drive which is nearly full now. The database is readonly/standby for a ...
0
votes
1answer
30 views

How to Ensure all Log backups are restored on secondary server in log shipping

I have some concerns regarding the restore job on secondary server in log shipping in Microsoft SQL Server 2016 for below scenario : I have two servers, primary and secondary. The backup, copy and ...
0
votes
1answer
34 views

Error Restore database to secondary - Log Shipping

I am new as a DBA. I want to ask. I want to create new log shipping a database 17815 from server primary to server secondary. I create new log shipping with right-click on database 17815. when I click ...
0
votes
1answer
28 views

what databases are already set up in the log-shipping, and which ones are not?

I am setting up log-shipping from server1 to server2. there are many databases on server1 and I want to automate the process. I have already done a few databases manually, while I am working on the ...
2
votes
1answer
81 views

Strategy on Standby restore option for hourly log shipping file

I am trying to come up with a strategy of keeping up with daily database update process using "standby" restore mode. I am getting 24 log shipping files (for the previous day's each hour ...
0
votes
0answers
30 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
26 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 ...
-1
votes
1answer
84 views

Migration from SQL SERVER 2008 R2 to 2019 with Log Shipping [closed]

Is possible to run swing migration from SQL SERVER 2008 R2 to 2019 with Log Shipping?
0
votes
1answer
50 views

Best practices for sql server log shipping method [closed]

We have about 20 databases, with no DR config yet. Most of them are SQL Server 2016 with Failover cluster Availability group What's the best method for a log shipping? Log shipping directly between ...
0
votes
1answer
33 views

Do DB permissions flow from primary server to secondary server in SQL log shipping?

Do DB permissions flow from primary server to secondary server in SQL log shipping? If someone wants db read permissions on the secondary, do we grant on primary and the permission flows to the ...
0
votes
1answer
50 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 ...
2
votes
2answers
152 views

How to ship new rows from the source to a target server?

Context We have a SQL Server 'source' where daily 10M rows inserted to a table. No updates. I would like to ship the new rows to a 'target' server, then delete those (sooner or later) on the source ...
0
votes
0answers
63 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 ...
3
votes
1answer
286 views

How to dispose of large tables with the least impact to log shipping?

Have two semi large related tables (284,6876,609 rows - 156,785,176 KB and 4,2628,162 rows - 2,212,464 KB) in a log shipped db that needs to be either purged or dropped. How can I dispose of these ...
0
votes
1answer
50 views

Log shipping retention question

One of the secondary's is failing log shipping restore due to insufficient drive space. This might not be looked at by IT for several days. Can log shipping primary server purge transaction log ...
0
votes
1answer
26 views

Tools for looking at transactions inside of transaction log backup file? [closed]

Are there any tools (commercial or open source) for looking at the contents of a transaction log backup file? Occasionally, get a large transaction log backup file and would like to see the contents /...
0
votes
1answer
21 views

What things can influence log_shipping_monitor_secondary - last_restored_latency values?

Looking at msdb.dbo.log_shipping_monitor_secondary last_restored_latency values for each log shipped db. last_restored_latency - The amount of time, in minutes, that elapsed between when the log ...
1
vote
1answer
45 views

Excluding log shipped DB from current database maintenance plan (Ola's solution)

The Senior DBA and I were discussing our most recent rollout of log shipping to 25+ servers and one of the issues we had ran into during our pilot was the log chain breaking randomly. We narrowed down ...
1
vote
1answer
72 views

SQL Log Shipping - What is the date time format used by transaction log file name?

Looking at my SQL log shipping file names (following is an example) Q:\Backups\LogShipping\MyAudit\MyAudit_20201027165400.trn What date time format is the transaction log expressed in (local military ...
0
votes
1answer
68 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
2answers
23 views

Log shipping to fix unintended deletion?

I am reading the book 'Pro SQL Server 2019 Administration' from Carter: In a scenario in which a user accidentaly deletes data; he mentions that we can recover the data (from the DR server) and then &...
0
votes
0answers
15 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
2answers
38 views

SQL Server logshipping: Extend the LS_Alert window

We have a logshipping setup, where the LS_Restore job on the secondary database is switched off every night for the datawarehouse to grab its data. The restore cycle is set to 15 minutes and if ...
0
votes
0answers
27 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
46 views

SQL log shipping from different hosts on different versions [duplicate]

We have a current setup where we have two SQL 2008R2 database servers in production. Our reporting team requested a single place they could query data from both servers (to avoid both hitting ...
0
votes
1answer
45 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
1answer
74 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
71 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 ...
1
vote
1answer
45 views

Sql Server Backup - Log shipping vs VM snapshot

Setup I have Sql Server Standard running on an AWS VM For one of my DBs on this server, I perform:  1x daily backup And ship logs every 15mins to another DB Server VM, dedicated to log shipping ...
0
votes
0answers
77 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 ...
1
vote
0answers
141 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. ...
0
votes
1answer
64 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 ...
2
votes
1answer
122 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 ...
0
votes
1answer
90 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 ...
0
votes
1answer
30 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 ...
5
votes
0answers
82 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 ...
2
votes
2answers
103 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
1answer
79 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
50 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, ...
2
votes
0answers
156 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
333 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 ...
1
vote
1answer
72 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
319 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
156 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
146 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
541 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
229 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
74 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 ...
1
vote
1answer
61 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
164 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
2 3 4 5
7