ADSM-L

Re: [ADSM-L] ?? TDP for DBs - does it support SQL Express?

2008-11-19 16:08:00
Subject: Re: [ADSM-L] ?? TDP for DBs - does it support SQL Express?
From: "Laughlin, Lisa" <Lisa.Laughlin AT OA.MO DOT GOV>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 19 Nov 2008 15:06:25 -0600
Thank you all for your replies.

Hmm, this is starting to sound like a bummer.  The DBAs are using Oracle
ODI with SQL Express... in production ...for long term... from Teradata
data.... I was looking at the errors in the dsmerror.log from the
baclient.....and began to wonder..... and I made the mistake of asking
if they wanted to be able to recover if something happened to their
server.  

There is a maintenance job to export the db. And it is backed up.  I
think I'll just call it good and never mention it again ;-)

lisa 


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Bill Boyer
Sent: Wednesday, November 19, 2008 11:20 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] ?? TDP for DBs - does it support SQL Express?

The interesting thing about that I found is that if the SQLServer
service is
running, the TSM client doesn't even "see" the MDF/LDF files for the
active
databases. I mean they just plain don't show up in the list with little
X's
that say they are excluded. You stop the service and the files are
there.

Had a similar experience with the latest Oracle and their VSS component.
But
they at least showed up in the QUERY INCLEXCL list as "operating
system".

Bill Boyer
DSS, Inc.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Phillip Burgess
Sent: Wednesday, November 19, 2008 11:53 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: ?? TDP for DBs - does it support SQL Express?

Hi Lisa

The only way I can think of would be to stop the SQL services and then
backup the files up with the BA client. You may need to use an old
version
of the BA client though, as I've read reports that the 5.5 client
excludes
mdf and ldf files regardless of any includes in the dsm.opt file.


Phil


________________________________

From: Laughlin, Lisa [mailto:Lisa.Laughlin AT OA.MO DOT GOV]
Sent: Wed 19/11/2008 15:10
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] ?? TDP for DBs - does it support SQL Express?



Good Morning!

I am looking in the various and sundry locations of documentation for
the TDP for DBs to see if it supports SQL Express....and can find
nothing.  Does anyone know if it works/ is supported?

thanks!
lisa