Veritas-bu

[Veritas-bu] SQL database failures

2004-03-03 13:43:39
Subject: [Veritas-bu] SQL database failures
From: Josh.Goldfarb AT blackrock DOT com (Goldfarb, Josh)
Date: Wed, 3 Mar 2004 13:43:39 -0500
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.&nbsp; Basically I was =
wondering if there was a way to script EXACTLY which databases =
failed.&nbsp; I tried doing it through SQL, but you need a mail client =
installed which is a no no.&nbsp; 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 &lt;16&gt; or &lt;32&gt; in the dbbackup =
and dbclient logs.&nbsp; </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>