Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005

    Question Unanswered: Is there a script to restore multiple transaction logs?

    I am currently running MSSQL on DB1 server with 12 DBs
    I am running a full backup nightly at 8:00pm and coping it over to DB2.
    I am sending transaction logs every 15 minutes to DB2.

    Is there a script or procedure for rolling in all the logs once the restore is finished. I realize the basic way to do this is here
    But writing a script with say 22 files each for each db is fairly time consuming.

    I have contemplated writing a script that takes the content of the logs directory, parses it based on db name and builds the sql statements but did not want to go through all of it if someone else has already done the leg work.

    Any help on this would be appreciated.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Isn't that built into the log-shipping tools?


  3. #3
    Join Date
    Jun 2003
    Provided Answers: 1
    You are restoring logs after loading a full backup?
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts