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
0answers
4 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
33 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
14 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
23 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
31 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
0answers
6 views

Log Shipping Monitor Server Miss match

I'm receiving an LSAlert that my log ship database hasn't been updated. During digging I found that the log_shipping_primary_secondaries references the proper name of the secondary server, while ...
0
votes
1answer
38 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
39 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
26 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
32 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
66 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
51 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
52 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
50 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
26 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 ...
4
votes
0answers
45 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
79 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 ...
1
vote
0answers
29 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
39 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
110 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
151 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
42 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
190 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
97 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
106 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
352 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
156 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
58 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
54 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
96 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
474 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
27 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
157 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 ...
2
votes
2answers
484 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
1answer
36 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
vote
3answers
155 views

Adding a Far DR secondary server Log shipping on already configured SQL server

We have a setup where there are 3 SQL Server instances in which 1 primary,1 Near Secondary,1 Far Secondary. So the there is already log shipping configured between Primary and Near DR Secondary. Now ...
0
votes
0answers
92 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 ...
1
vote
1answer
297 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 ...
7
votes
1answer
284 views

After Restoring Log Shipping to Secondary Server, First Stored Procedure Execution is Slow

We've set up log shipping to a secondary SQL server on Standby/ Read-Only to offload all SSRS report generation. This works fine within the restrictions imposed by: Kicking out the user during the ...
3
votes
2answers
574 views

Two Databases in Standby/ Read-Only, Can Only Alter to SINGLE_USER One of Them

I am setting up Transaction Log shipping in Standby/ Read-Only mode of two databases to multiple instances. After backing up and restoring the transaction logs to their separate instances (one copy ...
0
votes
1answer
172 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
27 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
61 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 ...
3
votes
2answers
517 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
51 views

Security Considerations for AG vs Log Shipping

we are considering removing our log shipping server and adding another node to our Availability Groups. While I understand that this should be better cause it's a/synchronous and will move the data to ...
1
vote
1answer
134 views

Restore job run successfully without error but actually not applied during log ship from older version to newer one

Our requirement is for SQL Server 2008 R2 databases to be upgraded/migrated to SQL Server 2016. We want to configure log shipping between SQL Server 2008 R2 (source) and SQL Server 2016 (target). We ...
1
vote
1answer
255 views

Database file location change on standby site after restore standby database

I am configuring Log shipping from SQL Server 2008R2 to 2016 using NORECOVERY option with Log Shopping jobs. I have successfully configured Backup, Copy and Restore jobs. When I perform a restore on ...
3
votes
1answer
503 views

log ship from older version to newer one

As per below thread from SQL Server: Can I log ship from SQL Server 2014 --> 2016? Always log ship UP as it's a basic supported upgrade process. you can't log ship DOWN. The question you might ...
1
vote
1answer
888 views

xp_delete_file - error message when no files for deleting

I have a job that deletes transaction log backups older than 3 days. if for some reason there are no files to delete, it comes out with the following error message: Msg 22049, Sev 16, State 1: ...
1
vote
0answers
52 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
2 3 4 5 6