Veritas-bu

[Veritas-bu] OTM with MSSQL

2001-02-16 16:34:51
Subject: [Veritas-bu] OTM with MSSQL
From: Stephen Dvorak sdvorak AT veritas DOT com
Date: Fri, 16 Feb 2001 13:34:51 -0800
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C09860.4B4947F0
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Frederick,
I have had some success with the following settings for OTM.  =
Specifically
the Quiescent Timeout and Quiescent Wait.  These have to do with the =
time to
wait for a quiescent file system, and the time before we give up and go =
on
without OTM or fail OTM.  Do not go lower then 3 for the wait, and keep =
the
timeout under 300 (otherwise NBU will timeout waiting for data).
=20
Following are the registry values changed under=20
HKEY_LOCAL_MACHINE\Software\VERITAS\NetBackup\CurrentVersion\Config:
OTM_Cache_Control
REG_DWORD
Decimal =3D 0
=20
OTM_Cache_Size_Init
REG_DWORD
Decimal =3D 150
=20
OTM_Cache_Size_Max
REG_DWORD
Decimal =3D 0
=20
# when setting this value to yes, turn off 'allow multiple data =
streams' in
the class
OTM_Current
REG_SZ
YES
=20
OTM_Quiescent_Timeout
REG_DWORD
Decimal =3D 180
=20
OTM_Quiescent_Wait
REG_DWORD
Decimal =3D 3
=20
OTM_Sync_Timeout
REG_DWORD
Decimal =3D 60


-----Original Message-----
From: Fr=E9d=E9rick Coutret [mailto:frederick.coutret AT par.sita DOT int]
Sent: Friday, February 16, 2001 2:22 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] OTM with MSSQL


I already use this to backup SQL files and I removed them for the =
backup.
The Pb is sometimes OTM can't find a Quiescent time to create his Cache =
file
becasue
the MSSQL files are spread on all the logical drives.
=20
Another pb comes from the cache size of OTM. I can change this size but
sometimes it crashes the system ( Blue screen )
without any reason. I also tried to move the cache file to another =
"quiet"
drive without success.
=20
=20
=20

----- Original Message -----=20
From: Bob Bakh <mailto:bbakh AT veritas DOT com> =20
To: Fr=E9d=E9rick Coutret <mailto:frederick.coutret@par1>  ;
veritas-bu AT mailman.eng.auburn DOT edu =
<mailto:veritas-bu AT mailman.eng.auburn DOT edu>

Sent: Friday, February 16, 2001 4:15 PM
Subject: RE: [Veritas-bu] OTM with MSSQL

Exclude your DataBase Files. They can not and should not be backed up =
using
OTM, there is a Microsoft API that NBU uses to backup MS SQL.  It's the =
MS
SQL extension for NetBackup.
=20
Thanks,
=20
Bob

-----Original Message-----
From: Fr=E9d=E9rick Coutret [ mailto:frederick.coutret AT par.sita DOT int
<mailto:frederick.coutret AT par.sita DOT int> ]
Sent: Friday, February 16, 2001 12:23 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
<mailto:veritas-bu AT mailman.eng.auburn DOT edu>=20
Subject: [Veritas-bu] OTM with MSSQL


Hi,
=20
I tried several times to backup NT systems with MSSQL using OTM and I =
always
got problems.
Veritas support just told me I can't backup NT systems with MSSQL using =
OTM
but I tried and found some workaround
by changing OTM parameters.
=20
But now, the old problems are coming back on some NT servers.
Is there is right way to use OTM without any 11 status code ( 1005 or =
1001
errors on OTM ) ?
=20
Thanks,
Frederick
=20


------_=_NextPart_001_01C09860.4B4947F0
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">


<META content=3D"MSHTML 5.50.4611.1300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D614012621-16022001>Frederick,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D614012621-16022001>I have=20
had some success with the following settings for OTM.&nbsp; =
Specifically the=20
Quiescent Timeout and Quiescent Wait.&nbsp; These have to do with the =
time to=20
wait for a quiescent file system, and the time before we give up and go =
on=20
without OTM or fail OTM.&nbsp; Do not go lower then 3 for the wait, and =
keep the=20
timeout under 300 (otherwise NBU will timeout waiting for=20
data).</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D614012621-16022001></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2>Following are the =
registry values=20
changed under=20
<BR>HKEY_LOCAL_MACHINE\Software\VERITAS\NetBackup\CurrentVersion\Config:=
</FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff=20
size=3D2>OTM_Cache_Control<BR>REG_DWORD<BR>Decimal =3D 0</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff=20
size=3D2>OTM_Cache_Size_Init<BR>REG_DWORD<BR>Decimal =3D =
150</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff=20
size=3D2>OTM_Cache_Size_Max<BR>REG_DWORD<BR>Decimal =3D 0</FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT>&nbsp;</DIV>
<DIV><SPAN class=3D614012621-16022001><FONT face=3DArial =
color=3D#0000ff size=3D2># when=20
setting this value to yes, turn off 'allow multiple data streams' in =
the=20
class</FONT></SPAN></DIV>
<DIV><FONT face=3DArial color=3D#0000ff=20
size=3D2>OTM_Current<BR>REG_SZ<BR>YES</FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff=20
size=3D2>OTM_Quiescent_Timeout<BR>REG_DWORD<BR>Decimal =3D =
180</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff=20
size=3D2>OTM_Quiescent_Wait<BR>REG_DWORD<BR>Decimal =3D 3</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff=20
size=3D2>OTM_Sync_Timeout<BR>REG_DWORD<BR>Decimal =3D =
60<BR></FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
  <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> Fr=E9d=E9rick =
