Veritas-bu

[Veritas-bu] FW: SQL Backup

2002-04-16 14:34:22
Subject: [Veritas-bu] FW: SQL Backup
From: Dmitri.Smirnov AT roundheaven DOT com (Dmitri Smirnov)
Date: Tue, 16 Apr 2002 11:34:22 -0700
This is a multi-part message in MIME format.

------_=_NextPart_001_01C1E575.541DBD3A
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Having exactly the same message for a month (and case in Veritas =
support). There is no progress. All recommended actions about a network =
(number of open ports on firewall,
TCP wait interval, etc).=20
Started to get nervous about it (no completed backup for a months =
already).
This messages related to server error: "timeout connecting to a =
client)... I have one job from about 10 failed for SQL backup.
If anybody knows how to fix it please help.
=20
P.S: This is sad but my average time to resolve a problem in Veritas is =
few month (usually related to Win2k clients/agents).=20
Need an advice - how to deal with this problem  - escalate case more =
often, buy more expensive support, etc?
=20
Dmitri
=20

-----Original Message-----
From: Huzefa Zakir [mailto:hzakir AT swbanktx DOT com]
Sent: Monday, April 15, 2002 3:15 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] FW: SQL Backup



I was wondering if any one has seen these errors with SQL DB Backup with =
Veritas SQL Agents, and can shade some light.......

Also, does anyone know how the Veritas SQL Agent interacts with the SQL =
DB when it's doing SQL DB backups ?=20

Thanks.=20

*************************************************************************=
*****************=20
Event Type:     Error=20
Event Source:   MSSQLServer=20
Event Category: Kernel=20
Event ID:       17055=20
Date:           4/11/2002=20
Time:           2:17:12 AM=20
User:           IMAGE\netback=20
Computer:       SWBTIVR1=20
Description:=20
18210 :=20
BackupMedium::ReportIoError: write failure on backup device =
'VNBU0-787-768'. Operating system error 995(The I/O operation has been =
aborted because of either a thread exit  or an application request.).


Data:=20
0000: 22 47 00 00 10 00 00 00   "G......=20
0008: 09 00 00 00 53 00 57 00   ....S.W.=20
0010: 42 00 54 00 49 00 56 00   B.T.I.V.=20
0018: 52 00 31 00 00 00 00 00   R.1.....=20
0020: 00 00                     ..     =20
*************************************************************************=
*****************=20

Event Type:     Error=20
Event Source:   MSSQLServer=20
Event Category: Kernel=20
Event ID:       17055=20
Date:           4/11/2002=20
Time:           2:16:49 AM=20
User:           IMAGE\netback=20
Computer:       SWBTIVR1=20
Description:=20
18210 :=20
BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup =
device 'VNBU0-787-742'. Operating system error 995(The I/O operation has =
been aborted because of either a thread exit  or an application =
request.).


Data:=20
0000: 00004722 00000010 00000009 00570053=20
0010: 00540042 00560049 00310052 00000000=20
0020: 0000=20

*************************************************************************=
*******************=20

Huzefa Zakir=20
IT Systems  Engineer=20
SouthWest Bank Of Texas=20
*       (713) 232 - 6763=20
*  (713) 232 - 8583  (fax)=20
*  hzakir AT swbanktx DOT com=20




CONFIDENTIALITY NOTICE:

************************************************************************

The information contained in this ELECTRONIC MAIL transmission
is confidential. It may also be privileged work product or proprietary
information. This information is intended for the exclusive use of the
addressee(s). If you are not the intended recipient, you are hereby
notified that any use, disclosure, dissemination, distribution [other
than to the addressee(s)], copying or taking of any action because
of this information is strictly prohibited.

************************************************************************



------_=_NextPart_001_01C1E575.541DBD3A
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>FW: SQL Backup</TITLE>

<META content=3D"MSHTML 6.00.2712.300" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D891472418-16042002><FONT face=3DArial color=3D#0000ff =
size=3D2>Having=20
exactly the same message for a month (and case in Veritas support). =
There is no=20
progress. All recommended actions about a network (number of open ports =
on=20
firewall,</FONT></SPAN></DIV>
<DIV><SPAN class=3D891472418-16042002><FONT face=3DArial color=3D#0000ff =
size=3D2>TCP=20
wait interval, etc). </FONT></SPAN></DIV>
<DIV><SPAN class=3D891472418-16042002><FONT face=3DArial color=3D#0000ff =

