Questions tagged [log-shipping]
Transferring log records from a source database system to one or more destination systems.
319
questions
1
vote
1
answer
318
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 ...
- 31
2
votes
2
answers
191
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,295
1
vote
2
answers
763
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. ...
- 195
0
votes
1
answer
357
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
2
answers
99
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 ...
- 189
1
vote
1
answer
80
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?
- 11
1
vote
0
answers
343
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 ...
- 253
-2
votes
1
answer
1k
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?
- 1
0
votes
0
answers
39
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 ...
- 1
4
votes
1
answer
683
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 ...
- 1,213
2
votes
2
answers
836
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 ...
- 2,149
0
votes
1
answer
291
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 ...
- 25
1
vote
3
answers
258
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
0
answers
118
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 ...
- 105
1
vote
1
answer
783
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 ...
- 13
7
votes
1
answer
388
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 ...
- 105
3
votes
2
answers
2k
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 ...
- 105
0
votes
2
answers
533
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
...
- 11
0
votes
1
answer
33
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, ...
- 253
0
votes
1
answer
312
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 ...
- 253
3
votes
2
answers
1k
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 ...
- 3,794
0
votes
1
answer
57
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
1
vote
1
answer
273
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 ...
- 71
1
vote
1
answer
522
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 ...
- 71
5
votes
1
answer
2k
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 ...
- 71
1
vote
1
answer
3k
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: ...
- 15.4k
1
vote
0
answers
104
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 ...
- 23
2
votes
1
answer
921
views
Changing the owner of a read-only database which is configured with Log Shipping
Is there a way to change the owner of a read-only database which is configured with Log Shipping without actually re setting up LS?
Per this link it's not, but I'm checking if anything has changed ...
- 2,149
3
votes
2
answers
1k
views
Does MSSQL log shipping automatically remove the backup files from both servers?
Does Microsoft SQL Server's log shipping feature remove the backup files automatically? I am concerned that the secondary server's hard drive will reach capacity unless the previously restored files ...
- 191
1
vote
1
answer
209
views
how to find out the log backups that I need to restore in order to bring log shipping from standby to online?
I have log shipping set up from server1 to server2.
on server1 transaction logs backups are taken every 15 min to a network share folder.
these transaction log backups are then copied (afte 1 hour) ...
- 15.4k
1
vote
1
answer
1k
views
SQL Log shipping - Very Slow restore
I have SQL Server 2012 SP4, ten databases and log shipping.
One database 2.7TB
Ten data files and two log files
Log shipping configuration:
Transaction log backup job : 3 Min
Copy job : 1 Min
...
- 1,061
6
votes
2
answers
2k
views
what is the penalty for NOT setting Disconnect users in the database when restoring backups?
setting up Log shipping between 2 sql server 2016 servers
I want my databases read-only standby on the secondary server.
there is a tick box saying Disconnect users in the database when restoring ...
- 15.4k
0
votes
1
answer
446
views
Could not find a log backup file that could be applied to secondary database [closed]
Was getting this error when trying to do a Log Shipping Restore, even though I had a bunch of TRN files that were sequential. Seems that the filename of the log file are required to be in the ...
- 1
2
votes
1
answer
520
views
how to integrate ola hallengren solution with log shipping?
I need to set up log-shipping from my SQLPROD2 to server2
but I am facing the following problems:
1) I already use ola hallegren backup solution, and it provides the 15 min log backups for all ...
- 15.4k
0
votes
3
answers
2k
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 ...
- 133
1
vote
1
answer
62
views
Questions to Continuous Archiving and Point-in-Time Recovery with PostgreSQL
I'm planning my database backup strategy and came across the continuous archiving concept of PostgreSQL which is exactly what I'm looking for.
I have two questions on this.
I'm planning to mount ...
- 95
0
votes
1
answer
242
views
Monitoring Log-Shipping for Multiple Databases
We are setting up log-shipping for multiple databases hosted at different server and while process began, I noticed that only one SQL job is being retained at Monitoring Server.
Our plan was to have ...
- 3,794
0
votes
2
answers
74
views
Can both primary and secondary servers be online simultaneously in Log Shipping?
I am new to log shipping and I want to know can both primary and secondary servers be online at the same time like in replication, or only the primary one can be online while others get the log ...
- 2,078
1
vote
1
answer
64
views
Standard process during a disaster [closed]
In our environment we have a 2-node Failover cluster instance and log shipping for disaster recovery. Failover cluster is the primary site and log shipping is on DR. 2 node: same data center; log ship ...
- 1,019
1
vote
0
answers
445
views
Log Shipping with minimum synchronization gap
We will have an application that will go live soon. I will be using Log Shipping for Disaster Recovery but I am confused about the Job scheduling. The transaction logs will be taken every 10 minutes ...
- 1,019
0
votes
1
answer
456
views
Log shipping - Job schedules
When we configure the Log Shipping, there are jobs automatically created that run on schedule. What happens if db size grows or there is network latency, does SQL Server auto handle the job schedules? ...
- 3,153
2
votes
1
answer
953
views
Log Shipping - Secondary Database(s) - Which recovery model?
In Log shipping configuration - the primary database must be either in Full or Bulk-Logged recovery model. However, is there any requirement of recovery model of the secondary database?
Example: ...
- 3,153
1
vote
1
answer
353
views
Log shipping - Bulk logged recovery mode doesn't log bulk operations, yet it is allowed for Log Shipping config? Why?
Log shipping is one of methods for high availability/disaster recovery. It works by transferring the transaction logs from primary to the secondary.
Log shipping needs that the database should be ...
- 3,153
1
vote
0
answers
86
views
Spin up an extra sql azure instance to reorganize/rebuild indexes with no downtime
We have a pretty large sql azure database, over 300GB.
Many tables have been altered over time and we would like to create fresh indexes, including clustered ones.
Of course we would like to minimize ...
- 456
1
vote
1
answer
35
views
Publication shows up in secondary server
I have created log shipping and the primary server is also used for transactional replication. Now after creating log shipping I have noticed the publisher shows up on the secondary and it wont let ...
- 1,019
1
vote
1
answer
147
views
Log shipping from SQL Server 2014 Enterprise db to SQL Server 2017 Standard with partitioning
I wish to implement log shipping from my current primary which is a SQL Server 2014 Enterprise database to a SQL Server 2017 Standard edition database. I also wish to implement table partitioning on ...
- 11
1
vote
1
answer
622
views
When does Log shipping restore job mark itself to completion in standby mode
I am editing my previous question to be more precise as i am still unable to get the logic behind the log shipping restore job.
May be there is something i am missing to explain but will try my best.
...
- 2,149
0
votes
0
answers
317
views
When restoring logs in log shipping, when does the restoring stop
We are using LS for reporting purpose. LS backup runs on primary every 15 minutes. On Secondary nightly restore via LS restore job is done daily at 10 PM.
While the nightly restore job is running, ...
- 2,149
2
votes
3
answers
1k
views
SQL Server Transaction Log VLFs not being released (Status 2) on log shipped Database
Have seen a couple of posts similar to my scenario, but nothing that actually resolves my issue.
Scenario:
Routine index rebuild happens, once a week, 2 AM Saturday morning.
Log file grows about 15x ...
- 41
1
vote
1
answer
58
views
Expanding Data File with Log Shipping and Mirroring: SQL Server 2008 R2
I am in a situation where I need to expand a data file by 750 Gb in order to get to 20% free space in the data files. This is a requirement by our third party application developer in order to ...
