Re: Issue restoring SQL database via TDP

2017-11-01 Thread Paul_Dudley
r "ADSM: Dist Stor Manager" wrote on 2017-10-31 23:07:56: > From: Paul_Dudley > To: ADSM-L@VM.MARIST.EDU > Date: 2017-10-31 23:09 > Subject: Issue restoring SQL database via TDP Sent by: "ADSM: Dist > Stor Manager" > > I was trying to restore an SQL database

Issue restoring SQL database via TDP

2017-10-31 Thread Paul_Dudley
I was trying to restore an SQL database from one server (production) to another server (test) and over the top of a database with a different name. On the production server the database is called "InterfaceLoggingProduction". On the test server the database I was trying to restore over the top

Increase resourcetimeout TSM 6.3

2017-07-11 Thread Paul_Dudley
How do you increase the resourcetimeout value in TSM 6.3? From the TSM Administrative Command Line I have run the command "resourcetimeout 120" however this fails with an unknown command error. I have checked the dsmserv.opt file on the server but there is no mention of a resourcetimeout parame

Backing up Active Directory server using TSM client

2016-11-07 Thread Paul_Dudley
Is there any point in backing up an Active Directory server using the TSM client? Would a restore of Active Directory work? I have read conflicting views on this - some say it would not work yet others say it has worked for them, while others say that they use another tool to backup Active Direc

Making use of two NICs

2016-09-13 Thread Paul_Dudley
We have TSM v6.3 running on an IBM x3650 M4 server with Windows 2008. The server has a second un-used NIC. If we configure and connect the second NIC, is it possible to make use of it so that TSM network traffic (ie: backups) could be spread across the two NICs? Thanks & Regards Paul

Re: query auditocc question

2016-08-10 Thread Paul_Dudley
iginal Message- From: Paul_Dudley [mailto:pdud...@anl.com.au] Sent: Thursday, 28 July 2016 10:11 AM To: 'ADSM: Dist Stor Manager' Subject: RE: query auditocc question Thanks. I ran this command and it ran successfully and provided me with a list of totals. However they are a lot high

Re: query occupancy command - file names

2016-08-07 Thread Paul_Dudley
ong. Regards Ulli Maenz -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Im Auftrag von Paul_Dudley Gesendet: Donnerstag, 4. August 2016 02:11 An: ADSM-L@VM.MARIST.EDU Betreff: [ADSM-L] query occupancy command - file names The query occupancy command

query occupancy command - file names

2016-08-03 Thread Paul_Dudley
The query occupancy command below shows 283 files in the bkplto6pool storage pool for this filespace. Is it possible to get a list of the file names? tsm: TSMANL>query occ ANLDBPROD_SQL stgp=bkplto6pool type=backup Node Name Type Filespace FSID Storage Number of

Re: query auditocc question

2016-08-01 Thread Paul_Dudley
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul_Dudley Sent: Wednesday, July 27, 2016 8:11 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] query auditocc question Thanks. I ran this command and it ran successfully and provided me with a list of totals. However they are a

Re: query auditocc question

2016-07-27 Thread Paul_Dudley
uery auditocc question Perhaps the following query would give you better data: select node_name,sum(reporting_mb) as "TOTAL_OCCUPANCY" from occupancy group by node_name -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Paul_Dudley Sent: Tu

Re: query auditocc question

2016-07-27 Thread Paul_Dudley
, 27 July 2016 2:33 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] query auditocc question Paul, The metrics displayed by Q AUDITOCC are updated by AUDIT LICENSE; not in real time. ..Paul (sent from my iPhone) On Jul 26, 2016, at 9:37 PM, Paul_Dudley mailto:pdud...@anl.com.au>> wrote

query auditocc question

2016-07-26 Thread Paul_Dudley
To keep track of our primary storage usage, on a weekly basis I run the following command: query auditocc pooltype=primary For one of the nodes - an SQL server - it is reporting that the backup storage used is 7Tb. However knowing the size of the databases on that server and the number of

Re: Library offline issue