Coutret=20
  [mailto:frederick.coutret AT par.sita DOT int]<BR><B>Sent:</B> Friday, =
February 16,=20
  2001 2:22 PM<BR><B>To:</B>=20
  veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> Re: [Veritas-bu] =
OTM with=20
  MSSQL<BR><BR></FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>I already use this to backup SQL =
files and I=20
  removed them for the backup.</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>The Pb is sometimes OTM can't find a =
Quiescent=20
  time to create his Cache file becasue</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>the MSSQL files are spread on all =
the logical=20
  drives.</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>Another pb comes from the cache size =
of OTM. I=20
  can change this size but sometimes it crashes the system ( Blue =
screen=20
  )</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>without any reason.&nbsp;I also =
tried to move the=20
  cache file to another "quiet" drive without success.</FONT></DIV>
  <DIV>&nbsp;</DIV>
  <DIV>&nbsp;</DIV>
  <DIV>&nbsp;</DIV>
  <BLOCKQUOTE=20
  style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
    <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
    <DIV=20
    style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
    <A title=3Dbbakh AT veritas DOT com href=3D"mailto:bbakh AT veritas DOT 
com">Bob =
Bakh</A>=20
    </DIV>
    <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3Dfrederick.coutret@par1=20
    href=3D"mailto:frederick.coutret@par1";>Fr=E9d=E9rick Coutret</A> ; =
<A=20
    title=3Dveritas-bu AT mailman.eng.auburn DOT edu=20
    =
href=3D"mailto:veritas-bu AT mailman.eng.auburn DOT edu">veritas-bu AT mailman 
DOT eng=
.auburn.edu</A>=20
    </DIV>
    <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, February 16, =
2001 4:15=20
    PM</DIV>
    <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: [Veritas-bu] =
OTM with=20
    MSSQL</DIV>
    <DIV><BR></DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D276331521-16022001>Exclude your DataBase Files. They can =
not and=20
    should not be backed up using OTM, there is a Microsoft API that =
NBU uses to=20
    backup MS SQL.&nbsp; It's the MS SQL extension for=20
    NetBackup.</SPAN></FONT></DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D276331521-16022001></SPAN></FONT>&nbsp;</DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D276331521-16022001>Thanks,</SPAN></FONT></DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D276331521-16022001></SPAN></FONT>&nbsp;</DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D276331521-16022001>Bob</SPAN></FONT></DIV>
    <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
      <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
      size=3D2>-----Original Message-----<BR><B>From:</B> Fr=E9d=E9rick =
Coutret [<A=20
      =
href=3D"mailto:frederick.coutret AT par.sita DOT int">mailto:frederick.coutret@=
par.sita.int</A>]<BR><B>Sent:</B>=20
      Friday, February 16, 2001 12:23 PM<BR><B>To:</B> <A=20
      =
href=3D"mailto:veritas-bu AT mailman.eng.auburn DOT edu">veritas-bu AT mailman 
DOT eng=
.auburn.edu</A><BR><B>Subject:</B>=20
      [Veritas-bu] OTM with MSSQL<BR><BR></DIV></FONT>
      <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
      <DIV>&nbsp;</DIV>
      <DIV><FONT face=3DArial size=3D2>I tried several times to backup =
NT systems=20
      with MSSQL using OTM and I always got problems.</FONT></DIV>
      <DIV><FONT face=3DArial size=3D2>Veritas support just told me I =
can't backup=20
      NT systems with MSSQL using OTM but I tried and found some=20
      workaround</FONT></DIV>
      <DIV><FONT face=3DArial size=3D2>by changing OTM =
parameters.</FONT></DIV>
      <DIV>&nbsp;</DIV>
      <DIV><FONT face=3DArial size=3D2>But now,&nbsp;the old problems =
are coming=20
      back on some NT servers.</FONT></DIV>
      <DIV><FONT face=3DArial size=3D2>Is there is right way to use OTM =
without any=20
      11 status code ( 1005 or 1001 errors on OTM ) ?</FONT></DIV>
      <DIV>&nbsp;</DIV>
      <DIV><FONT face=3DArial =
size=3D2>Thanks,<BR>Frederick</FONT></DIV>
      =
<DIV>&nbsp;</DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C09860.4B4947F0--



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