Post reply

Is this possible?

  • January 23, 2008 at 4:56 pm

    #71065

    Is it possible to backup txn log to 2 locations - one with init and one without noinit?

  • January 23, 2008 at 5:49 pm

    #771109

    Not that I know. How about backing up to individual files to one location, then copy the latest to the other location deleting the old one?

    Or, backup with noinit, then get the max file number to get the latest one.

    _____________
    Donn Policarpio

  • January 23, 2008 at 6:09 pm

    #771111

    Thanks for the answer. What i am planing on doing is backing up to 2 locations. The one with init will be used to refresh my stand by database (for reporting purpose) and the other will be used for archiving.

    But if i backup with noinit, i dont know, how to load the last txn in file onto my stand by database?

    Any input will be greatly apprecaited.

    Thanks again,

    Cali

  • January 23, 2008 at 7:46 pm

    #771127

    Use RESTORE LOG...WITH FILE =

    If you look at the header information of your backup file (using RESTORE HEADERONLY), you take the file number from the POSITION column..the latest backup would then be the max file number.

    Why not setup log shipping?

    _____________
    Donn Policarpio

  • January 24, 2008 at 11:16 am

    #771424

    Thanks for the answer.

    Restore log with file option will load the static number given to the restore. I want to run this restore command all automated and there wont be any maunal intervention here. in that case, how does it work? I.E, Let's say i made 5 txn log backup's over the time, Is the restore log command smart enough to go and pick the last file in the chain?

  • January 24, 2008 at 12:37 pm

    #771469

    Then you'll have to script it out. Load the result of restore headeronly to a temp table, then query the position column.

    Log shipping is the way to go if you want automated restore to a standby database.

    _____________
    Donn Policarpio

  • January 24, 2008 at 1:19 pm

    #771488

    Thanks everyone for your contribution. Looks like Logshipping has all what i am looking for. i started reading more about logshipping and have to plan out to implement it.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply