Re: TDP for SQL Server password file

2020-12-14 Thread Loon, Eric van (ITOP NS) - KLM
Hi Leandro, Thank you very much for your help! Kind regards, Eric van Loon Air France/KLM Storage & Backup -Original Message- From: ADSM: Dist Stor Manager On Behalf Of L Mazur Sent: vrijdag 11 december 2020 19:00 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server password

Re: TDP for SQL Server password file

2020-12-11 Thread L Mazur
: vrijdag 11 december 2020 17:02 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server password file Hi Eric, If you cannot find anything in the Windows registry, please open a ticket with IBM. I spoke to the developers and they are not entirely sure of the use/case scenario that would lead to

Re: TDP for SQL Server password file

2020-12-11 Thread Loon, Eric van (ITOP NS) - KLM
Hi Del, Any idea which registry key is used? Thanks for your help! Kind regards, Eric van Loon Air France/KLM Storage & Backup -Original Message- From: ADSM: Dist Stor Manager On Behalf Of Del Hoobler Sent: vrijdag 11 december 2020 17:02 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP

Re: TDP for SQL Server password file

2020-12-11 Thread Marc Lanteigne
Hi Eric, The old password is the current password. In my example below, I set the new password the same as the current, but it could be different. Protect: HYDROGEN>update node test test1234 ANR2063I Node TEST updated. Protect: HYDROGEN>quit ANS8002I Highest return code was 0. c:\Program File

Re: TDP for SQL Server password file

2020-12-11 Thread Del Hoobler
Hi Eric, If you cannot find anything in the Windows registry, please open a ticket with IBM. I spoke to the developers and they are not entirely sure of the use/case scenario that would lead to this. Thank you, Del "ADSM: Dist Stor Manager" wrote on 12/10/2020 05:15:14 AM: > From: "

Re: TDP for SQL Server, ANS1532E on AlwaysOn cluster

2016-11-14 Thread Loon, Eric van (ITOPT3) - KLM
Hi Leif! Thanks for your reply! The strange thing is that this is not mentioned in the installation manual. There is only a link called "Proxy node definitions for VSS backups" but we are using legacy backups... Kind regards, Eric van Loon Air France/KLM Storage Engineering -Original Message

Re: TDP for SQL server error

2014-05-08 Thread Loon, EJ van (SPLXM) - KLM
17:07 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error Hi Eric, I agree. There is a fix for it and it is being tested now. It is targeted for the 7.1.0.1 interim and will be available once the testing has completed. If you decide you need an immediate fix, you can always open a

Re: TDP for SQL server error

2014-05-08 Thread Loon, EJ van (SPLXM) - KLM
T.EDU Subject: Re: TDP for SQL server error Op 7 mei 2014, om 16:39 heeft Loon, EJ van (SPLXM) - KLM het volgende geschreven: > Hi Del! > Ok... Hm... I don't think our SQL guys will be very charmed by the work > around (ignoring the error)... not ignore the error, ignore a mistake

Re: TDP for SQL server error

2014-05-07 Thread Remco Post
Eric van Loon > AF/KLM Storage Engineering > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del > Hoobler > Sent: woensdag 7 mei 2014 16:21 > To: ADSM-L@VM.MARIST.EDU > Subject: Re: TDP for SQL server error > >

Re: TDP for SQL server error

2014-05-07 Thread Del Hoobler
"ADSM: Dist Stor Manager" wrote on 05/07/2014 10:39:00 AM: > From: "Loon, EJ van (SPLXM) - KLM" > To: ADSM-L@vm.marist.edu, > Date: 05/07/2014 10:40 AM > Subject: Re: TDP for SQL server error > Sent by: "ADSM: Dist Stor Manager" > &g

Re: TDP for SQL server error

2014-05-07 Thread Loon, EJ van (SPLXM) - KLM
ix release... However, thank you VERY much for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: woensdag 7 mei 2014 16:21 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for

Re: TDP for SQL server error

