?? 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 Expressand can find nothing. Does anyone know if it works/ is supported? thanks! lisa
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:[EMAIL PROTECTED] Sent: Wed 19/11/2008 15:10 To: ADSM-L@VM.MARIST.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 Expressand can find nothing. Does anyone know if it works/ is supported? thanks! lisa
Re: ?? 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:[EMAIL PROTECTED] On Behalf Of Phillip Burgess Sent: Wednesday, November 19, 2008 11:53 AM To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] Sent: Wed 19/11/2008 15:10 To: ADSM-L@VM.MARIST.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 Expressand can find nothing. Does anyone know if it works/ is supported? thanks! lisa
Re: ?? TDP for DBs - does it support SQL Express?
Not sure of all the functionality with SQL Express but what about scheduling a DB dump within SQL Express and then letting the standard TSM pick up the dumped files? Would be cheaper as well. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bill Boyer Sent: Wednesday, November 19, 2008 12:20 PM To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] On Behalf Of Phillip Burgess Sent: Wednesday, November 19, 2008 11:53 AM To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] Sent: Wed 19/11/2008 15:10 To: ADSM-L@VM.MARIST.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 Expressand can find nothing. Does anyone know if it works/ is supported? thanks! lisa
Re: ?? TDP for DBs - does it support SQL Express?
Lisa, Data Protection for SQL does not support SQL Server Express Edition. Here are Hardware and Software requirements for IBM Tivoli Storage Manager for Databases version 5.5.1 http://www-01.ibm.com/support/docview.wss?uid=swg21297510 It supports Standard and Enterprise versions. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 11/19/2008 10:10:28 AM: [image removed] ?? TDP for DBs - does it support SQL Express? Laughlin, Lisa to: ADSM-L 11/19/2008 10:14 AM Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Please respond to ADSM: Dist Stor Manager Good Morning! I am looking in the various and sundry locations of documentation for the TDP for DBs to see if it supports SQL Expressand can find nothing. Does anyone know if it works/ is supported? thanks! lisa
Re: ?? TDP for DBs - does it support SQL Express?
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:[EMAIL PROTECTED] On Behalf Of Bill Boyer Sent: Wednesday, November 19, 2008 11:20 AM To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] On Behalf Of Phillip Burgess Sent: Wednesday, November 19, 2008 11:53 AM To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] Sent: Wed 19/11/2008 15:10 To: ADSM-L@VM.MARIST.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 Expressand can find nothing. Does anyone know if it works/ is supported? thanks! lisa