Robert, I'm not familiar with the options you mention below. However, assuming you are using TDP for SQL (or something else to backup the SQL DB and LOG data), I'd recommend specific INCLUDE and/or EXCLUDE statements to effectively exclude the disks that have the DATA and LOGS on them. Then, for a restore, you would perform a VM restore and then a database restore. The VM restore will restore all disks in the VM including the EXCLUDED ones; the EXCLUDED disks will be blank.
So, in your DSM.OPT file you'd have something like this: INCLUDE.VMDISK "vm_name_goes_here" "Hard Disk 1" INCLUDE.VMDISK "vm_name_goes_here" "Hard Disk 2" EXCLUDE.VMDISK "vm_name_goes_here" "Hard Disk 3" EXCLUDE.VMDISK "vm_name_goes_here" "Hard Disk 4" You can find specific information on these parameters in the TSM Baclient 6.4 manual http://pic.dhe.ibm.com/infocenter/tsminfo/v6r4/topic/com.ibm.itsm.client.doc/b_ba_guide_win.pdf. The Windows version had the information starting on about page 371. (my PDF reader said I was on page 395) Ray Storer NIBCO INC. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Robert Ouzen Sent: Thursday, May 16, 2013 4:42 AM To: [email protected] Subject: [ADSM-L] TSM for VE for SQL machine Hi to all I want to ask if anybody already backup with TSM for VE 6.4.0.1 a VM with on it Microsoft SQL Server 2008 .What will be the best way to backup it and what commands to use. Did I need to add those options in the dsm.opt APPLICATION PROTECTION TYPE:'TDP VSS' 'APPLICATION(S) PROTECTED:'MS SQL 2008' INCLUDE.VMTSMVSS vmware1,vmware2,vmware3 ,.... Best regards Robert ________________________________ CONFIDENTIALITY NOTICE: This email and any attachments are for the exclusive and confidential use of the intended recipient. If you are not the intended recipient, please do not read, distribute or take action in reliance upon this message. If you have received this in error, please notify us immediately by return email and promptly delete this message and its attachments from your computer system. We do not waive attorney-client or work product privilege by the transmission of this message.
