Log shipping error 
Author Message
 Log shipping error
I setup log shipping to remote server and getting this
error during  log restore job.
 The log in this backup set terminates at LSN
3007000000720200001, which is too early to apply to the
database. A more recent log backup that includes LSN
3082000000006500001 can be restored. [SQLSTATE 42000]
(Error 4326)  RESTORE LOG is terminating abnormally.
[SQLSTATE 42000] (Error 3013).  
I can manually apply the log (SQL 2K,SP3)


Mon, 15 Aug 2005 22:36:02 GMT
 Log shipping error

I think some of your log sequence is missing or you might
have done some non logged operation(SQL 7.0)in which case
there is a gap in transaction log sequence. If that is the
case then restore full/diff. backup on the destination
server before you resume log shipping. Also make sure
while transction log backup is restored on standby server
it is not accessed by any user.

--Vishal.

Quote:
>-----Original Message-----
>I setup log shipping to remote server and getting this
>error during  log restore job.
> The log in this backup set terminates at LSN
>3007000000720200001, which is too early to apply to the
>database. A more recent log backup that includes LSN
>3082000000006500001 can be restored. [SQLSTATE 42000]
>(Error 4326)  RESTORE LOG is terminating abnormally.
>[SQLSTATE 42000] (Error 3013).  
>I can manually apply the log (SQL 2K,SP3)

>.



Tue, 16 Aug 2005 06:03:20 GMT
 Log shipping error
This is the first log after database backup and there is
no
Non-logged operation.
I can manually restore the log but automated process is
failing with this error

Quote:
>-----Original Message-----
>I think some of your log sequence is missing or you might
>have done some non logged operation(SQL 7.0)in which case
>there is a gap in transaction log sequence. If that is
the
>case then restore full/diff. backup on the destination
>server before you resume log shipping. Also make sure
>while transction log backup is restored on standby server
>it is not accessed by any user.

>--Vishal.
>>-----Original Message-----
>>I setup log shipping to remote server and getting this
>>error during  log restore job.
>> The log in this backup set terminates at LSN
>>3007000000720200001, which is too early to apply to the
>>database. A more recent log backup that includes LSN
>>3082000000006500001 can be restored. [SQLSTATE 42000]
>>(Error 4326)  RESTORE LOG is terminating abnormally.
>>[SQLSTATE 42000] (Error 3013).  
>>I can manually apply the log (SQL 2K,SP3)

>>.

>.



Tue, 16 Aug 2005 06:48:32 GMT
 Log shipping error
Have u unchecked trunc. log on chkpt. option?? for the
database. what version of sql is it??

--Vishal.

Quote:
>-----Original Message-----
>This is the first log after database backup and there is
>no
>Non-logged operation.
>I can manually restore the log but automated process is
>failing with this error

>>-----Original Message-----
>>I think some of your log sequence is missing or you
might
>>have done some non logged operation(SQL 7.0)in which
case
>>there is a gap in transaction log sequence. If that is
>the
>>case then restore full/diff. backup on the destination
>>server before you resume log shipping. Also make sure
>>while transction log backup is restored on standby
server
>>it is not accessed by any user.

>>--Vishal.
>>>-----Original Message-----
>>>I setup log shipping to remote server and getting this
>>>error during  log restore job.
>>> The log in this backup set terminates at LSN
>>>3007000000720200001, which is too early to apply to the
>>>database. A more recent log backup that includes LSN
>>>3082000000006500001 can be restored. [SQLSTATE 42000]
>>>(Error 4326)  RESTORE LOG is terminating abnormally.
>>>[SQLSTATE 42000] (Error 3013).  
>>>I can manually apply the log (SQL 2K,SP3)

>>>.

>>.

>.



Tue, 16 Aug 2005 07:25:41 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. LOG Shipping Error 14424..?

2. Log Shipping error Out Of Sync

3. Log shipping error

4. Log Shipping Error (3202)

5. Log shipping error

6. Log Shipping Errors (ITG?) with BORK CD

7. Log Shipping error !!! HELP

8. Log Shipping - Error 4305 - FAO OF Purna Gathani

9. Log Shipping Errors

10. Log Shipping errors

11. Log shipping error HELP !!!!

12. Log shipping error


 
Powered by phpBB® Forum Software