2016-03-19 Thread Paul_Dudley
libtype=scsi shared=no resetd=no autolabel=no relabelscr=no serial=00L4U78L0331_LL0 ANR8529E UPDATE LIBRARY: Unable to open library LB0.1.0.6 by using an open system call. ANS8001I Return code 11. Thanks & Regards Paul From: Paul_Dudley [mailto:pdud...@anl.com.au] Sent: Thursd

Library offline issue

2016-03-19 Thread Paul_Dudley
We are running TSM version 6.3 on a Windows 2008 server with an IBM TS3200 tape library. The windows server crashed overnight. It has been rebooted and is working ok now however TSM will not talk to the tape library drives. I have powered the tape library off and on and have also performed a cle

Re: Library offline issue

2016-03-19 Thread Paul_Dudley
y on or read the devicedriver documentation of the IBM Tape driver on how to enable persistent naming, which makes life much easier. -- Michael Prix Am 17.03.2016 um 01:21 schrieb Paul_Dudley: > Further to my message below, the "q library f=d" command does display details > about t

Re: Library offline issue

2016-03-18 Thread Paul_Dudley
enable sandiscovery: setopt sandiscovery on or read the devicedriver documentation of the IBM Tape driver on how to enable persistent naming, which makes life much easier. -- Michael Prix Am 17.03.2016 um 01:21 schrieb Paul_Dudley: > Further to my message below, the "q library f=d&q

Re: What have they done to Passport!

2016-02-23 Thread Paul_Dudley
I have wasted hours of my life on the Passport Advantage site going around in circles. Of any website by any major manufacturer of any product, it is far and away the worst I have ever encountered. Thanks & Regards Paul -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@V

Moving nodes to a new policy

2015-06-04 Thread Paul_Dudley
If I have nodes that are currently under a policy that keeps 5 backup versions, can I move them to another policy which keeps only 2 backup versions? Will TSM then start expiring all the older backup versions of files which are no longer needed? We have two nodes which are taking up a lot of ba

Change from PVU to Unified licensing

2014-11-06 Thread Paul_Dudley
We have recently changed from PVU based licensing to the Unified/Terabyte based licensing model on TSM. What do I need to do on the TSM system itself to update the licensing? Is there a file that needs to be updated or a command that needs to be run? When I run "q lic" it is still showing the o

FW: TDP Flashcopy - restore to alternate location

2014-04-09 Thread Paul_Dudley
More research and testing on the issue below seems to indicate that I have to change the backup type from VSS to Legacy to fully enable the Restore Alternate Location option on the target server. Thanks & Regards Paul > We have TSM v6.3. On two Windows 2012 64bit servers we have the TDP Storag

TDP Flashcopy - restore to alternate location

2014-04-09 Thread Paul_Dudley
We have TSM v6.3. On two Windows 2012 64bit servers we have the TDP Storage Flashcopy manager v3.2.1.0 client. Both of these servers run MS SQL Server 2012. I would like to restore databases backed up on one server to the other. The databases are backed up using the "tdpsqlc backup * full" co

Re: Error when installing TSM client on RHES 5.7

2012-09-12 Thread Paul_Dudley
1.so.2 yum whatprovides */libXp.so.6 will tell you what is missing. HTH Grant On 13/09/12 11:43, Paul_Dudley wrote: > Hi all, > > > > I am trying to install the TSM client on Red Hat linux version ES 5.7. > TIVsm-API-5.2.0-0 has installed OK via the rpm command however

Error when installing TSM client on RHES 5.7

2012-09-12 Thread Paul_Dudley
Hi all, I am trying to install the TSM client on Red Hat linux version ES 5.7. TIVsm-API-5.2.0-0 has installed OK via the rpm command however I have run into the problem below: rpm -i TIVsm-BA.i386.rpm error: Failed dependencies: libstdc++-libc6.1-1.so.2 is needed by TIVsm-BA-5.2.

Re: LTO3 and LTO4 tape classes

