Questions tagged [log-shipping]
Transferring log records from a source database system to one or more destination systems.
62
questions with no upvoted or accepted answers
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
4
votes
0
answers
401
views
How to copy SQL Server log shipping files to AWS EC2 instance
I am using SQL Server 2008 R2 and would like to log ship from my local data center SQL Server instance to a log shipping target SQL Server running in AWS EC2.
What is the best way to copy the log ...
- 141
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
3
votes
1
answer
2k
views
How to fix an odd LSBackup job error in Log Shipping?
Configuration:
LSPrimary01 - Log Shipping Primary
LSSecondary01 - Log Shipping Secondary
OddServer03 - This server is not part of the LS configuration, the odd man out
Sean\LSServiceAccount - The ...
- 1,363
3
votes
0
answers
343
views
VSS Writer : RESTORE VERIFYONLY FROM VIRTUAL_DEVICE breaks log shipping
Log shipping has been working for a very long time, but now and then it breaks. I found it sometimes breaks (causes the transaction log to become corrupt and I get the message : "media family on ...
- 1,335
3
votes
0
answers
157
views
Need a way to prevent log shipping from kicking users out
We have SQL Server 2012. A service we use requires us to use log shipping, however we are tired of having users being kicked offline every 15 minutes.
Are there any creative ways to get around this (...
- 131
3
votes
0
answers
1k
views
SQL Server Database Hot Backups: Which Technique(s) to Use for Multi-Level Replication?
I'm reading the many other posts here about mirroring vs. replication, but I'd still appreciate it if someone with some experience would weigh in.
My small development team needs to have local ...
- 165
3
votes
1
answer
5k
views
Issues with Log Shipping
First time at posting a question on here, so please bear with me and I'll try and detail all the information.
Currently, I'm log shipping from SQL 2012 Standard Edition (11.0.3000) (lets call it ...
- 41
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
2
votes
0
answers
852
views
Log Shipping and Ola's Hallengren's Scripts - Can they work in unison?
I have a single instance database server with several databases. Some do not require log shipping and some do require log shipping.
Is there a way to edit Ola's LOG backup job to ignore the ...
- 1,363
2
votes
0
answers
731
views
SQL Server Log Shipping: Does the native log shipping support encryption of the tlog backup?
SQL Server 2014 Std Edition
We use the built in SQL Server encryption for our db backups (sql server backup to disk) -- works great.
We would like to implement encryption for the tlog backups (which ...
2
votes
0
answers
157
views
LOG BACKUP is TRUNCATING in Log Shipping
I had configured Log shipping from INSTANCE1 to INSTANCE2. For the past few days, am able to find that the log backup is truncating only at the midnight. Due to this, LSRestore Job in INSTANCE2 got ...
2
votes
0
answers
1k
views
What does 'Could not find a log backup file that could be applied' means on log shipping?
Skipped Log Backup File ..... Could not find a log backup file that
could be applied to secondary Database
What does this mean?
I've configured a log shipping. To test, I created 2 tables, put ...
- 7,246
2
votes
0
answers
110
views
SQL Server 2014 Log shipping - column error
I'm trying to set up log shipping between two instances of SQL Server 2014 Dev edition. Backup and copy jobs work flawless, but the restore one keep failing with the following error:
An error ...
- 121
2
votes
0
answers
481
views
Log shipping restore delay of a minute between iterations
On a test database running Log Shipping jobs the initial Restores to catch up performed the first time I run the Restore job seem to have a 1 minute or so Wait time built in. I would have expected ...
- 121
2
votes
0
answers
250
views
Can the same database be log-shipping secondary and primary at the same time?
Here is my scenario:
Database DB1 on Server1 is log shipping primary in data center.
Database DB1 on Server2 is log shipping secondary; Server2 is in remote location. Logs are shipped from data ...
- 401
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
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
1
vote
0
answers
344
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
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
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
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
0
answers
144
views
Log Shipping Job Failed
I have a transaction log shipping configured. Job activity monitor shows that both Copy and Restore steps have failed, however, I see that backup files are in fact copied across to the secondary ...
- 69
1
vote
0
answers
392
views
A transactional log backup could not be generated because database is in either NORECOVERY mode or STANDBY mode
We have configured Always on Group Database with Full Recovery mode and secondary replica is in sync mode with primary server.Now we have configured logshipping in primary server to supply t-log ...
1
vote
0
answers
321
views
Log shipping jobs are not executing
I have configured log shipping between instances, everything was working fine, but recently I have noticed that time on my secondary server differs from time on primary server. I changed time ...
1
vote
0
answers
409
views
SQL Server 2012 - log shipping issue
I'm sort of new to SQL Server so bear if the doubts are silly. I have configured log shipping for my DR purpose. SQL Server 2012 is the version. Today I encountered the following error in my log ...
- 1,824
1
vote
1
answer
43
views
Is log shipping good for periodic synchronization?
I have Postgresql 9.3 server on both my laptop and my desktop at home. I keep identical data on both system. Sometimes I work on the database on my laptop while other times I work on the database on ...
- 181
1
vote
0
answers
2k
views
What Open Ports are Necessary for SQL Server Log Shipping to Secondary on the Internet
Our secondary server will be on the other end of an always on IPSEC tunnel. We need to instruct our customer's firewall/VPN/Server team (they are responsible for the primary).
What I've gathered so ...
- 159
1
vote
0
answers
32
views
Log Shipping causes high context switches
MSSQL - I have setup log shipping on many databases being sent to 2 different servers in NORECOVERY mode.
This is causing crazy context switches on the main server.
Is this normal?
16 Cores without ...
- 319
1
vote
0
answers
55
views
Log shipped database server user SID is created automatically
We have a production server "prod" which has a user say 'test' that lets the users connect to the application and a logon trigger which stops them from connecting to the server through SSMS.
I ...
- 11
1
vote
0
answers
128
views
Please explain log-shipping delta
I am trying to understand how Delta is monitored in log-shipping. We have log-shipping monitoring in place and I am seeing delta increases sometimes for random instances and it drops once database is ...
- 326
1
vote
0
answers
123
views
Resuming log shipping, do I just restore the db over itself?
I have log shipping set up.
I then bring all the databases online on the secondary machine, so log shipping can't restore anymore.
A bit later on I want to resume log shipping.
I was told before ...
- 659
1
vote
0
answers
166
views
Log Shipping Monitor Stored Procedure returning Null
I have log shipping setup. When I EXEC sp_log_shipping _monitor it returns all null values
even though log shipping appears to be working fine.
last_restored_file
NULL
last_copied_file
NULL
- 66
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
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
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
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
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 ...
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
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
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
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
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
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