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_01C5CA99.D8D1F5FC
Content-Type: text/plain
It appears that you're trying to backup the transaction log for the msdb
database. The default recovery option for msdb is simple which does not
support backups of the transaction log.
Neil
_____
From: veritas-bu-admin AT mailman.eng.auburn DOT edu [mailto:veritas-bu-admin
AT mailman.eng.auburn DOT edu] On Behalf Of Shyam Hazari
Sent: Thursday, October 06, 2005 10:06 AM
To: Veritas List
Subject: [Veritas-bu] SQL server transaction log backup problem
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 the
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 = C:\Program Files\VERITAS\NetBackup\DbExt\MsSql\tran_back.bch, Op# = 1.
INF - Using backup image
'hostname.MSSQL7.hostname\SQL2000.trx.model.~.0.001of001.20051006113920..C'.
INF - backup log "model" to VIRTUAL_DEVICE='VNBU0-3788-2036' with blocksize =
512, maxtransfersize = 65536, buffercount = 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='VNBU0-3788-2036' with blocksize = 512, maxtransfersize = 65536,
buffercount = 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 = 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 application request.).
3041 : BACKUP failed to complete the command backup log "msdb" to
VIRTUAL_DEVICE='VNBU0-2492-2268' with blocksize = 512, maxtransfersize = 65536,
buffercount = 1
TIA
-Shyam
------_=_NextPart_001_01C5CA99.D8D1F5FC
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" =
name=3D"PlaceType"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PlaceName"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>It appears that you're trying to
backup the transaction log for the msdb database. The default =
recovery option
for msdb is simple which does not support backups of the transaction =
log.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>=
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Neil<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>=
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>
<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>
</span></font></div>
<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'>
veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <b><span =
style=3D'font-weight:
bold'>On Behalf Of </span></b>Shyam Hazari<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Thursday, October =
06, 2005
10:06 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Veritas List<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> [Veritas-bu] =
SQL server
transaction log backup problem</span></font><o:p></o:p></p>
</div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>List,<o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>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 the
problem is ?<o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>Master/Media server : Solaris 9, V880, netbackup 5.1, =
MP2<o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>Windows client : =
windows
2003, Sql2000<o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><strong><b><font size=3D3 color=3D"#ff6666"
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt;color:#FF6666'>Netbackup
logs:-</span></font></b></strong><o:p></o:p></p>
</div>
<div>
<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>INF -
DUMP STARTED USING<br>
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) <br>
May 13 2005 18:33:17 <br>
Copyright (c) 1988-2003 Microsoft Corporation<br>
<st1:City w:st=3D"on"><st1:place =
w:st=3D"on">Enterprise</st1:place></st1:City>
Edition on Windows NT 5.2 (Build 3790: Service Pack 1) <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.trx.model.~.0.001of001.20051006113920.=
.C'.<br>
INF - backup log "model" to =
VIRTUAL_DEVICE=3D'VNBU0-3788-2036' with
blocksize =3D 512, maxtransfersize =3D 65536, buffercount =3D 1 <br>
INF - #Stripes: 1, #Bufs per stripe 1, To: NetBackup on =
backup.backup-int<br>
INF - Created VDI object for SQL Server instance <sql2000>. =
Connection
timeout is <300> seconds.<br>
ERR - Error in GetConfiguration: 0x80770003. The text follows: <br>
CONTINUATION: - The api was waiting and the timeout =
interval
had elapsed.<br>
DBMS MSG - ODBC message. ODBC return code <-1>, <st1:place =
w:st=3D"on"><st1:PlaceName
w:st=3D"on">SQL</st1:PlaceName> <st1:PlaceType =
w:st=3D"on">State</st1:PlaceType></st1:place>
<37000>, Message Text <[Microsoft][ODBC SQL Server Driver][SQL
Server]BACKUP LOG is terminating abnormally.> <br>
ERR - Error found executing <backup log "model" to
VIRTUAL_DEVICE=3D'VNBU0-3788-2036' with blocksize =3D 512, =
maxtransfersize =3D 65536,
buffercount =3D 1><br>
ERR - Error in VDS->Close: 0x80770004. The text follows: <br>
CONTINUATION: - An abort request is preventing =
anything
except termination actions.<br>
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. <br>
INF - Results of executing <C:\Program
Files\VERITAS\NetBackup\DbExt\MsSql\tran_back.bch>: <br>
<0> operations succeeded. <1> operations =
failed.<o:p></o:p></span></font></p>
<p><strong><b><font size=3D3 color=3Dred face=3D"Times New Roman"><span
style=3D'font-size:12.0pt;color:red'>Event =
logs:-</span></font></b></strong><o:p></o:p></p>
<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>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 application request.). =
<o:p></o:p></span></font></p>
<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>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<o:p></o:p></span></font></p>
<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p>
<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>TIA<o:p></o:p></span></font></p>
<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>-Shyam<o:p></o:p></span></font></p>
</div>
</div>
</body>
</html>
------_=_NextPart_001_01C5CA99.D8D1F5FC--
|