2012-04-18 Thread Paul_Dudley
by (administrator): ADMIN Last Update Date/Time: 05/20/2010 10:44:36 Thanks & Regards Paul -Original Message- Paul, Can you please post q devc LTO4CLASS f=d Steve Steven Harris TSM Admin Canberra Australia On 17.04.2012 19:35, Paul_Dudley wrote: > We have a mixture o

LTO3 and LTO4 tape classes

2012-04-17 Thread Paul_Dudley
We have a mixture of LTO3 and LTO4 tapes in the one tape library. Our primary disk backup storage pool - BKPPOOL - is set to migrate to BKPLTO4POOL when it reaches 90% full. The storage pool BKPLTO4POOL is set to device class LTO4CLASS. We also have device class LTO3CLASS for the LTO3 tapes.

Re: Excessive number of filling tapes...

2012-02-06 Thread Paul_Dudley
Re your line " None of them has data from more than one client" Has collocation been turned on by accident? Thanks & Regards Paul     > > So, I've got an offsite machine which exists to accept remote virtual > volumes. For years, now, the filling volumes have behaved in a way I > thought I unde

Re: Offsite copypool question

2012-01-19 Thread Paul_Dudley
> -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of > Xav Paice > > ----- "Paul_Dudley" wrote: > > On the SQL servers I have included the SQL database folder in the > > Exclude-Include configuration o

Offsite copypool question

2012-01-16 Thread Paul_Dudley
We have a linux shell script which we use to create our offsite copypool tapes. Basically the commands are: backup stg SQLDB_LTO4 SQLDB_COPYPOOL wait=yes backup stg BKPLTO4POOL COPYPOOL_LTO3 wait=yes Our primary SQL storage pool is SQLDB_DISKPOOL and it's secondary pool for data migratio

TS3200 tape library checkin question

2011-07-20 Thread Paul_Dudley
We have an IBM TS3200 tape library, which takes both LTO4 & LTO3 tapes. The I/O cartridge has capacity to slot in 3 tapes at a time. However I am not sure what is the correct command to check in 3 scratch tapes at the one time and get the tape library to search the I/O cartridge for each of the

Re: SQL query - large files

2011-07-17 Thread Paul_Dudley
> -Original Message- > > On Jul 17, 2011, at 9:07 PM, Paul_Dudley wrote: > > > Is it possible to interrogate the TSM database with an SQL query to display > > the > list of backed up files whose size is larger than - for example - 160 Mbs? > > > >

SQL query - large files

2011-07-17 Thread Paul_Dudley
Is it possible to interrogate the TSM database with an SQL query to display the list of backed up files whose size is larger than - for example - 160 Mbs? I understand that this will be a query that will take a while to run so I am prepared to run it on the weekend. While the total number of fil

Re: Copypool storage advice

2011-04-12 Thread Paul_Dudley
only things with an "offisite status, as I recall. If you do QUERY LIBVOL > * > , do they show up? If TSM "knows" they're in the library, they won't be > reclaimed if they're in "FILLING" status, as I recall. > > I love a good puzzle.

Re: Copypool storage advice

2011-04-10 Thread Paul_Dudley
Collocation for the storage pool is set to "none". No I am not using the "du=" parameter on the reclaim commands. I check the log and they do finish successfully. They are a mixture of "full" and "filling" tapes. They are all set as "offsite". Thanks & Regards Paul > > > I currently have a lot

Re: Ang: Copypool storage advice

2011-04-07 Thread Paul_Dudley
The copypool is on LTO3 tapes. They are not database backups just incremental server backups Thanks & Regards Paul > -Original Message- > > It would be helpful to know what kind of the tape technology you're using > since the > reclamation threshold % is usually based off which technol

Copypool storage advice

2011-04-07 Thread Paul_Dudley
I currently have a lot of copypool storage tapes which are between 50 - 60% utilization. Expiration runs daily and I run reclaimation daily on this copypool, set to 50. Is there anything I can do to try and consolidate the data onto fewer copypool tapes? Thanks & Regards Paul Paul Dudley

Re: Copypool storage question

