Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [log-shipping]

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

0
votes
1answer
22 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
votes
2answers
48 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 ...
1
vote
1answer
42 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) ...
1
vote
1answer
41 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
vote
2answers
391 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 ...
0
votes
1answer
19 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
vote
1answer
36 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 ...
0
votes
3answers
49 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 ...
1
vote
1answer
22 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 ...
-1
votes
0answers
25 views

Two SQL Transaction log backups and one of them copy only

We have two different Transaction log backups and one of them copy only. Copy-only triggered from Veeam backup tool. Normal one from SQL native one. I would like to configure Log shipping for all the ...
0
votes
1answer
38 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 ...
0
votes
2answers
47 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 ...
1
vote
1answer
60 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
vote
0answers
55 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 ...
0
votes
1answer
49 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? ...
2
votes
1answer
317 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: ...
1
vote
1answer
36 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 ...
1
vote
0answers
29 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 ...
1
vote
1answer
23 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
vote
1answer
44 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 ...
1
vote
1answer
174 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. ...
0
votes
0answers
68 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
votes
3answers
114 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 ...
0
votes
0answers
41 views

Log shipping doesnt copy data across

I have set up the log shipping process and can see all 3 jobs running successfully. Primary server - LSBackup_DatabaseName Secondary server - LSCopy_SERVERNAME_DatabaseName & ...
1
vote
1answer
26 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 ...
3
votes
1answer
120 views

SQL Log Shipping Read Only/Standby Different users

I have a primary OLTP server on Server A and Log Shipping in Standby/Readonly mode on Server B. Log Shipping Server is refreshed every 4 hours, and utilized for BI Reporting Analysis, to reduce load ...
0
votes
1answer
60 views

Email SSMS Log Shipping Status Report

We use Log Shipping to allow Business Analysis users to query data. I would like to email the Log Shipping Status report to users to see last time data is refreshed. When I Right Click on Server--&...
0
votes
0answers
19 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 ...
2
votes
1answer
116 views

Log Shipping - Secondary Database - Can CDC be enabled?

I was reading this article about SQL Server log shipping and the statement was made that log shipping supports limited read-only access to secondary databases (during the interval between restore jobs)...
0
votes
0answers
62 views

Log Shipping Error Not Configured for Data Access

I am configuring log shipping , In Pinal's site I try changing login to SA https://blog.sqlauthority.com/2017/12/23/sql-server-msg-32055-sp_refresh_log_shipping_monitor-error-configuring-remote-...
0
votes
1answer
105 views

Log Shipping Server Restart Problem

I have Log Shipping setup from Primary Server A to Destination B. Server B is both Destination and Monitoring server. Yesterday, we restarted both servers around the same time for patching. On the Log ...
1
vote
0answers
65 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 ...
0
votes
1answer
314 views

Transaction Log Shipping Primary Server Status not Shown on Secondary Monitoring Server

I setup Log Shipping. I have Secondary Destination Server as Monitoring server also. For some reason when running this system stored procedure or looking at Server-->Reports-->Transaction Log Shipping ...
1
vote
1answer
247 views

Should I have both Transaction Log Backups and Log Shipping

I set my database to Full Recovery a few months ago (to allow point-in-time restores) and set up Transaction Log backups with Maintenance Plan. Now we want to conduct Log Shipping with the same ...
-1
votes
1answer
242 views

Log Shipping Monitor Server Instance

We plan to incorporate Log Shipping for basic disaster recovery with reporting needs. Server A Source Database will log ship to Server B database. We will conduct log shipping every few hours. ...
1
vote
1answer
333 views

Log Shipping Backup and Destination Folder Location [closed]

We plan to incorporate Log Shipping for basic disaster recovery with reporting needs. Server A Source Database will log ship to Server B database. We will conduct log shipping every four hours. ...
1
vote
1answer
173 views

Log Shipping with Database Snapshot for Read Queries

Company may implement Log Shipping with Snapshot. This provides basic Disaster Recovery with Reporting area. Server A OLTP contains database which log ships to Server B (ReadOnly-Standby), Snapshot is ...
1
vote
1answer
63 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
217 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 ...
6
votes
1answer
114 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
166 views

Log Shipping failover when Primary is not accessible

Log Shipping Failover 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 failover will be 1) Copy ...
2
votes
1answer
40 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
66 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
56 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
2answers
85 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
1answer
87 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
47 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
76 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
649 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
54 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 ...