Questions tagged [log-shipping]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
306 views

SQL Log Shipping Job Scheduling

If I have SQL Log Shipping scheduled as follows: Primary Server (VM): Backup Job Schedule - Every 5 Minutes (To LogCopyTo) Secondary Server (VM): Copy Job - Every 15 Minutes (To LogCopyFrom) ...
1
vote
1answer
830 views

expire_logs_days directive requires change master?

After adding: expire_logs_days=7 is it necessary to change reset the master's position and file? I had modified the my.cnf figuring that would delete the no longer needed binary logs older than 7 ...
7
votes
1answer
169 views

Snapshot_isolation_state_desc on a Read only/Stand by Database

I have configured Log Shipping where the primary server database has snapshot_isolation_state_desc reported as off. I tried to turn it off on the secondary which is a standby read only by using the ...
0
votes
1answer
468 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 ...
2
votes
1answer
109 views

Log Shipping with Failover Cluster Server Cores

Failover Over Cluster 2 Node - 6 Cores- Enterprise Edition 2014 Log Shipping with Cluster with 4 Core License- Enterprise Edition 2014 My question is if I need to log ship do I need to match the ...
0
votes
2answers
70 views

How to take Backup of BackUp DB in SQL Server 2012

In Our environment, Log log shipping is configured and working good. Transaction logs are Backed-up on Primary Server. Copy to Backup DB Restore on Backup DB. Background: We are in process of ...
0
votes
2answers
140 views

Test/Verify Log-Shipping Backup

We recently suffered a power/connectivity outage at a data center housing two PostgreSQL 8.4 secondary servers, that remotely back up our two primaries via log-shipping replication. Backup power kept ...
1
vote
1answer
266 views

Tail log backup query in log shipping reversal

I am doing log shipping failover and failback configuration in SQL Server 2008 R2 environment. During the Failover, I am taking the tail log backup of primary database with query: Script to backup ...
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
1answer
71 views

Log Shipping back up location to a network share instead of clustered file share

Below is my current cluster set up Node 1 - Active Node 2 - Passive While doing Log SHipping can I save the back ups to a network share instead of a clustered file share? The service account ...
0
votes
1answer
252 views

Setting up Log shipping without enabling LS copy job

We have a need where we need to set up LS for the servers where we use NAS for backups. As NAS is shared between Primary and Secondary there will not be a need to use LS COpy job as backups will be ...
2
votes
4answers
4k views

Log Shipping or Always on as DR for SQL Failover CLuster

Which is easier to maintain as Disaster Recovery on a remote site for a 2-node SQL Server Cluster Log Shipping Single Instance of Always on Availability Group Instance. Any suggestion will be ...
0
votes
1answer
178 views

Log Shipping with Clustered Instance- back up

Current Set up- Clustered Instance Active/Passive Node -1 Node -2 Current Back ups goes to Network Drive Cluster Drive E drive Virtual Name ABC Shared Folder - e\Share New instance- for Log ...
1
vote
1answer
178 views

sp_AllNightLog - running on an existing SQL server

I am trying to get sp_AllNightLog running on an existing server that had regular SQL log shipping (now removed) and Ola Hallengren's backup utility for nightly backups. I have the procs and jobs ...
2
votes
1answer
305 views

How to ensure the quick switch from Log shipping to Mirror in SQL Server 2012

Need some Guidance/steps or any reference to link on how safety and quickly can I switch from Log-shipping to Mirroring as we have very small downtime to complete the activity [5-10 mins]. Also how ...
2
votes
1answer
492 views

Log shipping Primary database log backup job failing/stuck

We have set up LS to do cutover from standalone SQL server 2012 to clustered 2012 servers. The primary database where we have set up LS is also involved in database mirroring and is about 1.8 TB in ...
0
votes
2answers
66 views

all of the databases recovery models changed

i logged into a client's server today(which had log shipping for all of its db's), and found that someone changed all the databases recovery models to simple. so now i need to reconfigure the log ...
1
vote
1answer
109 views

SQL server log shipping - dry-run data modification script on secondary then resume log shipping

Am log shipping a large, busy DB from server A (primary) to server B (secondary). Nightly backups are taken, as well as diffs every X hours, and transaction logs are shipped and restored every 15 ...
1
vote
1answer
289 views

SQL Server best option for low-cost high-availability and queryable secondary?

We have a heavily used database server (SQL 2012 Web edition) which is currently a single point of failure (nightly backups and no additional hardware provisioned!) The server has a constant stream ...
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 ...
2
votes
1answer
372 views

Log Shipping Standby mode

I have setup log shipping with standby mode to ship every 15 minutes, but when the log is restored on the secondary server it kills any currently executing queries. Is it possible to setup the ...
0
votes
1answer
596 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'...
1
vote
1answer
680 views

Mirroring and log shipping together

We are using SQL Mirroring as an HA solution and Log Shipping as a DR solution. Recently, the mirror database has been configured as a log shipping primary (the mirror/primary database) to allow log ...
1
vote
2answers
1k views

Log Shipping: two secondary DBs on the same instance - is this possible?

This is a bit insane, I'll explain intention later: Scenario: + instance_1: one database (LS_source) configured as primary for log shipping + instance_2: two databases (dest_1, dest_2) as secondaries ...
3
votes
1answer
2k views

