[Veritas-bu] SQL database failures
2004-03-03 13:43:39
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4014F.7190405B
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
When receiving status 1's with SQL database failures, it can be one of
many things. Basically I was wondering if there was a way to script
EXACTLY which databases failed. I tried doing it through SQL, but you
need a mail client installed which is a no no. It didn't like BLAT
either.=20
The other option would be to cat the log file and search for either <16>
or <32> in the dbbackup and dbclient logs. =20
Does anyone have a good way to script what I am trying to achieve,
Any help would be greatly appreciatied.
NBU 3.41_6
Thx
Josh
Josh Goldfarb
BlackRock Financial Management Inc.
BlackRock Solutions - Technology USA
40 East 52nd Street
NY, NY 10022
Phone: 212.409.3702
------_=_NextPart_001_01C4014F.7190405B
Content-Type: text/html;
charset="US-ASCII"
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=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.0.6487.1">
<TITLE>SQL database failures</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=3D2 FACE=3D"Arial">When receiving status 1's with SQL =
database failures, it can be one of many things. Basically I was =
wondering if there was a way to script EXACTLY which databases =
failed. I tried doing it through SQL, but you need a mail client =
installed which is a no no. It didn't like BLAT either. =
</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">The other option would be to cat the =
log file and search for either <16> or <32> in the dbbackup =
and dbclient logs. </FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Does anyone have a good way to script =
what I am trying to achieve,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Any help would be greatly =
appreciatied.</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">NBU 3.41_6</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thx</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Josh</FONT>
</P>
<BR>
<BR>
<BR>
<BR>
<P><I><FONT SIZE=3D2 FACE=3D"Times New Roman">Josh Goldfarb</FONT></I>
<BR><I><FONT SIZE=3D2 FACE=3D"Times New Roman">BlackRock Financial =
Management Inc.</FONT></I>
<BR><I><FONT SIZE=3D2 FACE=3D"Times New Roman">BlackRock Solutions - =
Technology USA</FONT></I>
<BR><I><FONT SIZE=3D2 FACE=3D"Times New Roman">40 East 52nd =
Street</FONT></I>
<BR><I><FONT SIZE=3D2 FACE=3D"Times New Roman">NY, NY 10022</FONT></I>
<BR><I><FONT SIZE=3D2 FACE=3D"Times New Roman">Phone: =
212.409.3702</FONT></I>
</P>
<BR>
</BODY>
</HTML>
------_=_NextPart_001_01C4014F.7190405B--
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Veritas-bu] SQL database failures,
Goldfarb, Josh <=
|
|
|