Re: HowTo: Load Data Directly from TSM into Excel Spreadsheet?

2004-03-19 Thread Andrew Raibeck
I was playing around with this a bit and came up with the following. Keep in mind what I said earlier about knowing little about Excel. There are probably better ways to automate the management of the resulting worksheet, but this code shows you how you can create an Excel VBA macro to get the resu

Re: Bare metal restore, ASR etc.

2004-03-19 Thread Prather, Wanda
Kevin, I agree with Richard's evaluation completely. The TSM backup/restore of the System Object works ... umm.. well, it works when it works. Many versions of the client code have had problems doing restore of the System Object. ( I think the client has to call MS API's 6-7 times to get/restore

Load Data from TSM into Excel or MySQL

2004-03-19 Thread Stephen E. Bacher
Christian Demnitz <[EMAIL PROTECTED]> wrote: >is there any way, to get data from tsmdatabase directly into a mysql db? >like via odbc to ms access? > >i want to generat a report with a mysql db! I do this regularly, using the same technique you would use to load data directly from TSM into an Exc

[no subject]

2004-03-19 Thread Stapleton, Mark
From: Dean Winger >Does anybody know if or when TSM for Windows will have support for the >Spectra Logic T950 library? If it is, it will be in http://www-306.ibm.com/software/sysmgmt/products/support/IBM_TSM_Support ed_Devices_for_AIXHPSUNWIN.html -- Mark Stapleton

[no subject]

2004-03-19 Thread Dean Winger
Does anybody know if or when TSM for Windows will have support for the Spectra Logic T950 library? Thanks Dean Winger Information Systems Manager School of Education Wisconsin Center for Education Research 1025 West Johnson St Madison, WI 53706 Phone: (608)265-3202 Cell: (608)235-1425 Email: [EM

Re: SQL / big numbers ?

2004-03-19 Thread P Baines
Well, the sum() would be correct for the DB backup "attempts", however what is stored in the summary table has a different context depending on what the activity is. It isn't really documented as far as I know, but affected in the DB backup is probably pages backed up, whilst affected in the cli

Re: SQL / big numbers ?

2004-03-19 Thread goran
ok, thanks ... i replaced all "sum" with "count" and this is what i got ... ACTIVITY Attempts Failed % Success -- --- --- -- ARCHIVE112 112 0.00 BACKUP

Re: SQL / big numbers ?

2004-03-19 Thread P Baines
Hello Goran, you named the column "attempts" but it's actually called affected. The number of attempts (for the db backup) would be a count() rather than a sum() fuction. The number you summed probably refers to the number of database pages backed up. Paul. -Original Message- From: ADS

Re: Exchange 5.5 Restore to Different server

2004-03-19 Thread Del Hoobler
Jim, Please note you are running an older, unsupported version of Data Protection for Exchange. You should download and install the latest version, which is Data Protection for Exchange verion 5.2.1. There is an appendix called Advanced Restore Procedures that explain how to restore an Exchange 5

SQL / big numbers ?

2004-03-19 Thread goran
hi all, i have a script which shows some kinda percentage of weekly activity from summary table but i'm confused by big numbers that come out, heres the sql > select activity, cast(sum(affected) as integer)as "Attempts", cast(sum(failed) as integer) as "Failed", cast((1-(cast(sum(failed) as dec

Re: Making client files inactive so they will age off

2004-03-19 Thread Richard Sims
>We have a client which is disappearing. I would like to do an >incremental to set everything to inactive so it will age off gracefully. ... This is best done by either emptying the client file system and then doing a last Incremental backup, or by creating an empty file system on the client and

Re: Making client files inactive so they will age off

2004-03-19 Thread Bill Fitzgerald
This is what I do when I have a client that is no longer required on TSM. 1. delete all the file spaces for the client {delete filespace wait=no} This deletes all references to the filespace and the files backed up for that filespace from the TSM database 2. delete the client {remove node } Th

Re: SQL Query Challenge

2004-03-19 Thread David E Ehresman
Just realize that "Success" in that context only means the backup session ended "normally", not that all the files were successfully backed up. David >>> [EMAIL PROTECTED] 3/18/2004 4:10:03 PM >>> Sorry, I should have been more explicit. Currently I run a query that is: QUERY EVENT * * BEGIND

Exchange 5.5 Restore to Different server

2004-03-19 Thread Jelf, Jim
Is it possible to restore and Exchange 5.5 database to a different server? We are using TDP for Exchange version 2.2.0. We have identical systems in the same domain and our original Exchange server is still active. We simply want to take the Exchange database and appropriate log files from a previo

ANS1228e/1931E

2004-03-19 Thread Moses Show
Afternoon people, Attempted to run a daily incremental backup of a windows server with TSM client. However the backup failed with references ANS1228E and ANS1931E. Can anyone offer any info as to the probable causes of this. Any help would be gratefully appreciated.

Making client files inactive so they will age off

2004-03-19 Thread Lee, Gary D.
Hope I am not working from an incorrect premise. We have a client which is disappearing. I would like to do an incremental to set everything to inactive so it will age off gracefully. However, when I gried this yesterday it went ahead and backed up enyway. Tsm server v5.1.6.2 on solaris 2.8. Cli

Re: veritas backup exec client and TSM server

2004-03-19 Thread Consiglio, Tony
I have been reading this thread from the beginning, and I just wanted to place my "two cents" in here :-)Veritas actually wrote the code for MS long ago. MS has adopted the basic backup-exec code and improved on it a bit..This being right from both MS and Veritas techs... What I have not read

Eddie Jones is out of the office.

2004-03-19 Thread Eddie Jones
I will be out of the office starting 03/19/2004 and will not return until 03/22/2004. I will respond to your message when I return.

[no subject]

2004-03-19 Thread Christian Demnitz
Hi, is there any way, to get data from tsmdatabase directly into a mysql db? like via odbc to ms access? i want to generat a report with a mysql db! Christian Demnitz

Restore Using TDP for Lotus Domino

2004-03-19 Thread Nicolas Savva
Hi to all I am trying to restore a database using TDP for Lotus Domino and i receive the following error message: " LAIKI_TSM_Server ANE4993E TDP Domino ACD5230 Data protection for Domino: Restore of database .nsf to LTServer1 failed. " >From the restore log i receive the error message "Skip