I've got something of a revolt on my hands from our SQL DBAs when it comes
to the new Flash Copy Manager interface for TDP for SQL. Fundamentally,
their objections arise from an inability to specify the name of a custom
options file when launching the console.
Previously, when managing multiple SQL Server instances in a Failover
Cluster the DBAs would have numerous shortcuts to TDPSQL.EXE with each
using the /TSMOPTFILE switch (along with /SQLSERVER ) to specify a
different options file on a shared disk. Unfortunately
FLASHCOPYMANAGER.EXE doesn't seem to allow the options file to be
specified in this way.
IBM offer some advice to work around this limitation but this seems to
boil down to reverting to using the now deprecated TDPSQL.EXE or a rather
kludgy series of scripts to overwrite the default copy of the options file
with a custom version prior to launching the console:
http://www-01.ibm.com/support/docview.wss?uid=swg21597023
Neither of these is especially attractive and I wondered if anyone else
had a better way of coping with this scenario? The technote above makes
reference to reviewing this capability for future releases but given this
is now a year old and we've seen v7.1 arrive in the mean time, I'm
guessing they don't see it as a priority.
Regards
Neil Schofield
Infrastructure Architect, Hardware Engineering
Yorkshire Water
----------------------------------------
Spotted a leak?
If you spot a leak please report it immediately. Call us on 0800 57 3553 or go
to http://www.yorkshirewater.com/leaks
Get a free water saving pack
Don't forget to request your free water and energy saving pack, it could save
you money on your utility bills and help you conserve water.
http://www.yorkshirewater.com/savewater
The information in this e-mail, and any files transmitted with it, is
confidential and may also be legally privileged. The contents are intended
solely for the addressee only and are subject to the legal notice available at
http://www.keldagroup.com/email.htm. This email does not constitute a binding
offer, acceptance, amendment, waiver or other agreement, or create any
obligation whatsoever, unless such intention is clearly stated in the body of
the email. If you are not the intended recipient, please return the message by
replying to it and then delete the message from your computer. Any disclosure,
copying, distribution or action taken in reliance on its contents is prohibited
and may be unlawful.
Yorkshire Water Services Limited
Registered Office Western House, Halifax Road, Bradford, BD6 2SZ
Registered in England and Wales No 2366682
|