2014-05-07 Thread Del Hoobler
gacy backup operations. Del "ADSM: Dist Stor Manager" wrote on 05/07/2014 09:40:57 AM: > From: "Loon, EJ van (SPLXM) - KLM" > To: ADSM-L@vm.marist.edu, > Date: 05/07/2014 09:41 AM > Subject: Re: TDP for SQL server error > Sent by: &qu

Re: TDP for SQL server error

2014-05-07 Thread Loon, EJ van (SPLXM) - KLM
: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error Hi Eric, No. You should just be able to use legacy style backups. My guess is that the configuration wizard inadvertently added some entries causing this. Check the tdpsql.cfg file. 1. Remove the LOCALDSMAGENTNODE entry (if there is one

Re: TDP for SQL server error

2014-05-07 Thread Del Hoobler
LEGACY Del "ADSM: Dist Stor Manager" wrote on 05/07/2014 08:00:45 AM: > From: "Loon, EJ van (SPLXM) - KLM" > To: ADSM-L@vm.marist.edu, > Date: 05/07/2014 08:01 AM > Subject: Re: TDP for SQL server error >

Re: TDP for SQL server error

2014-05-07 Thread Loon, EJ van (SPLXM) - KLM
@VM.MARIST.EDU Subject: Re: TDP for SQL server error Eric, Long shot: do you use the same node name for the SQL backup as for the reguler OS backup? If not, maybe it detects the hostname of the machine but the dsm.opt has a different (TDPSQL) node name so it thinks you are trying to proxy

Re: TDP for SQL server error

2014-05-07 Thread Loon, EJ van (SPLXM) - KLM
Behalf Of Remco Post Sent: woensdag 7 mei 2014 9:27 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL server error you need to grant proxy rights to the fs client for the sql client (or vv) for VSS based backups to work, legacy backups work without such proxy rights (and without the error message

Re: TDP for SQL server error

2014-05-07 Thread Rick Harderwijk
Eric, Long shot: do you use the same node name for the SQL backup as for the reguler OS backup? If not, maybe it detects the hostname of the machine but the dsm.opt has a different (TDPSQL) node name so it thinks you are trying to proxy? Cheers, Rick On Wed, May 7, 2014 at 9:05 AM, Loon, EJ van

Re: TDP for SQL server error

2014-05-07 Thread Remco Post
you need to grant proxy rights to the fs client for the sql client (or vv) for VSS based backups to work, legacy backups work without such proxy rights (and without the error message). Op 7 mei 2014, om 09:05 heeft Loon, EJ van (SPLXM) - KLM het volgende geschreven: > Hi TSMers! > Our SQL dep

Re: TDP for SQL Server - restoring Database to another server (VSS Backup)

2014-04-09 Thread Dhammika Rathnayake1
Hi Francisco Thanks a lot Best Regards, Dhammika From: Francisco Parrilla To: ADSM-L@vm.marist.edu, Date: 04/09/2014 08:25 PM Subject:Re: [ADSM-L] TDP for SQL Server - restoring Database to another server (VSS Backup) Sent by:"ADSM: Dist Stor Manager

Re: TDP for SQL Server - restoring Database to another server (VSS Backup)

2014-04-09 Thread Francisco Parrilla
You can do both backups by the TDP for databases, but only legacy backup can be restored to another server, VSS backup just can be restored at the same server. If you try to issue a restore you can recover the database files but never put online in SQL instance. Best Regards 2014-04-08 23:54 GM

Re: TDP for SQL Server - restoring Database to another server (VSS Backup)

2014-04-08 Thread Dhammika Rathnayake1
Hi Francisco Parrilla, Thank you for the information. version is 6.4. Is online Legacy backup is enough? Best regards, Dhammika From: Francisco Parrilla To: ADSM-L@vm.marist.edu, Date: 04/08/2014 09:41 PM Subject:Re: [ADSM-L] TDP for SQL Server - restoring Database to an

Re: TDP for SQL Server - restoring Database to another server (VSS Backup)

2014-04-08 Thread Del Hoobler
Microsoft does not support restoring VSS backups into a SQL Server that has a different name. This is a Microsoft restriction and is documented in the Data Protection for SQL User's Guide. Thank you, Del "ADSM: Dist Stor Manager" wrote on

Re: TDP for SQL Server - restoring Database to another server (VSS Backup)

2014-04-08 Thread Francisco Parrilla
Which version of TDP have you? To restore SQL backup to another node this must be type Legacy backup , there are one restriction for VSS backup, this of kind of backup just can restoring at the same server on some versions of TDP for SQL Best regards 2014-04-08 10:56 GMT-05:00 Dhammika Rathnaya

Re: TDP for SQL Server

2013-11-26 Thread Loon, EJ van - SPLXM
Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: vrijdag 1 november 2013 15:58 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, What happens if you install 6.4.0 first, then follow it with an

Re: TDP for SQL Server

2013-11-01 Thread Del Hoobler
11/01/2013 11:29 AM > Subject: Re: TDP for SQL Server > Sent by: "ADSM: Dist Stor Manager" > > Hi Del! > I will have to try this on a different machine. I will let you know next > week. > If that's the new way to install the client, I think it has not improv

Re: TDP for SQL Server

2013-11-01 Thread Loon, EJ van - SPLXM
easier and faster, don't you agree? Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: vrijdag 1 november 2013 15:58 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server

Re: TDP for SQL Server

2013-11-01 Thread Del Hoobler
: Dist Stor Manager" wrote on 11/01/2013 09:01:24 AM: > From: "Loon, EJ van - SPLXM" > To: ADSM-L@vm.marist.edu, > Date: 11/01/2013 09:03 AM > Subject: Re: TDP for SQL Server > Sent by: "ADSM: Dist Stor Manager" > > Hi Del! > I removed the

Re: TDP for SQL Server

2013-11-01 Thread Loon, EJ van - SPLXM
wards. Thanks for your help! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: vrijdag 1 november 2013 11:46 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, Thi

Re: TDP for SQL Server

2013-11-01 Thread Del Hoobler
> From: "Loon, EJ van - SPLXM" > To: ADSM-L@vm.marist.edu, > Date: 11/01/2013 06:09 AM > Subject: Re: TDP for SQL Server > Sent by: "ADSM: Dist Stor Manager" > > Hi Del! > According to the manual I have to run setupfcm.exe. This indeed installs > a

Re: TDP for SQL Server

2013-11-01 Thread Loon, EJ van - SPLXM
AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: maandag 28 oktober 2013 14:20 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, You might want to get the latest version, 6.4.1. http

Re: TDP for SQL Server

2013-10-28 Thread Stackwick, Stephen
; > "ADSM: Dist Stor Manager" wrote on 10/28/2013 > 09:10:41 AM: > > > From: "Loon, EJ van - SPLXM" > > To: ADSM-L@vm.marist.edu, > > Date: 10/28/2013 09:12 AM > > Subject: Re: TDP for SQL Server > > Sent by: "ADSM: Dist Stor Manager

Re: TDP for SQL Server

2013-10-28 Thread Del Hoobler
; From: "Loon, EJ van - SPLXM" > To: ADSM-L@vm.marist.edu, > Date: 10/28/2013 09:12 AM > Subject: Re: TDP for SQL Server > Sent by: "ADSM: Dist Stor Manager" > > Hi Del! > We have installed the 6.3.1.0 client and copied the license file from > the

Re: TDP for SQL Server

2013-10-28 Thread Loon, EJ van - SPLXM
! Kind regards, Eric van Loon AF/KLM Storage Engineering -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: maandag 28 oktober 2013 12:05 To: ADSM-L@VM.MARIST.EDU Subject: Re: TDP for SQL Server Hi Eric, This is expected. FlashCopy

Re: TDP for SQL Server

2013-10-28 Thread Prather, Wanda
Eric, It's a documentation issue. They repackaged the SQL client inside the Flashcopy manager GUI, and the install package does you no favors; it's a 2-step install now. After you run the setup.exe, all you have installed is the Flashcopy Manager shell, you don't even have a tdpsql directory . Lo

Re: TDP for SQL Server

2013-10-28 Thread Del Hoobler
Hi Eric, This is expected. FlashCopy Manager, Data Protection for SQL, and Data Protection for Exchange now share the same MMC GUI interface. To make sure you have the correct product installed, look for a file called "sqlclient.lic" in the C:\Program Files\Tivoli\TSM\TDPSql directory. Thanks,

Re: TDP for SQL Server question

2004-01-19 Thread Del Hoobler
Eric, You cannot do this. You must log on to the TSM Server under the NODENAME that performed the backups. The "Direct Query" function in version 1 worked the same way. It allowed you to query a specific server and database name, but the NODENAME queried was always the one logged in to. Data Prote

Re: TDP for SQL Server question

2004-01-16 Thread Bill Smoldt
TECTED] Sent: Friday, January 16, 2004 2:05 AM To: [EMAIL PROTECTED] Subject: Re: TDP for SQL Server question Hi Del! That's clear, but I found no way to overrule the NODENAME, which is specified in the option file, through the GUI. How can one do that? Thank you very much for you reply! Kinde

Re: TDP for SQL Server question

2004-01-16 Thread Loon, E.J. van - SPLXM
EMAIL PROTECTED] Sent: Friday, January 16, 2004 03:26 To: [EMAIL PROTECTED] Subject: Re: TDP for SQL Server question Eric, You no longer need direct query because when you enter the TSM Server using the NODENAME that contains the backup, the SQL Server name will automatically appear in the tree vie

