Questions tagged [log-shipping]
Transferring log records from a source database system to one or more destination systems.
319
questions
2
votes
3
answers
59
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 ...
- 23
0
votes
0
answers
32
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?
- 1,036
0
votes
0
answers
55
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 ...
- 3,153
0
votes
1
answer
278
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 ...
- 3,153
0
votes
2
answers
89
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 ...
- 1,036
2
votes
1
answer
263
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.
...
- 154
0
votes
2
answers
60
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? ...
- 3,153
1
vote
0
answers
31
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 ...
- 11
1
vote
1
answer
36
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)?
- 1,036
0
votes
1
answer
73
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 ...
0
votes
2
answers
55
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 ...
- 3,153
2
votes
1
answer
209
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 ...
- 317
-1
votes
1
answer
164
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 ...
- 79
0
votes
1
answer
335
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
1
answer
89
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
1
answer
279
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 ...
- 15.4k
2
votes
1
answer
634
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 ...
- 195
-1
votes
1
answer
4k
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
1
answer
200
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 ...
- 3
1
vote
1
answer
104
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 ...
- 1,036
0
votes
1
answer
177
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 ...
- 1
2
votes
2
answers
163
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 ...
- 167
3
votes
1
answer
322
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 ...
- 1,036
0
votes
1
answer
123
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 ...
- 1,036
0
votes
1
answer
43
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 /...
- 1,036
0
votes
1
answer
32
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,036
1
vote
1
answer
88
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 ...
- 95
1
vote
1
answer
290
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 ...
- 1,036
-1
votes
2
answers
1k
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
...
- 251
0
votes
2
answers
35
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 &...
- 251
0
votes
2
answers
155
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 ...
- 269
0
votes
1
answer
658
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 ...
- 111
0
votes
1
answer
71
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 ...
- 11
0
votes
1
answer
202
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
1
answer
171
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
1
answer
95
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 ...
- 11
0
votes
0
answers
158
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 ...
- 21
1
vote
0
answers
501
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. ...
- 11
0
votes
1
answer
87
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
1
answer
254
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 ...
- 516
0
votes
1
answer
134
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 ...
- 105
0
votes
1
answer
39
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 ...
- 1,295
5
votes
0
answers
131
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 ...
- 859
2
votes
2
answers
157
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 ...
- 859
3
votes
1
answer
219
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 ...
- 2,349
1
vote
1
answer
81
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, ...
- 69
2
votes
0
answers
271
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 ...
- 135
1
vote
1
answer
597
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
1
answer
159
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 ...
- 11
2
votes
1
answer
628
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 ...
- 23