MS SQL Server - Transaction Log Backup Failure

Author

Transaction Log Backup Failure

Shri.DBA

2006-02-17, 7:23 am

Hi,

We have a scheduled transaction log backup every 15mins. Today Morning the
backup failed with the below error message.

Error Message
==========
LiteSpeed 2005 Version 4.0.8.1 Copyright (C) 2004, Imceda Software Inc. All
Rights Reserved. www.imceda.com. Registered Name: ANZ Bank BACKUP LOG
successfully processed 0 pages in 0.015 seconds (0.000 MB/sec). Backup
added as file number: 1 [SQLSTATE 01000]
ConnectionRead (recv()). [SQLSTATE 01000]
Msg 11, Sev 16: General network error. Check your network documentation.
[SQLSTATE 08S01]

But the backup ran successfully from the next run.

Below is our SQL Server Config.
====================

1. OS:Windows 2000 Advanced Server
2. SQL Server Details:Multiple Instance Cluster
3. Disk:EMC San
4.RAM: 8GB

Thanks & Regards
Balaji.T

Sreejith G

2006-02-17, 7:23 am

The message says "BACKUP LOG successfully", but a General Network Error
occured. Seems like there wont be any issue with log file. Do you have a DR
server, did the loag load went ok for this particular log?

Thanks,
Sree

"Shri.DBA" wrote:

> Hi,
>
> We have a scheduled transaction log backup every 15mins. Today Morning the
> backup failed with the below error message.
>
> Error Message
> ==========
> LiteSpeed 2005 Version 4.0.8.1 Copyright (C) 2004, Imceda Software Inc. All
> Rights Reserved. www.imceda.com. Registered Name: ANZ Bank BACKUP LOG
> successfully processed 0 pages in 0.015 seconds (0.000 MB/sec). Backup
> added as file number: 1 [SQLSTATE 01000]
> ConnectionRead (recv()). [SQLSTATE 01000]
> Msg 11, Sev 16: General network error. Check your network documentation.
> [SQLSTATE 08S01]
>
> But the backup ran successfully from the next run.
>
> Below is our SQL Server Config.
> ====================

> 1. OS:Windows 2000 Advanced Server
> 2. SQL Server Details:Multiple Instance Cluster
> 3. Disk:EMC San
> 4.RAM: 8GB
>
> Thanks & Regards
> Balaji.T

Sponsored Links