Log Shipping: Bulk Remove Alerts of already deleted primary and secondary databases

I'm facing a rather strange issue with Transaction Log Shipping reports in SSMS which is showing multiple red alerts of databases that have been created and deleted while performing multiple Log ...
4
votes
2answers
310 views

Problem joining log-shipped secondaries in STANDBY to AlwaysOn group

I have a configuration where one database is log shipping to three different servers hosted in a disaster recovery site. These three disaster recovery servers are joined to the same AlwaysOn ...
-4
votes
1answer
106 views

SQL Server LSCopy Job

Is the LSCopy job needed? Can the LSCopy job be disabled, pointing the LSRestore job to the location the Transaction logs are placed?
0
votes
1answer
115 views

Log shipping confusion

I have a database that is currently shipping log files to a standby server. I ship the log from the primary to the standby every 5 minutes Every 15 minutes, a restore Agent Job runs on the standby ...
1
vote
1answer
101 views

High availability SharePoint farm with restricted conditions

Currently, our SharePoint farm has restricted conditions as below Shared folder is not allowed FTP/SFTP is not allowed SQL FILESTREAM is not allowed SMB protocol is not allowed Using Windows Server ...
1
vote
1answer
2k views

Configuring log shipping with one primary and two secondary instances

I have three SQL Server instances (SQLInstance-1, SQLInstance-2, and SQLInstance-3).I want configure three (or more) servers: SQLServer-1 – primary SQLServer-2 – secondary SQLServer-3 – secondary I ...
3
votes
1answer
2k views

Restoring Job failed with error 'Could not find a log backup file that could be applied' on Log Shipping in SQL Server (Secondary)?

Recently I configured Log shipping between 2 different servers (all SQL Server 2008 R2), from primary to secondary (2 instances). Log shipping configured successfully and databases on secondary ...
3
votes
1answer
1k views

SQL Server 2016 full backup and log shipping and newbie questions

As most likely in a lot of places, I find myself in the roll of "DBA" by default rather than by skill. I currently am setting up new SQL Servers using SQL Server 2016 Standard Edition. I have been ...
1
vote
0answers
310 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 ...
2
votes
3answers
1k views

User mapping to a standby database

I have a standby database that is being restored in standby mode using log-shipped transaction files downloaded from a vendor's sFTP site on a daily basis. Now, I am required to give a read-only ...
1
vote
1answer
76 views

Unexpected Log Shipping Error

I was trying to Configure Log shipping through SSMS (SQL server Management Studio) in between Failover Cluster Instance (Principal Server) and Standalone (Secondary Server), Once I click OK button to ...
2
votes
0answers
774 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
vote
1answer
417 views

Log shipping restore speed & index rebuild vs reorganize

Does the log shipping server restore a transaction log backup faster if the index on primary server are rebuilt or reorganized? On the log shipping server the restores are fast in phase one but seem ...
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
266 views

Howto setup LogShipping properly

I want to use logshipping to transfer large databases (400-700 GB size) from Server (and storage) A to Server (and storage) B. I tried this several times and it worked. But I have questions about ...
3
votes
1answer
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 ...
3
votes
1answer
468 views

Log Shipping Backup Successful Restore Errors

We have a Log Shipping scenario where the log Backups are backed up from the Primary server directly to a Third server (using a UNC path), the backups are then copied from here to the Secondary server ...
0
votes
1answer
298 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
1answer
346 views

Log Shipping: Unable to change from Standby mode to No Recovery mode [closed]

I have tried to change the mode from standby to no recovery in log shipping environment. But the restore job fails automatically. And it did not change to restoring mode. Can anyone help me to resolve ...
1
vote
1answer
2k views

Failover and Failback SQL Server Log Shipping [closed]

I had a question on Log shipping Manual Fail over Let me explain about environment, Primary Server A (with Cluster setup A-P Mode) Secondary server B(DR server standalone). We had enabled Log ...
0
votes
1answer
291 views

Secondary standby server log shipping backup job error [closed]

I am getting the following error while my log shipping job is trying to copy from the primary server: C:\Program Files\Microsoft SQL Server\110\Tools\Binn>sqllogship.exe -copy C83E29 23-5131-4767-...
0
votes
0answers
884 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
1answer
162 views

sqllogship.exe - how to get it to encrypt log file when backing up log on source server?

SQL Server 2014 and 2016, standard edition: How do I get sqllogship.exe to use built in sql server encryption when backing up and restoring log? (as part of minute to minute log shipping)
1
vote
1answer
2k views

Log shipping copying job login failed

Trying to setup log shipping between two SQL Server 2016 servers using the built-in wizard (right click database > Tasks > Ship Transaction Logs). Wizard succeeds, backup job runs fine, copy/restore ...
3
votes
1answer
885 views

Log Shipping always fails, after a while

I have a problem with Transaction Log Shipping on the SQL Server 2014 edition. I have to log ship 4 databases, 2 of them are fine and the other 2 ALWAYS fail but not at first. When it fails, SQL ...
4
votes
1answer
3k views

Log shipping restore job failing

Created a transaction log shipping configuration between two SQL Servers (different VMs) using the built in wizard. Backup job runs on primary server, copy and restore jobs run on secondary server. ...

1 2
3
4 5
7