Questions tagged [log-shipping]
Transferring log records from a source database system to one or more destination systems.
319
questions
3
votes
1
answer
511
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 ...
- 141
0
votes
1
answer
410
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, ...
- 11
0
votes
1
answer
471
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 ...
- 199
1
vote
1
answer
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 ...
- 317
0
votes
1
answer
368
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-...
- 125
0
votes
0
answers
1k
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 ...
- 1,820
0
votes
1
answer
204
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
1
answer
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 ...
- 235
3
votes
1
answer
1k
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 ...
- 31
4
votes
1
answer
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.
...
- 235
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 ...
1
vote
1
answer
224
views
Log Shipping from Synchronous Automatic Failover AlwaysOn Availability Group AAG
I have an AlwaysOn Availability Group which is running with Synchronous Commit & Automatic Failover. For example, connected to as SQL01 with nodes SQL01A or SQL01B.
I want to make this data ...
- 11
1
vote
1
answer
1k
views
Define log shipping file locations when using AWS for the secondary server
We are in the process of using an instance within AWS to act as our secondary server. This instance will act as the secondary server in our log shipping process.
How would the "drop" (written by ...
- 13
0
votes
1
answer
283
views
LogShipping and clock change
I have a log shipping process running. Today I realized that the log files must have been overwritten during the clock change period yesterday, where the clock was set back from 3 AM to 2 AM. So I am ...
- 4,697
2
votes
2
answers
2k
views
Fastest way of restoring log shipping of multiple databases
Looking for the fastest way of restoring multiple SQL Server standby databases that got out of sync.
Server A is a production server, has 50 databases configured with LSBACKUP jobs.
Server B is a ...
- 1,324
0
votes
1
answer
505
views
Can i alter a database to single user which is configured in log shipping
We are using a production database (SQL Server 2012) and database compatibility mode is 90 (SQL Server 2005).
Can I alter the database to single user mode and change to 110?
What will be the impact ...
1
vote
1
answer
44
views
Doubt in Log Shipping
Currently, I have setup log shipping from production server to DR server. Now, the doubt is that whenever my production server goes down or lets say data center crashes, I will switch it to DR site. ...
- 31
1
vote
1
answer
1k
views
Sql logshipping Last_restored,last_copied file null in sysjobhistory
I have started log shipping for few dbs from production to DR recently, but it seems like the jobs just keep running and sometimes the copy job copies few files, sometimes it says the files already ...
- 11
3
votes
1
answer
1k
views
Shirking of Log file on Primary Server of Transaction Log shipping
I have a database with size 200 GB Total(mdf+ldf) and Log file(ldf) with 50 GB and 99% unallocated space in ldf file i.e. not being used at all.
We had setup log backups for every 5 minutes, so there ...
- 61
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 ...
3
votes
2
answers
4k
views
Can we shrink datafile of a database which is configured with log shipping
I am using MS SQL Server 2012 version RTM, below is our environment,
I have a primary database Server A and Secondary Database Server B Log shipping configured on A to B of a database,
1) Database ...
- 61
4
votes
2
answers
16k
views
The process cannot access the file because it is being used by another process 2
I have log shipping enabled on my database. I created a file, with let's say logical name 'AB' of 50 MB at location E:\Databases\AB.ndf. However, I later dropped this file and created another file ...
- 525
2
votes
3
answers
11k
views
Read on MDF file failed with reason 15105
The log shipping backup job for one of our databases is failing with the error message:
Read on "D:\Data\Filename.mdf" failed: 1(failed to retrieve text for this error. Reason: 15105)
Attempting ...
- 172
0
votes
1
answer
118
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 ...
1
vote
3
answers
252
views
Problem Configuring Log Shipping for DR Server
Problem Statement - I want to configure DR site in SQL Server 2012 with the existing backups.
The backup scenario is as below.
FULL – on every Sunday,
DIFF – daily except Sunday,
LOG – every 15 ...
- 31
0
votes
1
answer
929
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....
- 1,363
0
votes
1
answer
1k
views
Change path to log shipping folder
We are moving our back-end storage so will need to change the paths for our log shipping. Can we do this without interrupting our log shipping? i.e. Just change the paths in the 'Network path to ...
4
votes
2
answers
3k
views
SQL Server Always On or Mirroring & Log Shipping
We have two data centers with a 2 ms ping time between them connected by a site to site VPN. In the primary data center we have 2 servers, in the secondary data center we have a single database server....
- 173
3
votes
1
answer
4k
views
Temporarily stop Log shipping [closed]
How can I temporarily stop log shipping --> Do the task --> Start the Log shipping ? Is it possible ?
- 1,586
2
votes
3
answers
4k
views
Access to folder is denied (log shipping)
I am trying to log ship from server A to B. I have done everything to configure log shipping but when I try to run the job at Server B while copying a backup from server A, ikt gives me an error:
...
- 39
2
votes
1
answer
65
views
System Database Migration and Security - Log Shipping or DB Mirroring
I've setup log shipping between two servers (they used to be mirrored).
What is the simplest or most efficient way to mirror the system databases between the primary and secondary?
Is it just a ...
- 1,363
0
votes
1
answer
302
views
Log Shipping Disk Sizes
Do the drives that contain the database have to be the exact same size on the primary server as secondary?
I currently have a primary database for OLTP and a standby database used for reporting.
I'm ...
1
vote
2
answers
246
views
SQL Server 2012 cannot use file server for log shipping
I have a problem with log shipping in SQL Server 2012.
I have two servers for log shipping, let's say server A and server B.
For the first experiment, when I use a shared folder from my computer ...
- 35
1
vote
1
answer
328
views
Using a third location for log shipping [closed]
I have a problem with log shipping in SQL Server 2012.
I have tried to configure log shipping between server A and server B. The log destination is on my PC (shared folder). This scenario is working ...
- 35
1
vote
1
answer
4k
views
Log shipping secondaries in STANDBY stuck in 'Restoring...' - SQL Server 2012 SP3
Yesterday, I configured Log shipping between 2 SQL Server 2012 SP3 servers for a total of 13 databases.
Some specifics:
I'm using 'Azure files' to transfer the log files (CIFS accessible BLOB ...
- 113
4
votes
2
answers
2k
views
Unexplained log ship slow down
I have a number of SQL 2008 instances all running Microsoft SQL Server 2008 (SP4) (confirmed with select @@VERSION on the servers in question). They run on either Windows Server 2008 or Windows ...
- 1,053
4
votes
1
answer
1k
views
Clearing Log Shipping config Secondary server inaccessible [duplicate]
We are using SQL 2012
Our Secondary server in a log shipping configuration went offline never to come back (the VM was permanently deleted before log shipping configuration was updated).
On the ...
- 41
0
votes
1
answer
2k
views
Log shipping restore: Only members of the sysadmin fixed server role can perform this operation
On my secondary, I am seeing many messages like these in sysjobhistory from the LSCopy and LSRestore jobs for each database:
Could not log history/error message.(Microsoft.SqlServer.Management....
- 2,130
1
vote
1
answer
66
views
Managing Security for a Log Shipped db across two (unconnected) domains
SQL Server 2008 (soon to be 2012).
We have a vendor that is providing us with log shipped backups of our production database. We use this log shipped database for BI staging, reporting, etc. I've ...
- 754
0
votes
1
answer
3k
views
Backup transaction log from secondary database in alwayson AG
Is it possible to do the log backup from the secondary databases in the AG?
- 621
3
votes
1
answer
1k
views
Secondary log shipped DB becoming suspect after restore of a transaction log
The Configuration
Primary DB SQL Server 2008 R2 SP3 Web Edition running in windows Server 2012 R2 x64 on a local RAID 10 SAS 10k disk array co-located in an enterprise grade datacentre
Secondary DB ...
- 179
3
votes
1
answer
199
views
Is automatic failback on Postgres 8.4 possible via log shipping/PITR?
I have successfully setup continuous archiving and recovery of a master and slave node with PostgreSQL 8.4 via log shipping. I'm using keepalived to monitor both nodes and I can successfully trigger ...
- 133
2
votes
1
answer
148
views
Transaction log rollback broke Log Shipping chain? [closed]
Is it correct that performing a transaction log restore to a previous point in time will break the log shipping chain?
If this is correct, is there a way to recover from this situation without having ...
- 247
0
votes
1
answer
2k
views
Setting up log shipping with an availability group
In my production environment I have a SQL Server 2012 AlwaysOn AG.
The Server1 there is database "MessagesDB" and in an AG to secondary Server2 (in synchronous mode).
I want to setup log shipping ...
- 621
2
votes
1
answer
1k
views
Log Shipping vs Data Replication in SQL Server 2012
Just wonder if anyone has tried to use Log Shipping on SQL Server 2012 collecting data from SQL Server 2008R2 and SQL Server 2005 databases? I heard it would be an easier option to implement compared ...
- 133
0
votes
1
answer
637
views
Log Shipping- Can I alter the schema of a table that is being used in the secondary instance?
We have two SQL Server instances with log shipping set on a database.
Can I alter the schema (add columns, remove columns etc.) of the table in the Primary instance/db while the table is being used in ...
1
vote
1
answer
1k
views
Transaction Log file of the secondary database in Log Shipping grows fast and fills up disk space [duplicate]
I have a log shipping setup for DR. The transaction log file of one of the secondary databases, which is in restoring mode, is 7 times larger than the data file and is filling up the disk space. What ...
- 11
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
1
answer
709
views
Can Log Shipping be recovered and resumed by scripts after DR?
Server A has DB1 log shipping to Server B as DB1_LS in a DR environment. Before the company DR exercise, I scripted out the log shipping configuration from DB1 properties window so I basically got one ...
- 9
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