Questions tagged [log-shipping]

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

69 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
78 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 ...
0
votes
0answers
199 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, ...
0
votes
0answers
22 views

Log Shipping - Determining Rows Modified After a Restore

The company I'm doing some work for is using log shipping to sync a production database with a secondary. Is there any way I can determine the rows that were inserted, updated or deleted after a ...
0
votes
1answer
476 views

Log Shipping failover when Primary is not accessible

Log Shipping Fail-over I have set up log Shipping with Cluster. In this scenario I want to simulate a situation when the whole cluster becomes inaccessible. My Steps for fail-over will be Copy and ...
0
votes
0answers
231 views

LogShipping replicated database

We use transaction replication to replicate our production database to another server(server 1) for reporting purpose. For a standby copy, we also logship the main database to another server (server 2)...
0
votes
0answers
102 views

Can you do Log Shipping from Production non-Temporal to Data Lake Temporal setup Table?

Can you do log-shipping from a table in production without temporal tables to a secondary that has temporal tables setup? Details: We want a frozen nightly / yesterdays-data-only data-lake. And we ...
0
votes
1answer
605 views

SQL Server Log Shipping restore fail - The Log Is too recent to apply

The restore is missing a backup log, and the "physical_device_name" of the missing backup log is "NUL". This is a Transaction Log that gets made out of sequence with the log shipping backup job. I can'...
0
votes
0answers
49 views

“Last database backup” not updating as log shipping target has different name

I monitor standby synchronization with an scheduled job that sends me the outdated "last database backup" dates of multiple databases on many SQL Server instances. I have this database named ANALYTIX ...
0
votes
1answer
302 views

How can I create a readable/writable clone of a log shipped standby/read only database?

I need to take adhoc copies of a development database (on SQL Server 2005) to another SQL Server and be able to read/write to that cloned database. As the SQL Servers are in different data centres, ...
0
votes
0answers
898 views

SQL server Log shipping Copying failed due to incorrect username and password

I have 2 sql server 2008 servers with log shipping. Now im trying to add one more secondary server to the existing log shipping. While copying the log files to secondary I got the below error on SQL ...
0
votes
0answers
312 views

sqlserver lsalert job does not update it's out-of-sync counter

I am getting 14421 error messages and ended up reading the following KB Here is the part I'm referring to : Problems either with the Backup job or Copy job are most likely to result in "out of ...
0
votes
1answer
88 views

In what order does sqllogship.exe process groups of log files?

In what order does sqllogship.exe processes groups of log files based solely on filename order or does it does it do it based on file timestamp primary sort then filename secondary sort? It appears ...
0
votes
1answer
594 views

Strange Log Shipping Error Message

Environment and Server Details: 12.0.4457 Windows Server 2012 R2 standard VMWare Virtual Machine Dell Equal Logic SAN SQL Error Log Message: The log shipping secondary database ServerName....
0
votes
0answers
48 views

SQL Server DR scenario

I have a SQL server A and B which is production databases. The DR of production 'A' is production db 'B' and DR of production db 'B' is production db 'A'. DR feature that is used is log shipping. All ...
0
votes
0answers
78 views

Best method to implement HA and DR, replication via 1 PUB and 2 SUB or replication and LS both

I need a advise on one of our projects where: We have 3 SQL database servers A, B and C: A is the live production server with around 200 users with a database of size 1.5 TB hosted. B is going to ...
0
votes
0answers
242 views

Log shipping Readonly/Standby executes Queries slow for some users

I have a SQL Server database that is doing log shipping to another SQL Server instance, both servers have identical hardware. We have a reporting service that then runs reports against the readonly ...
0
votes
0answers
319 views

Tran Log file growing even after log backups and Log shipping configured

I have log shipping configured for a database in SQL server 2005 with below details: A) Database X hosted on primary: Log backup every 1 hour as scheduled in LS Backup job: Data file: 40 GB and Log ...
-2
votes
1answer
765 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
2