Veritas-bu

[Veritas-bu] SQL server transaction log backup problem

2005-10-06 13:06:02
Subject: [Veritas-bu] SQL server transaction log backup problem
From: Shyam Hazari <shazari AT gmail DOT com> (Shyam Hazari)
Date: Thu, 6 Oct 2005 13:06:02 -0400
------=_Part_2511_28011551.1128618362407
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

List,
 I am trying to backup SQL server transaction logs and it fials with the
following error. Differential and full backups are fine. Any idea what's th=
e
problem is ?
 Master/Media server : Solaris 9, V880, netbackup 5.1, MP2
Windows client : windows 2003, Sql2000
 *Netbackup logs:-*

INF - DUMP STARTED USING
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)
May 13 2005 18:33:17
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Batch =3D C:\Program Files\VERITAS\NetBackup\DbExt\MsSql\tran_back.bch, Op#=
 =3D
1.
INF - Using backup image '
hostname.MSSQL7.hostname\SQL2000.trx.model.~.0.001of001.20051006113920..C'.
INF - backup log "model" to VIRTUAL_DEVICE=3D'VNBU0-3788-2036' with blocksi=
ze
=3D 512, maxtransfersize =3D 65536, buffercount =3D 1
INF - #Stripes: 1, #Bufs per stripe 1, To: NetBackup on backup.backup-int
INF - Created VDI object for SQL Server instance <sql2000>. Connection
timeout is <300> seconds.
ERR - Error in GetConfiguration: 0x80770003. The text follows:
CONTINUATION: - The api was waiting and the timeout interval had elapsed.
DBMS MSG - ODBC message. ODBC return code <-1>, SQL State <37000>, Message
Text <[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is
terminating abnormally.>
ERR - Error found executing <backup log "model" to
VIRTUAL_DEVICE=3D'VNBU0-3788-2036' with blocksize =3D 512, maxtransfersize =
=3D
65536, buffercount =3D 1>
ERR - Error in VDS->Close: 0x80770004. The text follows:
CONTINUATION: - An abort request is preventing anything except termination
actions.
INF - OPERATION #1 of batch C:\Program
Files\VERITAS\NetBackup\DbExt\MsSql\tran_back.bch FAILED with status 1.
Elapsed time =3D 635(635) seconds.
INF - Results of executing <C:\Program
Files\VERITAS\NetBackup\DbExt\MsSql\tran_back.bch>:
<0> operations succeeded. <1> operations failed.

*Event logs:-*

18210 : BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on
backup device 'VNBU0-2492-2268'. Operating system error 995(The I/O
operation has been aborted because of either a thread exit or an applicatio=
n
request.).

3041 : BACKUP failed to complete the command backup log "msdb" to
VIRTUAL_DEVICE=3D'VNBU0-2492-2268' with blocksize =3D 512, maxtransfersize =
=3D
65536, buffercount =3D 1

 TIA

-Shyam

------=_Part_2511_28011551.1128618362407
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div>List,</div>
<div>&nbsp;</div>
<div>I am trying to backup SQL server transaction logs and it fials with th=
e following error. Differential and full backups are fine. Any idea what's =
the problem is ?</div>
<div>&nbsp;</div>
<div>Master/Media server : Solaris 9, V880, netbackup 5.1, MP2</div>
<div>Windows client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : windows 200=
3, Sql2000</div>
<div>&nbsp;</div>
<div><font color=3D"#ff6666"><strong>Netbackup logs:-</strong></font></div>
<div>
<p>INF - DUMP STARTED USING<br>Microsoft SQL Server&nbsp; 2000 - 8.00.2040 =
(Intel X86) <br>May 13 2005 18:33:17 <br>Copyright (c) 1988-2003 Microsoft =
Corporation<br>Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pa=
ck 1)=20
<br>Batch =3D C:\Program Files\VERITAS\NetBackup\DbExt\MsSql\tran_back.bch,=
 Op# =3D 1.<br>INF - Using backup image 'hostname.MSSQL7.hostname\SQL2000.t=
rx.model.~.0.001of001.20051006113920..C'.<br>INF - backup log &quot;model&q=
uot; to VIRTUAL_DEVICE=3D'VNBU0-3788-2036' with blocksize =3D 512, maxtrans=
fersize =3D 65536, buffercount =3D 1
<br>INF - #Stripes: 1, #Bufs per stripe 1, To: NetBackup on backup.backup-i=
nt<br>INF - Created VDI object for SQL Server instance &lt;sql2000&gt;. Con=
nection timeout is &lt;300&gt; seconds.<br>ERR - Error in GetConfiguration:=
 0x80770003. The text follows:
<br>&nbsp;&nbsp;&nbsp; CONTINUATION: - The api was waiting and the timeout =
interval had elapsed.<br>DBMS MSG - ODBC message. ODBC return code &lt;-1&g=
t;, SQL State &lt;37000&gt;, Message Text &lt;[Microsoft][ODBC SQL Server D=
river][SQL Server]BACKUP LOG is terminating abnormally.&gt;
<br>ERR - Error found executing &lt;backup log &quot;model&quot; to VIRTUAL=
_DEVICE=3D'VNBU0-3788-2036' with blocksize =3D 512, maxtransfersize =3D 655=
36, buffercount =3D 1&gt;<br>ERR - Error in VDS-&gt;Close: 0x80770004. The =
text follows:
<br>&nbsp;&nbsp;&nbsp; CONTINUATION: - An abort request is preventing anyth=
ing except termination actions.<br>INF - OPERATION #1 of batch C:\Program F=
iles\VERITAS\NetBackup\DbExt\MsSql\tran_back.bch FAILED with status 1. Elap=
sed time =3D 635(635) seconds.
<br>INF - Results of executing &lt;C:\Program Files\VERITAS\NetBackup\DbExt=
\MsSql\tran_back.bch&gt;: <br>&lt;0&gt; operations succeeded. &lt;1&gt; ope=
rations failed.</p>
<p><strong><font color=3D"#ff0000">Event logs:-</font></strong></p>
<p>18210 : BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on b=
ackup device 'VNBU0-2492-2268'. Operating system error 995(The I/O operatio=
n has been aborted because of either a thread exit or an application reques=
t.).
</p>
<p>3041 : BACKUP failed to complete the command backup log &quot;msdb&quot;=
 to VIRTUAL_DEVICE=3D'VNBU0-2492-2268' with blocksize =3D 512, maxtransfers=
ize =3D 65536, buffercount =3D 1</p>
<p>&nbsp;</p>
<p>TIA</p>
<p>-Shyam</p></div>

------=_Part_2511_28011551.1128618362407--

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