size=3D2>Started to get nervous about it (no completed backup for a =
months=20
already).</FONT></SPAN></DIV>
<DIV><SPAN class=3D891472418-16042002><FONT face=3DArial color=3D#0000ff =
size=3D2>This=20
messages related to server error: "timeout connecting to a client)... I =
have one=20
job from about 10 failed for SQL backup.</FONT></SPAN></DIV>
<DIV><SPAN class=3D891472418-16042002><FONT face=3DArial color=3D#0000ff =
size=3D2>If=20
anybody knows how to fix it please help.</FONT></SPAN></DIV>
<DIV><SPAN class=3D891472418-16042002><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D891472418-16042002><FONT face=3DArial color=3D#0000ff =
size=3D2>P.S:=20
This is sad but my average time to resolve a problem in Veritas is few =
month=20
(usually related to Win2k clients/agents). </FONT></SPAN></DIV>
<DIV><SPAN class=3D891472418-16042002><FONT face=3DArial color=3D#0000ff =
size=3D2>Need=20
an advice&nbsp;- how to deal with this problem &nbsp;- escalate case =
more often,=20
buy more expensive support, etc?</FONT></SPAN></DIV>
<DIV><SPAN class=3D891472418-16042002><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D891472418-16042002><FONT face=3DArial color=3D#0000ff =

size=3D2>Dmitri</FONT></SPAN></DIV>
<DIV><SPAN class=3D891472418-16042002><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN>&nbsp;</DIV>
<BLOCKQUOTE>
  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> Huzefa Zakir=20
  [mailto:hzakir AT swbanktx DOT com]<BR><B>Sent:</B> Monday, April 15, 2002 =
3:15=20
  PM<BR><B>To:</B> veritas-bu AT mailman.eng.auburn DOT 
edu<BR><B>Subject:</B>=20
  [Veritas-bu] FW: SQL Backup<BR><BR></FONT></DIV>
  <P><FONT face=3DArial size=3D2>I was wondering if any one has seen =
these errors=20
  with SQL DB Backup with Veritas SQL Agents, and can shade some=20
  light.......</FONT></P>
  <P><FONT face=3DArial size=3D2>Also, does anyone know how the Veritas =
SQL Agent=20
  interacts with the SQL DB when it's doing SQL DB backups ?</FONT> </P>
  <P><FONT face=3DArial size=3D2>Thanks.</FONT> </P>
  <P><FONT face=3D"Courier New"=20
  =
size=3D2>****************************************************************=
**************************</FONT>=20
  <BR><FONT face=3D"Courier New" size=3D2>Event =
Type:&nbsp;&nbsp;&nbsp;&nbsp;=20
  Error</FONT> <BR><FONT face=3D"Courier New" size=3D2>Event =
Source:&nbsp;&nbsp;=20
  MSSQLServer</FONT> <BR><FONT face=3D"Courier New" size=3D2>Event =
Category: Kernel=20
  </FONT><BR><FONT face=3D"Courier New" size=3D2>Event=20
  ID:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17055</FONT> <BR><FONT=20
  face=3D"Courier New" size=3D2>Date:&nbsp;&nbsp;=20
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/11/2002</FONT> <BR><FONT=20
  face=3D"Courier New" size=3D2>Time:&nbsp;&nbsp;=20
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2:17:12 AM</FONT> <BR><FONT =

  face=3D"Courier New" size=3D2>User:&nbsp;&nbsp;=20
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IMAGE\netback</FONT> =
<BR><FONT=20
  face=3D"Courier New" =
size=3D2>Computer:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  SWBTIVR1</FONT> <BR><FONT face=3D"Courier New" =
size=3D2>Description:</FONT>=20
  <BR><FONT face=3D"Courier New" size=3D2>18210 :</FONT> <BR><FONT=20
  face=3D"Courier New" size=3D2>BackupMedium::ReportIoError: write =
failure on backup=20
  device 'VNBU0-787-768'. Operating system error 995(The I/O operation =
has been=20
  aborted because of either a thread exit&nbsp; or an application=20
  request.).</FONT></P>
  <P><FONT face=3D"Courier New" size=3D2></FONT> <BR><FONT =
face=3D"Courier New"=20
  size=3D2>Data:</FONT> <BR><FONT face=3D"Courier New" size=3D2>0000: 22 =
47 00 00 10=20
  00 00 00&nbsp;&nbsp; "G......</FONT> <BR><FONT face=3D"Courier New" =
size=3D2>0008:=20
  09 00 00 00 53 00 57 00&nbsp;&nbsp; ....S.W.</FONT> <BR><FONT=20
  face=3D"Courier New" size=3D2>0010: 42 00 54 00 49 00 56 =
00&nbsp;&nbsp;=20
  B.T.I.V.</FONT> <BR><FONT face=3D"Courier New" size=3D2>0018: 52 00 31 =
00 00 00 00=20
  00&nbsp;&nbsp; R.1.....</FONT> <BR><FONT face=3D"Courier New" =
size=3D2>0020: 00=20
  =
00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  ..&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT><BR><FONT face=3D"Courier New" =

  =
