Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [log-shipping]

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

Filter by
Sorted by
Tagged with
0 votes
1 answer
20 views

For Azure VM SQL log shipping, What is the reason for requiring storage account to be in the same resource group as SQL VM? Any workaround?

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/log-shipping-configure?view=azuresql The prerequisite for log shipping in Azure VM based SQL servers is: At least two domain-...
variable's user avatar
  • 3,634
0 votes
2 answers
45 views

How does the log shipping technology (restore job) know exactly which file(s) to use for restore?

At a high level, what concept is used by the log shipping restore job to use the correct file(s) during each restore operation (job execution)?
variable's user avatar
  • 3,634
1 vote
1 answer
97 views

SQL Server - Log Shipping to Azure VM

I'm looking for some advice regarding Log Shipping from SQL Server 2016 On-Premises to SQL Server 2016 on an Azure VM. From my existing knowledge and research, there are a few ways of going about this....
FrugalShaun's user avatar
0 votes
0 answers
28 views

Unresponsive restore process for log shipped db having memory optimised tables

Log shipping documentation has a caution: https://learn.microsoft.com/en-us/sql/database-engine/log-shipping/about-log-shipping-sql-server?view=sql-server-ver16 Known issue: For databases with memory-...
variable's user avatar
  • 3,634
0 votes
0 answers
23 views

SQL Server : database log reported failure but succeded

I've configured logshipping for my production databases, but for one database I'm getting weird errors. Every day I'm receiving one following message from SQL Server Agent: JOB RUN: 'Backup db01 log ...
user avatar
0 votes
1 answer
125 views

How to do log shipping when SQL server versions are different?

I have SQL2014 version database on my Windows12 server. I want to add the databases in SQL2014 to SQL 2022 on my Windows2016 server using the Log Shipping method. Since the versions are different, I ...
Merve's user avatar
  • 55
0 votes
2 answers
39 views

Can I regularly log ship from a source to a target, while running DML on the target?

I want to have two databases on separate severs. Let's call the databases Source and Target. Target is the reporting server copy of Source. Except for the changes caused by a stored procedure that I ...
J. Mini's user avatar
  • 421
1 vote
1 answer
54 views

Release Database Transaction Log File Freespace In SQL Server 2016 [duplicate]

Good afternoon, We have 4 node SQL Server configure in HA/DR. Periodically, we purge the old data to free up the space. Recently, after the SQL Job to purge the data was executed, we notice an ...
rushabh138's user avatar
0 votes
1 answer
80 views

SQL Server 2019 Logship Restore getting failed for transactional data

I am trying to create a log shipping setup. The log shipping process restores the full backup to secondary, but the restore step is failing for transactional data. When I check the job history I see ...
user avatar
0 votes
1 answer
36 views

What is the purpose/use case of log shipping monitor server?

When configuring log shipping, under the restore section we can configure alert to get a notification if restore doesn't occur on the secondary in x minutes. So then, what is the purpose/use case of ...
variable's user avatar
  • 3,634
1 vote
2 answers
159 views

TRN file Backup using LSN

I receive the TRN files on a daily basis from the client and I back it up on a regular basis, i have usually backed it up based on the timestamp, but they recommend using LSN. I download the files ...
Prithvi's user avatar
  • 11
0 votes
0 answers
26 views

Log Shipping Status Not Auto Refreshing After 2019 Upgrade

After upgrading to SQL Server 2019, 'Transaction Log Shipping Status' report stopped auto refreshing. Does anyone have any suggestions what I should look for?
halid.sert's user avatar
-3 votes
1 answer
45 views

SQL Server log shipping for DC and DR on cloud [closed]

If I would like to do log shipping to cloud DC DR. But the DR server at normal times will be turned off. It will turn on only if the DC has failed. So is it possible way to do it? when the DC failed ...
alice's user avatar
  • 1
2 votes
3 answers
75 views

What is a good way to get a time for the data freshness when the source is log shipped to another server?

I'm log shipping from SERVER_A with backups every 10 minutes. I restore the logs to SERVER_B every 20 minutes. I pause the restores while I do a DWH load from SERVER_B into SERVER_C I report out of ...
Brent Seeney's user avatar
0 votes
1 answer
75 views

Is there a query or report to see how often log shipping is falling behind?

Is there a query or report to see how often log shipping fell behind for a given month? Behind by 2 minutes is fine. Behind 1+ hours several times a month is not.
user2368632's user avatar
  • 1,097
0 votes
0 answers
91 views

Is there a readymade script that I can use to automate sync of server level logins, roles and securable permissions between 2 SQL servers?

I have configured log shipping from SQL1 to SQL2. Database level users, roles and securable permissions are getting transferred. However suppose the user doesn't exist on the server level login, then ...
variable's user avatar
  • 3,634
