Questions tagged [log-shipping]
Transferring log records from a source database system to one or more destination systems.
319
questions
3
votes
1
answer
614
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 ...
user157965
0
votes
1
answer
701
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--&...
user157484
0
votes
0
answers
26
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 ...
- 1,962
2
votes
1
answer
1k
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)...
- 1,962
2
votes
1
answer
190
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 ...
user129291
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
1
answer
2k
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 ...
user129291
1
vote
1
answer
1k
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 ...
user129291
0
votes
1
answer
1k
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.
...
user129291
1
vote
1
answer
1k
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.
...
user129291
1
vote
1
answer
952
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 ...
user129291
1
vote
1
answer
342
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)
...
- 193
1
vote
1
answer
1k
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 ...
- 149
7
votes
1
answer
231
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 ...
- 1,019
0
votes
1
answer
657
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 ...
- 1,019
2
votes
1
answer
160
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 ...
- 1,019
0
votes
2
answers
84
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
2
answers
162
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
1
answer
339
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 ...
- 11
0
votes
0
answers
283
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)...
- 633
0
votes
1
answer
86
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 ...
- 1,019
0
votes
1
answer
372
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,149
2
votes
4
answers
6k
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 ...
- 1,019
0
votes
1
answer
223
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,019
1
vote
1
answer
192
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 ...
- 11
2
votes
1
answer
349
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,149
2
votes
1
answer
613
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 ...
- 2,149
0
votes
2
answers
74
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 ...
- 325
1
vote
1
answer
132
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 ...
- 399
1
vote
1
answer
385
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 ...
- 859
0
votes
0
answers
128
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 ...
- 103
2
votes
1
answer
431
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 ...
- 21
0
votes
1
answer
803
views
SQL Server Log Shipping restore fail - The Log Is too recent to apply [closed]
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
1
vote
1
answer
829
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 ...
- 69
1
vote
2
answers
2k
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 ...
- 111
3
votes
1
answer
3k
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 ...
- 33
4
votes
2
answers
348
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 ...
- 75
-4
votes
1
answer
223
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?
- 21
0
votes
1
answer
127
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 ...
- 197
1
vote
1
answer
120
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 ...
- 113
1
vote
1
answer
3k
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 ...
- 1,457
3
votes
1
answer
3k
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 ...
- 1,457
3
votes
1
answer
2k
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 ...
- 197
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 ...
2
votes
3
answers
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 ...
- 41
1
vote
1
answer
93
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 ...
- 1,457
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
1
vote
1
answer
473
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 ...
- 93
0
votes
1
answer
276
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 ...
- 4,697
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