Hi Robert,

Sometimes this means that the SQL Server is too busy to create a snapshot.
You may need to schedule the backup at a time when the SQL Server is not 
as busy.

Or check out this option for retries:

https://www-01.ibm.com/support/knowledgecenter/SSGSG7_7.1.4/client/r_opt_includevmsnapshotattempts.html


Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 02/16/2016 
04:56:38 AM:

> From: Robert Ouzen <rouzen AT UNIV.HAIFA.AC DOT IL>
> To: ADSM-L AT VM.MARIST DOT EDU
> Date: 02/16/2016 04:57 AM
> Subject: Re: VM machine with SQL database
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 
> HI Del
> 
> 
> 
> Thanks for the paper ...
> 
> 
> 
> I made a test on one of my machine IBROWSE with Microsoft SQL
> 
> 
> 
> I add in dsm.opt:   INCLUDE.VMTSMVSS  ibrowse
> 
> 
> 
> I run too:   dsmc set password -type=vmguest ibrowse  guest_admin_id
> guest admin_pw
> 
> 
> 
> Run the backup form console:
> 
> 
> 
> tsm> backup vm ibrowse -vmbackuptype=fullvm -mode=ifincremental
> 
> 
> 
> And got:
> 
> 
> 
> Full BACKUP VM of virtual machines 'ibrowse'.
> 
> 
> 
> 
> 
> Backup VM command started.  Total number of virtual machines to process: 
1
> 
> <       0  B> [  -]
> 
> Starting Full VM backup of VMware Virtual Machine 'ibrowse'
> 
>        mode:                        'Incremental Forever - Incremental'
> 
>         target node name:            'HAIFA_DATACENTER'
> 
>         data mover node name:        'HAIFA_DATACENTER'
> 
>         application protection type: 'TSM VSS'
> 
>         application(s) protected:    'MS SQL 2008 R2'
> 
> ANS9417E IBM Tivoli Storage Manager application protection could not
> freeze the VSS writers on the virtual machine named 'ibrowse'
> 
> . See the TSM error log for more details.
> 
> 
> 
> ANS2330E Failed to unfreeze the VSS writers because the snapshot 
> time exceeded the 10 second timeout limitation.
> 
> 
> 
> ANS4174E Full VM backup of VMware Virtual Machine 'ibrowse' failed 
> with RC=6511 mode=Incremental Forever - Incremental, target nod
> 
> e name='HAIFA_DATACENTER', data mover node name='HAIFA_DATACENTER'
> 
> 
> 
> On dsmerror.log got:
> 
> 
> 
> 02/16/2016 10:50:11 ANS4174E Full VM backup of VMware Virtual 
> Machine 'ibrowse' failed with RC=6511 mode=Incremental Forever - 
> Incremental, target node name='HAIFA_DATACENTER', data mover node 
> name='HAIFA_DATACENTER'
> 
> 02/16/2016 10:50:11 ANS1228E Sending of object 'ibrowse' failed.
> 
> 02/16/2016 10:50:11 ANS9431E IBM Tivoli Storage Manager application 
> protection failed to thaw VSS writers on virtual machine 'ibrowse'. 
> See the TSM error log for more details.
> 
> 
> 
> Any Idea what wrong ????
> 
> 
> 
> TDP for VE V7.1.4.0
> 
> TSM Client V7.1.4.1
> 
> TSM Server V7.4.1.100
> 
> 
> 
> 
> 
> Regards Robert
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On 
> Behalf Of Del Hoobler
> Sent: Monday, February 15, 2016 2:33 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] VM machine with SQL database
> 
> 
> 
> Hi Robert,
> 
> 
> 
> 
> 
> 
> 
> http://www-01.ibm.com/support/knowledgecenter/SS8TDQ_7.1.4/ve.user/
> t_vesql_configvm.html
> 
> 
> 
> 
> 
> 
> 
> Del
> 
> 
> 
> ----------------------------------------------------
> 
> 
> 
> 
> 
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU<
mailto:ADSM-L AT VM.MARIST DOT EDU
> >> wrote on 02/14/2016
> 
> 03:54:37 AM:
> 
> 
> 
> > From: Robert Ouzen <rouzen AT UNIV.HAIFA.AC DOT IL<
mailto:rouzen AT UNIV.HAIFA.AC DOT IL>>
> 
> > To: ADSM-L AT VM.MARIST DOT EDU<mailto:ADSM-L AT VM.MARIST DOT EDU>
> 
> > Date: 02/14/2016 03:56 AM
> 
> > Subject: VM machine with SQL database
> 
> > Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU<
> mailto:ADSM-L AT VM.MARIST DOT EDU>>
> 
> >
> 
> > Hi to all
> 
> >
> 
> > I backup a VM machine  name ibrowse with on it SQL  database , with
> 
> > TDP for VE V7.1.4
> 
> >
> 
> > I add on the dsm.opt the line:
> 
> >
> 
> > INCLUDE.VMTSMVSS  ibrowse
> 
> >
> 
> > I wonder if this backup delete the logs at the end of the backup or I
> 
> > need to install  a TDP for SQL
> 
> >
> 
> > T.I.A  Best Regards
> 
> >
> 
> > Robert
>