Log Shipping setup problem - no restore

Question

Post reply

Log Shipping setup problem - no restore

Ludo-ZX7R

SSCrazy

Points: 2882
More actions
June 9, 2010 at 2:15 am

#223570

Hi
I must be doing something stupid here but this issue drives me absolutely insane!!
I have 2 servers:
- Server 1: Live database
- Server 2: backup database
On Server1 I have the T:\Logshipping directory which is shared as \\10.0.0.XX\Logshipping and can be seen by Server2.
On Server2 I have another D:\Logshipping directory where I want the transaction logs to be copied.
Backup Settings:
- Network Path to backup folder: \\10.0.0.XX\Logshipping
- Backup folder on the primary server: T:\Logshipping
The secondary server is setup with the standby database, ... and in the "Copy files" tab I put D:\Logshipping as the Destination folder.
In this configuration, I managed to perform a full backup, restore, ... but every time the transaction log restore job starts it says it has nothing to process.
All the logs are on Server1 in the T:|Logshipping directory but there are no file in the D:\Logshipping directory on the seconday server.
Help please ...

Viewing 5 posts - 1 through 4 (of 4 total)

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

Ludo-ZX7R SSCrazy Points: 2882 More actions · Answer 1

Hi

Sorry to reply to my own post but I have discovered that the secondary server fails to login to the primary server.

I get login failed for user "TOTO\Server2" [CLIENT: 10.0.0.YYY]

Therefore the files fail to be copied from Server1 to Server2.

Now how can I sort this out?

Ludo-ZX7R SSCrazy Points: 2882 More actions · Answer 2

Solution:

The error appeared in the SQL Server logs but the issue was read permission on the shared drive.

I have modified the SQL Agent Service to user my network user/pwd and all is well.

Cheers

Minaz Amin SSChampion Points: 11052 More actions · Answer 3

When you setup log shipping always use domain account with never expired password.

The domain account should have full access to the tlog backup and tlog copy/restore folders with full control priv.

"More Green More Oxygen !! Plant a tree today"

Ludo-ZX7R SSCrazy Points: 2882 More actions · Answer 4

Thanks for the info.

I was quite pressed for time and used my personal account which password never expires.

However we're in the process of reviewing our database storage and disaster recovery strategy and I will certainly raise this issue to the infrastructure guys so they can create a specific account.

Thanks for replying!