Post reply

restore .trn file to database

  • July 26, 2009 at 9:54 pm

    #203238

    Hi there

    This is first time i am doing this pls help

    I was told to restore(refresh) database every 30 mins i am getting files from server every 30 mins in .zip file

    i need to unzip so i get .trn file. (i have done so far)

    after this i donno how to restore .trn file to the dev database using scripts (bcos of automation)

    Could some 1 assist me with the scrip i tried searching but could get anything better

    Cheers

    GB

  • July 26, 2009 at 10:13 pm

    #1030363

    sqlcool (7/26/2009)

    Hi there

    This is first time i am doing this pls help

    I was told to restore(refresh) database every 30 mins i am getting files from server every 30 mins in .zip file

    i need to unzip so i get .trn file. (i have done so far)

    after this i donno how to restore .trn file to the dev database using scripts (bcos of automation)

    Could some 1 assist me with the scrip i tried searching but could get anything better

    Cheers

    GB

    Restore log YourDBName from disk='d:\path\logfile.trn' with NoRecovery

    This will restore the log file to the target database.

    I hope Your database is in norecovery mode already or else this code will fail.


    Pradeep Singh

Viewing 2 posts - 1 through 2 (of 2 total)

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