2011-02-10 Thread Paul_Dudley
> > Regards > > Steve. > > > On 10/02/2011 6:10 PM, Paul_Dudley wrote: > > Our primary tape backup pool is set to keep 5 versions of each file. Each > > morning > the overnight incremental backups into this storage pool are copied into the > copypool and th

Copypool storage question

2011-02-09 Thread Paul_Dudley
Our primary tape backup pool is set to keep 5 versions of each file. Each morning the overnight incremental backups into this storage pool are copied into the copypool and then these tapes are sent offsite. Is there anyway to setup the copypool so that it only has the last 2 versions of each fil

Re: Deleting ALL tapes from a defunct TSM server from Volhist

2011-01-23 Thread Paul_Dudley
> Subject: [ADSM-L] Deleting ALL tapes from a defunct TSM server from Volhist > > Back in 2008 there was a thread on forcing the deletion of individual > tapes from a defunct TSM server. > > > > http://www.adsm.org/lists/html/ADSM-L/2008-06/msg00068.html > > del volhist todate=today type=remote vol

Re: Copypool storage pool questions

2010-10-21 Thread Paul_Dudley
Thanks for the reply but one thing I am still confused about are these copypool tapes sitting in my onsite tape library. Given that the primary reason for this copypool is for offsite tapes, should these copypool tapes currently residing in my tape library (created by reclaimation processes) be

Re: Copypool storage pool questions

2010-10-10 Thread Paul_Dudley
No I do not have collocation turned on for that storage pool. Offsite tapes are coming back when they are defined as empty after the reclaimation and expiration processes have done their work. However as part of the reclaimation process on that storage pool it is using tapes onsite that are in t

Re: Copypool storage pool questions

2010-10-10 Thread Paul_Dudley
opy pool or primary pool? > > Regards, > > Rajesh Lakshminarayanan > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of > Paul_Dudley > Sent: Thursday, October 07, 2010 8:00 AM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L]

Copypool storage pool questions

2010-10-06 Thread Paul_Dudley
Each weekday morning we run the following command "backup stg BKPLTO4POOL COPYPOOL_LTO3" to backup the data that has been backed up overnight onto LTO3 tapes and then checkout these LTO3 tapes and send them offsite. I have a reclaimation process running on a daily basis for the COPYPOOL_LTO3 sto

Storage Pool Migration

2010-10-06 Thread Paul_Dudley
We have TSM 5.5. Shortly after this was originally setup at the start of this year data from the DIRMC storage pool was migrated to tape due to the settings for the DIRMC storage pool not being correct. Now 9 months later the DIRMC storage pool is still only at 3% of capacity. The migrated data

TSM Copypool question

2010-06-23 Thread Paul_Dudley
We have recently installed TSM 5.5 on a new server and using a new IBM TS3200 tape library. It took some time to migrate the data over from the tapes used in the old tape library to the new (migrating data from LTO2 & LTO3 tapes to LTO4 tapes) but that has finally finished. While that was ha

Assign scratch volumes to a device class

2010-05-09 Thread Paul_Dudley
Is it possible to assign scratch volumes to a specific device class? We have TSM 5.5 with an IBM TS3200 tape library. It has a mixture of LTO4 and LTO3 tapes in it. Various processes keep using LTO4 scratch tapes when I direct them to use LTO3 tapes, and vice a versa. For example running the

ACO5423E TDPsql error

2010-05-05 Thread Paul_Dudley
I am getting an error on a couple of Windows 2003 SP2 servers - one has MS 2005 SQL Express and the other has the full MS 2005 SQL installed. The TDP SQL client software is version 5.3.3.0 and I have also installed the 22699_4 patch. The error is - ACO5423E Microsoft ODBC SQL Server Driver DB

Backing up Vcenter with TSM

2010-05-05 Thread Paul_Dudley
We have VM Ware VSphere with VCenter running on a Windows 2003 SP2 server and TSM 5.5. Has anyone encountered any problems in using TSM to back up VCenter? Thanks & Regards Paul Paul Dudley Senior IT Systems Administrator ANL Container Line Pty Limited Email: pdud...@anl.com.au