MS SQL Server - Log Shipping

Author

Log Shipping

azimameer@gmail.com

2006-03-14, 8:23 pm

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: & #123;'d:\mssql7\back
up\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: & #123;'d:\mssql7\back
up\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.

Sreejith G

2006-03-15, 3:23 am

You saying logshipping is going ok, and this message is does not look like an
error its
just and informational message(See Event Type: information) saying that Log
restored and
few information like start and end LSN. The log restore happens in a
sequence of LSN number.
i.e LogSequenceNumber, if it does not mactch you will get specific error
message saying,
Error in mismatch of LSN number.

--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]

"azimameer@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: & #123;'d:\mssql7\back
up\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: & #123;'d:\mssql7\back
up\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.
>
>

Sponsored Links