TDPSQL problem (ANS1309I (RC9) The requested data is offline)

2008-03-31 Thread Jop de Graaf
Hi All, We've got an issue regarding the TDPSQL. We have a TSM Server on Windows v5.4.1.0. We have a SQL Server 2005. Client wise we tried with the following configurations: 1: The TSM BAclient (for the API) was v5.4.0.2 with a The TDP for SQL was v5.2.1.6 2: The TSM BAclient is upgraded to v5.

TDPSQL problem (ANS1309I (RC9) The requested data is offline)

2008-03-31 Thread Jop de Graaf
Hi All, We've got an issue regarding the TDPSQL. We have a TSM Server on Windows v5.4.1.0. We have a SQL Server 2005. Client wise we tried with the following configurations: 1: The TSM BAclient (for the API) was v5.4.0.2 with a The TDP for SQL was v5.2.1.6 2: The TSM BAclient is upgraded to v5.

Re: Two TSM Servers

2005-06-29 Thread Jop de Graaf
structures. HTH, Bill Colwell > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of Jop de Graaf > Sent: Wednesday, June 29, 2005 6:46 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Two TSM Servers > > Hi, > > Is it possible

Two TSM Servers

2005-06-29 Thread Jop de Graaf
version must be removed but is this, in this case, troublesome for the first server? Thanks. Jop de Graaf

Re: Backup Information

2005-06-22 Thread Jop de Graaf
w and I'll mail it (approx 17 MB). Jop de Graaf Interaccess -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Debbie Bassler Sent: dinsdag 21 juni 2005 22:10 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Backup Information I was looking at the datab

Re: Recovery of mirrored db and log volumes

2005-06-21 Thread Jop de Graaf
Hi Farren, as copy 1 is still off-line you can handle the LOG the same as the DB. It works fine, no problem. After creating the space on OS and doing the logcopy it fills the new volume from the one that's still online. Good luck. Jop de Graaf Certified Tivoli Consultant/Instr

Re: Antwort: Re: [ADSM-L] select

2005-06-20 Thread Jop de Graaf
Hi Dierk, Nope, just narrow and wide. If you want to sort stuff or if you want a wider view try it with the "-outfile" and import this in a spreadsheet. Cheers, Jop de Graaf Certified Tivoli Consultant/Instructor InterAccess Netherlands -Original Message- From: ADSM: Dist St

Re: Recovery of mirrored db and log volumes

2005-06-20 Thread Jop de Graaf
Sync'd, and you have done the same for the log file (q logv), you can remove the busted copy (dele dbv & dele logv), leaving two volumes (one original and one copy) in place. Cheers, Jop de Graaf Certified Tivoli Consultant/Instructor InterAccess Netherlands -Original Message- F

Re: select

2005-06-20 Thread Jop de Graaf
Hi, Try the following: Set sqldisplaymode wide (you can check the settings with 'q sql' on the server) Or spool the output of this command to a file. Dsmadmc -id=Userid -pa=YourPassword -outfile=NameOfYourFile 'select xxx ...' Cheers. Jop de Graaf -Original Message--