size=3D2>****************************************************************=
**************************</FONT>=20
  </P>
  <P><FONT face=3D"Courier New" size=3D2>Event =
Type:&nbsp;&nbsp;&nbsp;&nbsp;=20
  Error</FONT> <BR><FONT face=3D"Courier New" size=3D2>Event =
Source:&nbsp;&nbsp;=20
  MSSQLServer</FONT> <BR><FONT face=3D"Courier New" size=3D2>Event =
Category: Kernel=20
  </FONT><BR><FONT face=3D"Courier New" size=3D2>Event=20
  ID:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17055</FONT> <BR><FONT=20
  face=3D"Courier New" size=3D2>Date:&nbsp;&nbsp;=20
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/11/2002</FONT> <BR><FONT=20
  face=3D"Courier New" size=3D2>Time:&nbsp;&nbsp;=20
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2:16:49 AM</FONT> <BR><FONT =

  face=3D"Courier New" size=3D2>User:&nbsp;&nbsp;=20
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IMAGE\netback</FONT> =
<BR><FONT=20
  face=3D"Courier New" =
size=3D2>Computer:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  SWBTIVR1</FONT> <BR><FONT face=3D"Courier New" =
size=3D2>Description:</FONT>=20
  <BR><FONT face=3D"Courier New" size=3D2>18210 :</FONT> <BR><FONT=20
  face=3D"Courier New" =
size=3D2>BackupVirtualDeviceFile::RequestDurableMedia: Flush=20
  failure on backup device 'VNBU0-787-742'. Operating system error =
995(The I/O=20
  operation has been aborted because of either a thread exit&nbsp; or an =

  application request.).</FONT></P>
  <P><FONT face=3D"Courier New" size=3D2></FONT> <BR><FONT =
face=3D"Courier New"=20
  size=3D2>Data:</FONT> <BR><FONT face=3D"Courier New" size=3D2>0000: =
00004722=20
  00000010 00000009 00570053</FONT> <BR><FONT face=3D"Courier New" =
size=3D2>0010:=20
  00540042 00560049 00310052 00000000</FONT> <BR><FONT face=3D"Courier =
New"=20
  size=3D2>0020: 0000</FONT> </P>
  <P><FONT face=3D"Courier New"=20
  =
size=3D2>****************************************************************=
****************************</FONT>=20
  </P>
  <P><B><FONT face=3D"Arial Rounded MT Bold" color=3D#666699>Huzefa =
Zakir</FONT></B>=20
  <BR><I><FONT face=3D"Arial Rounded MT Bold" color=3D#666699 =
size=3D2>IT=20
  Systems&nbsp; Engineer</FONT></I> <BR><FONT face=3D"Arial Rounded MT =
Bold"=20
  color=3D#008000 size=3D2>SouthWest Bank Of Texas</FONT> <BR><FONT =
face=3DWingdings=20
  color=3D#ff0000 size=3D2>(<FONT=20
  face=3D"Courier =
New">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT></FONT> <FONT=20
  face=3D"Arial Rounded MT Bold" color=3D#666699 size=3D2>(713) 232 - =
6763</FONT>=20
  <BR><FONT face=3DWebdings color=3D#ff0000>=CA</FONT><FONT=20
  face=3D"Arial Rounded MT Bold" color=3D#ff0000>&nbsp;</FONT> <FONT=20
  face=3D"Arial Rounded MT Bold" color=3D#666699 size=3D2>(713) 232 - =
8583&nbsp;=20
  (fax)</FONT> <BR><FONT face=3DWingdings color=3D#0000ff =
size=3D2>-</FONT><FONT=20
  face=3D"Arial Rounded MT Bold" size=3D2>&nbsp; </FONT><FONT=20
  face=3D"Arial Rounded MT Bold" color=3D#666699 =
size=3D2>hzakir AT swbanktx DOT com</FONT>=20
  </P><BR><CODE><FONT size=3D3><BR><BR>CONFIDENTIALITY=20
  =
NOTICE:<BR><BR>**********************************************************=
**************<BR><BR>The=20
  information contained in this ELECTRONIC MAIL transmission<BR>is =
confidential.=20
  It may also be privileged work product or proprietary<BR>information. =
This=20
  information is intended for the exclusive use of the<BR>addressee(s). =
If you=20
  are not the intended recipient, you are hereby<BR>notified that any =
use,=20
  disclosure, dissemination, distribution [other<BR>than to the =
addressee(s)],=20
  copying or taking of any action because<BR>of this information is =
strictly=20
  =
prohibited.<BR><BR>******************************************************=
******************<BR></BLOCKQUOTE></FONT></CODE></BODY></HTML>

------_=_NextPart_001_01C1E575.541DBD3A--

<Prev in Thread] Current Thread [Next in Thread>