Re: LogPoolSize

2009-10-21 Thread Tchuise, Bertaut
Fred, From my previous experience, changing the bufpoolsize within TSM didn't require a reboot; I used the setopt BUFPOOLSIZE command to perform the change. BERTAUT TCHUISE TSM/NetApp Storage Administrator Legg Mason Technology Services *410-580-7032 btchu...@leggmason.com -Original

Re: VSS Hotfix list for Windows 2008

2009-10-21 Thread Sergio O. Fuentes
I've decided to turn this over to our Windows system admins. I'll also be recommending them to open a call with Microsoft support (instead of using TSM support). The crash isn't isolated to just the TSM backup window, and I can prove it with event logs from previous crashes. Therefore, I

VM/TSM

2009-10-21 Thread Timothy Hughes
Hello All, The VCB environment is setup and tested. Is it possible for the following to be done using with the Proxy Server (SNI275) TSM Client being 5.5.2? I set up TSM backup schedule to do Virtual machine file-level backup on VCB server SNI275 Do Full VM backup's, scripting needs to be

Re: VSS Hotfix list for Windows 2008

2009-10-21 Thread Cory Heikel
Sergio, The particular system I am experiencing the trouble with right now is vendor controlled. They are working with microsoft on the issue. One other thing about this system is that it is using ms/sql replication for the database and crashes are occuring during that replication as well. I'll

SQL help

2009-10-21 Thread Fred Johanson
Management want to count the number of nodes added in the last 2 months. I think this is what they want, but it returns 0 select count(node_name) from nodes where (cast((date(reg_time)-current_date)days as decimal) = 60) What did I do wrong?

Re: SQL help

2009-10-21 Thread Remco Post
On 21 okt 2009, at 21:25, Fred Johanson wrote: Management want to count the number of nodes added in the last 2 months. I think this is what they want, but it returns 0 select count(node_name) from nodes where (cast((date(reg_time)- current_date)days as decimal) = 60) select count(*) from

Re: SQL help

2009-10-21 Thread Fred Johanson
Thank you all, Remco got it. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Remco Post Sent: Wednesday, October 21, 2009 3:39 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SQL help On 21 okt 2009, at 21:25, Fred Johanson wrote:

group by assistance.

2009-10-21 Thread Shawn Drew
I'm having some trouble with the group by clause. It seems I can't group data that has been casted First start with: select cast((bytes/1024/1024/1024) as decimal(8,2)) AS GB, cast(end_time as date) as Date from summary where activity='STGPOOL BACKUP' 1794.26

Does TSM support 3-way NDMP backups?

2009-10-21 Thread Tribe
Hi, I didn't find this in the TSM manual (I'm currently using TSM 5.5) so I was hoping to get some help here: Does TSM support 3-way NDMP backups as described here? http://www.ndmp.org/info/faq.shtml#9 I found the term 3-way in a few TSM docs, but it was used to describe an environment with 1