Guys, Has anyone tried/done this before? If I was to use a tool such as EMC TimeFinder (in particular, using the EMC TimeFinder/SQL Server Integration Utility) to take a consistent database snapshot image (via the MS SQL VDI) of a SQL Server (2000) database (i.e. a 'recoverable database image' as opposed to a 'restartable' one), could I then use the Tivoli Data Protection for SQL Server agent to apply subsequent backed up transaction logs to this copy in order to roll the database forward to a point in time? Or, would TDPS only be able to action a transaction log recovery to a database image that has been backed up/restored using TDPS? Put simply, particularly with larger SQL Server databases (hundreds of GB's), I'm looking at ways to reduce the recovery time in the event of failure. Restoring a database image from a daily BCV/Clone would do most of the work very quickly indeed, but would only give me a recovery point of a maximum of 24 hours. However, if I were able to reapply transaction logs to this I would have the best of both worlds. As we use the TDP to whisk away transaction logs on (usually) an hourly basis, I'd be looking the to TDP to action the restore of the transaction logs to the BCV copy, but appreciate that what I'm asking might not be 'native' functionality. I'm happy to expand if any of the above is unclear! Any thoughts much appreciated. Thanks and Rgds, David McClelland IBM Tivoli Certified Deployment Professional (TSM 5.2) Shared Infrastructure Architecture and Design Reuters, London Ltd
To find out more about Reuters visit www.about.reuters.com Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.