Questions tagged [log-shipping]

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

Filter by
Sorted by
Tagged with
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. ...
2
votes
0answers
641 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
1answer
211 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 ...
1
vote
1answer
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 ...
0
votes
1answer
218 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 ...
2
votes
2answers
1k 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 ...
0
votes
1answer
404 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
1answer
36 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. ...
1
vote
1answer
968 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 ...
0
votes
0answers
309 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 ...
3
votes
1answer
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 ...
1
vote
0answers
300 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 ...
2
votes
2answers
3k 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 ...
3
votes
2answers
11k 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 ...
2
votes
3answers
8k 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 ...
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 ...
1
vote
3answers
233 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 ...
0
votes
1answer
578 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
1answer
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
2answers
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....
2
votes
1answer
3k views

Temporarily stop Log shipping [closed]

How can I temporarily stop log shipping --> Do the task --> Start the Log shipping ? Is it possible ?
2
votes
3answers
3k 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: ...
2
votes
1answer
62 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 ...
0
votes
1answer
243 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
2answers
210 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 ...
1
vote
1answer
289 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 ...
1
vote
1answer
3k 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 ...
4
votes
2answers
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 ...
4
votes
1answer
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 ...
0
votes
1answer
1k 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....
1
vote
1answer
61 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 ...
0
votes
1answer
2k 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?
2
votes
1answer
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 ...
3
votes
1answer
151 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 ...
2
votes
1answer
136 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 ...
0
votes
1answer
1k 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 ...
2
votes
1answer
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 ...
0
votes
1answer
497 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
1answer
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 ...
2
votes
0answers
155 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
1answer
625 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 ...
1
vote
0answers
376 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
vote
1answer
39 views

Is log shipping good for periodic synchronization?

I have Postgresql 9.3 server on both my laptop and my desktop at home. I keep identical data on both system. Sometimes I work on the database on my laptop while other times I work on the database on ...
9
votes
1answer
969 views

Log Shipping SQL Server 2012

I'm a developer at a small shop that doesn't have a DBA and i'm trying to get log shipping with sql server 2012 working. I'm trying to off load reporting from the transaction system to a new data ...
5
votes
4answers
17k views

Log Shipping “out of sync” but none of the jobs are failing

I've configured a log shipping from a server, to the same server, only with a different instance. Primary server is configured this way: LSBACKUP_MyDatabase - every 25min Secondary server: ...
7
votes
1answer
6k views

Set “Encryption Enabled” to FALSE…what can go wrong?

I'm migrating a database from SQL Server 2012 to SQL Server 2014 on the same server. I'm configuring LOG SHIPPING on a database that is apparently encrypted: When setting the log shipping I got this ...
2
votes
0answers
1k views

What does 'Could not find a log backup file that could be applied' means on log shipping?

Skipped Log Backup File ..... Could not find a log backup file that could be applied to secondary Database What does this mean? I've configured a log shipping. To test, I created 2 tables, put ...
1
vote
0answers
2k views

What Open Ports are Necessary for SQL Server Log Shipping to Secondary on the Internet

Our secondary server will be on the other end of an always on IPSEC tunnel. We need to instruct our customer's firewall/VPN/Server team (they are responsible for the primary). What I've gathered so ...
4
votes
4answers
1k views

How do I fix an Orphaned User in Log Shipped version of a SQL Server 2008 database

Forgive my greenness.. but would appreciate some help on this... We are doing development work on an instance of SQL Server 2008 and have multiple databases on that server that are core to our ...

1 2 3
4
5
7