Hi,

I have a question.

We have created a Logshipping (customized).

(We didn't use the logshipping wizard SQL 2000)

On Primary server
The backup strategy is :

Everyday we take a Fullbackup followed by every 15 mins we take transaction log backup.

Day 1:

Full Backup at 12:00 AM
Transaction log backup from 4:00 AM to 11:45 PM

Day 2:

Full Backup at 12:00 AM
Transaction log backup from 4:00 AM to 11:45 PM

Day 3:
.
.
.

On Secondary server

Everyday will restore the full backup daily and followed by the transaction log backup restore with no recovery mode.


Day 1:

Full Backup Restore at 2:00 AM
Transaction log backup Restore from 5:00 AM to 12:45 AM

Day 2:

Full Backup Restore at 2:00 AM
Transaction log backup Restore from 5:00 AM to 12:45 AM

Day 3:
.
.
.


The problem we have is

A third server which is remote need the full backup for the first time only and everyday they need a log backup alone and not the daily fullbackup to logship the server. Will that be possible
using the logs alone for logshipping but not considering the full backup file.

Third server

Like:

One time Full Backup Restore at 4:00 AM


Day 1:

Only
Transaction log backup Restore from 9:00 AM to 4:45 AM

Day 2:

Only
Transaction log backup Restore from 9:00 AM to 4:45 AM

Day 3:
.
.
.


Don't the server throws an error saying that

Msg 4305, Sev 16: The log in this backup set begins at LSN 13000001816200001, which is too late to apply to the database. An earlier log backup that includes LSN 13000001723100001 can be restored. [SQLSTATE 42000]
Msg 3013, Sev 16: RESTORE LOG is terminating abnormally. [SQLSTATE 42000]

We don't know how to fullfil the request. I don't think Logshipping wizard skips the full backup file for logshipping if it has been schedule for full backup everyday and logbackup every 15 mins.

Please help. is there anyway we can solve this problem.


Thanks,
Anu