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_01C382A9.B3297B70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
> I'm having some problems to backup up SQL databases with Netbackup =
sql
> agent. I've installed Netbackup Datacenter version 3.4.1 with all =
patches
> applied (server and client) in Windows 2000.
> I tried some changes in the BCH script. I tried to use the $ALL =
parameter,
> after this I tried to use a script with all databases discriminated, =
but
> it don=B4t work either. I changed the MAXTRANSFERFILE, BATCHSIZE, =
BLOCKSIZE
> and nothing work.
> I got the following from the dbbackup log (part of the entire log)
>=20
> 23:08:23 [2472,852] <4> CDBbackrec::InitDeviceSet(): INF - Created =
VDI
> object for SQL Server instance <*DEFAULT*>.
> 23:08:23 [2472,4572] <4> CDBbackrec::InitDeviceSet(): INF - Created =
VDI
> object for SQL Server instance <*DEFAULT*>.
> 23:20:40 [2472,4768] <4> dbclient: INF - DBClient has been opened for
> stripe #0
> 23:27:22 [2472,1544] <8> CODBCaccess::LogODBCerr: WARN - ODBC error. =
ODBC
> return code <1>, SQL State <01000>, Message Text <[Microsoft][ODBC =
SQL
> Server Driver][SQL Server]Processed 24496 pages for database =
'GftCds',
> file 'GftCds_Data' on file 1.>
> 23:27:47 [2472,4768] <4> dbclient: INF - DBClient has been closed for
> stripe #0
> 23:27:47 [2472,1544] <4> Dbbackrec::Perform: INF - OPERATION #3 of =
batch
> C:\VERITAS\NETBACKUP\DBEXT\MSSQL\Bkp_Dv.BCH SUCCEEDED with STATUS 0 =
(0 is
> normal). Elapsed time =3D 1164(401) seconds.
>=20
> I saw the "LogODBCerr: WARN - ODBC error" in the begging of the line =
where
> the error was generated, but when I test the ODBC it works fine.
>=20
> I have the SQL error log below
> ---------------------------------------- SQL LOG
> ------------------------------------------------------------
>=20
> 2003-07-27 23:40:47.80 spid51 BackupMedium::ReportIoError: write
> failure on backup device 'CtrDB-VNBU0-1832-216'. Operating system =
error
> 995(error not found).
> 2003-07-27 23:40:47.80 spid51 Internal I/O request 0x5646FB30: Op:
> Write, pBuffer: 0x15640200, Size: 512, Position: 0, UMS: Internal: =
0x0,
> InternalHigh: 0x0, Offset: 0x1, OffsetHigh: 0x0, m_buf: 0x00000000, =
m_len:
> 1, m_actualBytes: 0, m_errcode: 995, BackupFile: CtrDB-VNBU0-1832-216
> 2003-07-27 23:40:47.82 backup BACKUP failed to complete the =
command
> backup database CtrDB to VIRTUAL_DEVICE=3D'CtrDB-VNBU0-1832-216' with
> blocksize =3D 512, maxtransfersize =3D 65536, buffercount =3D 1
> 2003-07-27 23:40:47.85 spid51
> BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup
> device 'CtrDB-VNBU0-1832-216'. Operating system error 995(error not
> found).
> 2003-07-27 23:47:41.81 backup Database backed up: Database: =
GftCds,
> creation date(time): 2003/02/27(23:58:42), pages dumped: 22819, first =
LSN:
> 5361:101:1, last LSN: 5361:105:1, number of dump devices: 1, device
> information: (FILE=3D1, TYPE=3DVIRTUAL_DEVICE: =
{'GftCds-VNBU0-1832-3136'}).
>=20
>=20
> 2003-07-29 09:24:55.36 spid51 BackupMedium::ReportIoError: write
> failure on backup device 'InventarioPaulista-VNBU0-3976-2000'. =
Operating
> system error 995(error not found).
> 2003-07-29 09:24:55.41 spid51 Internal I/O request 0x4B2D9BB0: Op:
> Write, pBuffer: 0x1B400200, Size: 512, Position: 0, UMS: Internal: =
0x0,
> InternalHigh: 0x0, Offset: 0x0, OffsetHigh: 0x0, m_buf: 0x00000000, =
m_len:
> 0, m_actualBytes: 0, m_errcode: 995, BackupFile:
> InventarioPaulista-VNBU0-3976-2000
> 2003-07-29 09:24:55.32 backup BACKUP failed to complete the =
command
> backup database InventarioPaulista to
> VIRTUAL_DEVICE=3D'InventarioPaulista-VNBU0-3976-2000' with blocksize =
=3D 512,
> maxtransfersize =3D 65536, buffercount =3D 1
> 2003-07-29 09:24:55.69 spid51
> BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup
> device 'InventarioPaulista-VNBU0-3976-2000'. Operating system error
> 995(error not found).
>=20
> I saw the message "Operating system error 995(error not found)" and =
the
> return of this error when I type in the command promt net helpmsg 995 =
is
> "The I/o operation has been aborted because of either a thread exit =
or an
> application request.
> The SQL has some batch jobs that run to get some statisticsand insert =
some
> information in some tables.
>=20
> If anyone know what is happening pls help me.
>=20
> Thanks,
>=20
> Julio
------_=_NextPart_001_01C382A9.B3297B70
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>SQL backup problem</TITLE>
</HEAD>
<BODY>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">I'm having some problems to backup up =
SQL databases with Netbackup sql agent. I've installed Netbackup =
Datacenter version 3.4.1 with all patches applied (server and client) =
in Windows 2000.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I tried some changes in the BCH =
script. I tried to use the $ALL parameter, after this I tried to use a =
script with all databases discriminated, but it don=B4t work either. I =
changed the MAXTRANSFERFILE, BATCHSIZE, BLOCKSIZE and nothing =
work.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I got the following from the dbbackup =
log (part of the entire log)</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">23:08:23 [2472,852] <4> =
CDBbackrec::InitDeviceSet(): INF - Created VDI object for SQL Server =
instance <*DEFAULT*>.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">23:08:23 [2472,4572] <4> =
CDBbackrec::InitDeviceSet(): INF - Created VDI object for SQL Server =
instance <*DEFAULT*>.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">23:20:40 [2472,4768] <4> =
dbclient: INF - DBClient has been opened for stripe #0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">23:27:22 [2472,1544] <8> =
CODBCaccess::LogODBCerr: WARN - ODBC error. ODBC return code <1>, =
SQL State <01000>, Message Text <[Microsoft][ODBC SQL Server =
Driver][SQL Server]Processed 24496 pages for database 'GftCds', file =
'GftCds_Data' on file 1.></FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">23:27:47 [2472,4768] <4> =
dbclient: INF - DBClient has been closed for stripe #0</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">23:27:47 [2472,1544] <4> =
Dbbackrec::Perform: INF - OPERATION #3 of batch =
C:\VERITAS\NETBACKUP\DBEXT\MSSQL\Bkp_Dv.BCH SUCCEEDED with STATUS 0 (0 =
is normal). Elapsed time =3D 1164(401) seconds.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I saw the "LogODBCerr: WARN - =
ODBC error" in the begging of the line where the error was =
generated, but when I test the ODBC it works fine.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I have the SQL error log below</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">---------------------------------------- SQL LOG =
------------------------------------------------------------</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">2003-07-27 23:40:47.80 =
spid51 BackupMedium::ReportIoError: write failure on =
backup device 'CtrDB-VNBU0-1832-216'. Operating system error 995(error =
not found).</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">2003-07-27 23:40:47.80 =
spid51 Internal I/O request 0x5646FB30: Op: Write, =
pBuffer: 0x15640200, Size: 512, Position: 0, UMS: Internal: 0x0, =
InternalHigh: 0x0, Offset: 0x1, OffsetHigh: 0x0, m_buf: 0x00000000, =
m_len: 1, m_actualBytes: 0, m_errcode: 995, BackupFile: =
CtrDB-VNBU0-1832-216</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">2003-07-27 23:40:47.82 =
backup BACKUP failed to complete the command backup =
database CtrDB to VIRTUAL_DEVICE=3D'CtrDB-VNBU0-1832-216' with =
blocksize =3D 512, maxtransfersize =3D 65536, buffercount =3D =
1</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">2003-07-27 23:40:47.85 =
spid51 BackupVirtualDeviceFile::RequestDurableMedia: =
Flush failure on backup device 'CtrDB-VNBU0-1832-216'. Operating system =
error 995(error not found).</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">2003-07-27 23:47:41.81 =
backup Database backed up: Database: GftCds, creation =
date(time): 2003/02/27(23:58:42), pages dumped: 22819, first LSN: =
5361:101:1, last LSN: 5361:105:1, number of dump devices: 1, device =
information: (FILE=3D1, TYPE=3DVIRTUAL_DEVICE: =
{'GftCds-VNBU0-1832-3136'}).</FONT></P>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">2003-07-29 09:24:55.36 =
spid51 BackupMedium::ReportIoError: write failure on =
backup device 'InventarioPaulista-VNBU0-3976-2000'. Operating system =
error 995(error not found).</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">2003-07-29 09:24:55.41 =
spid51 Internal I/O request 0x4B2D9BB0: Op: Write, =
pBuffer: 0x1B400200, Size: 512, Position: 0, UMS: Internal: 0x0, =
InternalHigh: 0x0, Offset: 0x0, OffsetHigh: 0x0, m_buf: 0x00000000, =
m_len: 0, m_actualBytes: 0, m_errcode: 995, BackupFile: =
InventarioPaulista-VNBU0-3976-2000</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">2003-07-29 09:24:55.32 =
backup BACKUP failed to complete the command backup =
database InventarioPaulista to =
VIRTUAL_DEVICE=3D'InventarioPaulista-VNBU0-3976-2000' with blocksize =
=3D 512, maxtransfersize =3D 65536, buffercount =3D 1</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">2003-07-29 09:24:55.69 =
spid51 BackupVirtualDeviceFile::RequestDurableMedia: =
Flush failure on backup device 'InventarioPaulista-VNBU0-3976-2000'. =
Operating system error 995(error not found).</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I saw the message "Operating =
system error 995(error not found)" and the return of this error =
when I type in the command promt net helpmsg 995 is "The I/o =
operation has been aborted because of either a thread exit or an =
application request.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">The SQL has some batch jobs that run =
to get some statisticsand insert some information in some =
tables.</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">If anyone know what is happening pls =
help me.</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Julio</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C382A9.B3297B70--
|