0 votes
1 answer
671 views

How to sync sql server login and database level permissions between 2 sql servers?

If I have log shipping configured between 2 sql servers on premise, then, in addition to the database data and schema, will the database user permissions and server login permissions/role membership ...
variable's user avatar
  • 3,634
0 votes
2 answers
253 views

Can you safely log ship between primary and secondary servers on different cumulative update versions?

Need to update primary from 2019-CU14 to 2019 CU15 and a few hours/days later update secondary to CU 15 once the primary is deemed stable. Can you safely log ship between primary and secondary ...
user2368632's user avatar
  • 1,097
2 votes
1 answer
564 views

Log Shipping is failing with a 'Could not cleanup History'

We're experiencing a weird problem with our SQL Server 2019 Log shipping (15.0.4198.2). We have 4 databases that are log shipped, with a monitoring instance. The log tasks all fire at the same time. ...
BJury's user avatar
  • 154
0 votes
2 answers
198 views

What is the impact on primary (in terms of locking) and restore process when secondary database is being read by large query?

I am exploring couple of solutions: Log shipping - say a large query is running and meanwhile the log shipping process is triggered. Will this stop the query or delay the log shipping restore? ...
variable's user avatar
  • 3,634
1 vote
0 answers
38 views

How to solve Log shipping issues when Shadow copy volume-level backups are in place?

How to solve Log shipping issues when Shadow copy volume-level backups are in place? I tried setting up log shipping but it failed each time because the backup chain of the virtual log, the block ...
Art V's user avatar
  • 11
1 vote
1 answer
51 views

Log shipping report to show average daily volume?

Is there a SQL log shipping report (or query) that I can run to see what my average daily log shipping volume is in terms of gigabytes of log data shipped (by DB or in total)?
user2368632's user avatar
  • 1,097
0 votes
1 answer
111 views

Are there any special considerations for a log-shipping role change when the database has memory optimzed files?

We're noticing a problem with our log-shipping setups when the database contains a memory-optimized file. Specifically, after changing the primary/secondary roles, restoring log backups taken after ...
Toby Allsopp's user avatar
0 votes
2 answers
139 views

Do I need to be carefull about log shipping log backups truncating tlog?

We have full backups running every Sunday. Differential every day. Log backups every hour. This is all configured as part of our recovery strategy. I have been requested to configure log shipping on ...
variable's user avatar
  • 3,634
2 votes
1 answer
332 views

Can we access snapshot database of a log shipping database while we are restoring log files

I have a question regarding snapshot database of a log shipping database. I have a database name like Northwind on server A and I am shipping it to server B. On server B, the log shipped copy of the ...
info.sqldba's user avatar
-1 votes
1 answer
247 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 ...
user189695's user avatar
0 votes
1 answer
643 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 ...
chetan kathote's user avatar
0 votes
1 answer
238 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 ...
jubey simanjuntak's user avatar
0 votes
1 answer
625 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 ...
Marcello Miorelli's user avatar
2 votes
1 answer
2k 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 ...
Java's user avatar
  • 233
-1 votes
1 answer
5k 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?
Darwin Pou's user avatar
0 votes
1 answer
291 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 ...
Nike's user avatar
  • 3
1 vote
1 answer
160 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 ...
user2368632's user avatar
  • 1,097
0 votes
1 answer
438 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 ...
Ed Hall's user avatar
2 votes
2 answers
164 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 ...
g.pickardou's user avatar
3 votes
1 answer
475 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 ...
user2368632's user avatar
  • 1,097
0 votes
1 answer
207 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 ...
user2368632's user avatar
  • 1,097
0 votes
1 answer
49 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 /...
user2368632's user avatar
  • 1,097
0 votes
1 answer
53 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 ...
user2368632's user avatar
  • 1,097
1 vote
1 answer
130 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 ...
Randoneering's user avatar
1 vote
1 answer
455 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 ...
user2368632's user avatar
  • 1,097
-1 votes
2 answers
2k 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 ...
Chicago1988's user avatar
0 votes
2 answers
38 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 &...
Chicago1988's user avatar
0 votes
2 answers
365 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 ...
steenbergh's user avatar
0 votes
1 answer
2k 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 ...
BrianC's user avatar
  • 111
0 votes
1 answer
82 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 ...
mukki's user avatar
  • 11
0 votes
1 answer
498 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 ...
Ayman Farouk's user avatar
0 votes
1 answer
246 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 ...
Ayman Farouk's user avatar
1 vote
1 answer
148 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 ...
mel's user avatar
  • 11
0 votes
0 answers
196 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 ...
AKBAR ALI's user avatar

1
2 3 4 5
7