Re: TDP for SQL Server question

2004-01-15 Thread Del Hoobler
Eric, You no longer need direct query because when you enter the TSM Server using the NODENAME that contains the backup, the SQL Server name will automatically appear in the tree view. In other words, DP for SQL will query the TSM Server for all backups under the NODENAME as opposed to just the SQ

Re: TDP for SQL Server support

2003-08-14 Thread Ung Yi
Thanks. Sorry about not reading the Readme file. Yi >>> [EMAIL PROTECTED] 08/07/03 08:46AM >>> Yi, >From the Data Protection for SQL 5.1.5 READSQL.TXT file. Data Protection for SQL 5.1.5 requires the following MINIMUM software levels: - Windows NT Server 4.0 SP4 or Windows 2000 SP1 (Se

Re: TDP for SQL Server support

2003-08-14 Thread Del Hoobler
Yi, >From the Data Protection for SQL 5.1.5 READSQL.TXT file. Data Protection for SQL 5.1.5 requires the following MINIMUM software levels: - Windows NT Server 4.0 SP4 or Windows 2000 SP1 (Server, Advanced Server or DataCenter Server) - Microsoft SQL Server 7.0 SP3 or Microsoft

Re: TDP for SQL Server Transaction Log Restores

2002-12-04 Thread Del Hoobler
Paul, I don't think this would be possible. It would require the application to understand the object naming as well as other "internals" on how it stores the data. Typically, in the case of the Data Protection clients (or any API application really), the application that backs up the data is real

Re: TDP for SQL Server Transaction Log Restores

2002-12-04 Thread Seay, Paul
for SQL Server? Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Del Hoobler [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 10:49 AM To: [EMAIL PROTECTED] Subject: Re: TDP for SQL Server Transaction Log Restores Paul, I am not

Re: TDP for SQL Server Transaction Log Restores

2002-12-04 Thread David Longo
Need clarifcation of your statements. Let me explain. TDP SQL does not only do FULL backups of the SQL DB's, but can also do LOG backups - live and it will not put these logs on disk, it backs them up to TSM server like the FULL backups. Now when the LOG backup happens, it truncates the SQL trans

Re: TDP for SQL Server Transaction Log Restores

2002-12-04 Thread Del Hoobler
Paul, I am not sure what you mean exactly. The SQL "logging" process does not have separate "log" segment files. The "log" that TDP for SQL backs up is just a "stream" of data that only SQL knows what to do with. It is not like a log file for Exchange or Domino. There is no way to just restore a

Re: TDP for SQL Server Transaction Log Restores

2002-12-04 Thread Zlatko Krastev/ACIT
TDP docs say to set verd=reto=0. Just change them and go down the "restore deleted file" road. Zlatko Krastev IT Consultant "Seay, Paul" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 04.12.2002 16:17 Please respond to "ADSM: Dist Stor Manager" To: [

Re: TDP for SQL Server and SQL Server backup utility question

2002-04-19 Thread Del Hoobler
> Could I use the full backup from TDP for SQL Server and the Log backups > created using SQL Server command 'BACKUP" to restore a database? Yi, Yes... You can do this... make sure you say /RECOVERY=NO when restoring the database from TDP for SQL so that recovery won't be run against the databa

Re: TDP for SQL Server remote control?

2001-11-15 Thread Charles Anderson
I know this isn't exactly what you're asking about, but it will do the job, and seeing the note about pcAnywhere just made me want to add my two bits. You can use VNC ( at no charge ) for remoting into the computer ( though your tranmissions won't be encryted or anything ). -ed http://www.uk.

Re: TDP for SQL Server remote control?

2001-11-15 Thread Zoltan Forray/AC/VCU
I use Symantec pcANYWHERE. The current version allows authentication to lots of different choices (LDAP, NDS, Active Directory, pcANYWHERE) and you can do things like transfer the log files to your workstation.

Re: TDP for SQL Server remote control?

2001-11-15 Thread Magura, Curtis
You can use a product like Timbuktu or if you're running Win2K the Terminal Server components. Either one will allow remote access to the desktop of another machine. Curt Magura Lockheed Martin EIS Gaithersburg, Md. 301-240-6305 -Original Message- From: Jeff Connor [mailto:[EMAIL PROTEC

Re: TDP for SQL Server

2001-08-13 Thread Del Hoobler
> Is there any way to > get the install process to work? Thomas, I am not the installation person and I know we have installed this on Windows NT... So I am not sure what is going on. Please call IBM/Tivoli support. Thanks, Del

Re: TDP for SQL Server

2001-08-08 Thread Del Hoobler
Thomas, Look here: Product: Tivoli Data Protection for Microsoft SQL FTP Site:ftp.software.ibm.com Directory: /storage/tivoli-storage-management/patches/agents/ntsql/1.1.2/ File:IC26111_01.EXE Version: 1.1.2.01 This version will skip "tempdb" for SQL 7 servers. The

Re: TDP for SQL Server Setup

2001-04-19 Thread Neil Schofield
Michel Your right - in most cases only one scheduler would be sufficient. One reason for having two schedulers is so that one can be performing a TDP client for SQL backup at the same time as the other is performing a filesystem backup. We use the TDP for SQL client to perform hourly transaction

Re: TDP for SQL Server Setup

2001-04-19 Thread Michel Engels
TED]> To: [EMAIL PROTECTED] cc:(bcc: Michel Engels/BE/Devoteam) Subject: Re: TDP for SQL Server Setup Jack Bob King's previous reply explains the difference between meta objects and data objects more eloquently than I could. While I understand the reasons for separating meta ob

Re: TDP for SQL Server Setup

2001-04-19 Thread Neil Schofield
Jack Bob King's previous reply explains the difference between meta objects and data objects more eloquently than I could. While I understand the reasons for separating meta objects and data objects, and storing the meta data on disk-only storage pools, we chose not to. In doing this we accepted

Re: TDP for SQL Server Setup

2001-04-18 Thread Robert L King
Jack, TDP for SQL keeps a lot of meta data, such as various names, version numbers, dates and times, sizes, etc. (TDP for SQL's meta data is separate from SQL server's meta data.) All of this meta data is contained within the TSM server database except for the names of the groups and files for a S

Re: TDP for SQL server login problem

2001-03-05 Thread Joachim Schwabe
Hello David, I remember a similar problem (may be the same) after upgrading the client. I tried a lot and after I enter a command like this SQLDSMC /BACKUPFULL: * /SQLUSER:sa /SQLPWD:"your_database_pwd" it works. hope this helps you joachim David Longo <[EMAIL PROTECTED]> on 05.03.2001

Re: TDP for SQL server login problem

2001-03-05 Thread Robert L King
David, You might check the "Log on As:" parameter for the TSM scheduler service that is running the command type schedule. Is it the same user as when it worked with the command line in the NT command window? Do you know if TDP for SQL 1.1.1 also fails now or just 1.1.1.01? If checking the user