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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Robert Ouzen
Sent: Thursday, May 16, 2013 4:42 AM
To: ADSM-L AT VM.MARIST DOT EDU
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.
|