Log Shipping Transaction log copy and load fails.

Question

Log Shipping Transaction log copy and load fails.

Anandan Siva

SSC Enthusiast

Points: 101
More actions
October 25, 2006 at 6:36 pm

#62826

Hi All,
I have setup log shipping, in the primary server it is backing up the transaction log file to a shared folder on the same machine perfectly. But, in the secondary server, its failing to copy and load the transaction logs. What could be the potential problem?
Our network configuration between primary and secondary, allows communication only thru a single port 1433. I can't event copy the file manually from primary to secondary. Is there any issue in this setting? Do we need extra port opened for this log shipping copy to be automated?
Please advise!
Thanks,
Anand.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Philip Yale-193937 SSCarpal Tunnel Points: 4603 More actions · Answer 1

If you can't physically copy the tranlog files to the 2ary machine, then there could be any number of problems. You should not require additional ports to be opened, and I think the physical file copy problem is most likely to be the thing that needs fixing:

1) Are the two machines in the same Windows domain?

2) Are the SQLServer services running under a domain account? (If they're running as Local Admin then they won't be able to communicate across the network)

3) Are the file permissions correct on the 2ary machine?

We really need more information about what happens when you try to copy the files in order to help. What error message do you get? Is anything being written to the Windows Event log?

Anandan Siva SSC Enthusiast Points: 101 More actions · Answer 2

Hi,

Here my answers are:

1) Are the two machines in the same Windows domain?

No. They run on two different domains.

2) Are the SQLServer services running under a domain account? (If they're running as Local Admin then they won't be able to communicate across the network)

Yes. They run under the domain account.

3) Are the file permissions correct on the 2ary machine?

Yes. The shared folders for trans log has enough privilege for both the system.

4) I receive Windows Event log message as below:

Error: 14421, Severity: 16, State: 1

The log shipping destination DR4-IDCDBSW002.ECHO.CSAACOMDEV is out of sync by 2115 minutes.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

(Where, DR4-IDCDBSW002.ECHO is secondary)

Please Advice!

Thanks,

Anand.

debrucer1 SSCertifiable Points: 5366 More actions · Answer 3

Look at your jobs... I have only seen that when one of them is failing. The failure there may tell you more about what to do.

Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982

Anandan Siva SSC Enthusiast Points: 101 More actions · Answer 4

Thanks for the clue.

Yes I have both the copy and load jobs failed. But I could not find any meaningful clues with that.

I have file share with all privileges. But we have firewall between prod and DR. So, the folders are not visible from each other servers. Only 1433 port is opened right now. Do we need change firewall rule and make this share visible and accessible?

Please Advice!

Thanks,

Anand.

Linda Johanning SSCertifiable Points: 6727 More actions · Answer 5

The copying of files is done by a scheduled job on the secondary server. What is the error there? (Either in the NT log or job history) Does the secondary server have permission to copy the files from the primary? I'd check permissions on the primary server.

Anandan Siva SSC Enthusiast Points: 101 More actions · Answer 6

Thanks for pointing out correctly that the copy job runs on the secondary server. I have requested our system admin team to open up a port for file share. Shared folder have all privileges, but firewall is the issue.

Thanks for the time! Will post you all shortly.