"azimam***@gmail.com" wrote:

> I found that , Log file was not being restored in standby server for
> the past 40 days.
> So i disabled all log shipping jobs which was running earlier.
>
> Last week I created a brandnew log shipping script with 2 jobs and
> enabled these 2 jobs,
> One job willl carry out database backup daily and move the backup to
> standupby server at 4.30 am and restore it in standby server.
>
> Another job will carry out log backup between 8.30 am --- 10 pm , move
> the log backup to standupby server every 10 minutes and restore it in
> standby server.
>
> I checked the count of records in many tables in both active and
> stanbdby server. The record counts are identical which means log
> shipping is working fine .
>
>
> Now i am getting the error as
>
> ****************************************************************************************************************
> Microsoft (R) Windows Script Host Version 5.1 for Windows
> Copyright (C) Microsoft Corporation 1996-1999. All rights reserved.
>
> ************** Last Log Sync Performed *****************
> Log File: Application
> Category: 6
> Event Code: 17055
> Message: 18268 :
> Log restored: Database: prod, creation date and time:
> 2001/12/15(13:26:10), first LSN: 10764:15774:1, last LSN: 10765:120:1,
> striped: 0, number of dump devices: 1, device information: (FILE=1,
> TYPE=DISK: {'d:\mssql7\backup\log\prod\prod_log.bak'}).
>
>
> Source Name: MSSQLServer
> Time Written: 20060314115010.000000-300
> Event Type: information
> User:
> ****************************************************************************************************************
>
>
> Microsoft (R) Windows Script Host Version 5.1 for Windows
> Copyright (C) Microsoft Corporation 1996-1999. All rights reserved.
>
> ************** Last Log Sync Performed *****************
> Log File: Application
> Category: 6
> Event Code: 17055
> Message: 18267 :
> Database restored: Database: prod, creation date and time:
> 2001/12/15(13:26:10), first LSN: 10747:93719:1, last LSN:
> 10747:117237:1, striped: 0, number of dump devices: 1, device
> information: (FILE=1, TYPE=DISK: {'d:\mssql7\backup\prod.bak'}).
>
>
> Source Name: MSSQLServer
> Time Written: 20060314054657.000000-300
> Event Type: information
> User:
> ****************************************************************************************************************
>
>
> I went through
> www.sqlteam.com,
> www.msdn.com,
> www.sqlserverperformance.com,
> www.sqlcentral.com
>
> I couldnot find any solution for it.
>
> Technet has nothing to say on the matter, except to indicate that this
> an error of severity type 10, and I have also checked with other SQL
> sources to no avail.
>
>