RE: Restoring a level-1 backup at a later date?

You say "same basic machine & OS" - what are the Informix versions ? Remember backup & restore is only supported on the same versions of Informix -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of malc_p@btinternet.com Sent: 03 February 2005 12:15 PM To: informix-list@iiug.org Subject: Restoring a level-1 backup at a later date? Here's a good one. (IDS9.30, HP-UX 11i) We're moving to a different facility and new hardware (same basic machine & OS) at the end of the month and in order to minimise the time taken to transfer our 180Gb instance and allow the users unfettered access up to the very last minute (god we're so good to them) we'd like to do the following using OnBar: 1) Run a level-0 backup on the Thursday night from the old production server (currently this takes about 7 hours). 2) Restore this to the new server at the new facility (L0 restore time at present is about 12 hours end-to-end). 3) Leave the new server in limbo while the users have continued access to the old box. 4) Friday night kick the users and then take a level-1 of the old production box - we've tested this and it takes about 2.5 hours. 5) Take this level 1 and restore it to the new box (which should take about 3 hours) and let the users onto the new box. Thus the users should lose only 3 hours instead of 12. Can we do this? From the OnBar guide it looks like we can't but our scenario isn't covered. Sorry, we haven't had time to do a test run so we're after list wisdom (anyone called Obnoxio please pipe down!) Malc (Copying to ids@iiug.org) sending to informix-list