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
