Don't know if you can apply the logs this way on MSSQL. It would work for SAP on Oracle databases, but there offline logs are used.
You will get a problem with the expiration of the logs iif you don't make full backups to TSM. The transactionlogs will never be marked inactive. So they will stay within TSM 'forever'. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of David McClelland Sent: vrijdag 14 juli 2006 13:07 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Using TDP for SQL to reapply transaction logs against a BCV/Snapshot database recoverable image 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.
Dit bericht is vertrouwelijk en kan geheime informatie bevatten enkel bestemd voor de geadresseerde. Indien dit bericht niet voor u is bestemd, verzoeken wij u dit onmiddellijk aan ons te melden en het bericht te vernietigen. Aangezien de integriteit van het bericht niet veilig gesteld is middels verzending via internet, kan Atos Origin niet aansprakelijk worden gehouden voor de inhoud daarvan. Hoewel wij ons inspannen een virusvrij netwerk te hanteren, geven wij geen enkele garantie dat dit bericht virusvrij is, noch aanvaarden wij enige aansprakelijkheid voor de mogelijke aanwezigheid van een virus in dit bericht. Op al onze rechtsverhoudingen, aanbiedingen en overeenkomsten waaronder Atos Origin goederen en/of diensten levert zijn met uitsluiting van alle andere voorwaarden de Leveringsvoorwaarden van Atos Origin van toepassing. Deze worden u op aanvraag direct kosteloos toegezonden. This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Origin group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. On all offers and agreements under which Atos Origin supplies goods and/or services of whatever nature, the Terms of Delivery from Atos Origin exclusively apply. The Terms of Delivery shall be promptly submitted to you on your request.
