Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    London
    Posts
    169

    Unanswered: Help Log Shipping

    Hi,

    I just accidently deleted a database that was being log shipped to, and now it wont restore the logs.

    I restored the database, and when I try to restore the logs by running the old job it tells me this:

    Executed as user: sa. The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step. [SQLSTATE 42000] (Error 4306) RESTORE LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013) Mail sent. [SQLSTATE 01000] (Error 17967). The step failed.


    Err help, gonna get my ass kicked for this

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    You must restore the full source database backup on the destination database by using either the NORECOVERY or the STANDBY option for log shipping to work.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    Hi,

    Ok that kind of worked, but when restroring the log I got a new error:

    Executed as user: sa. The log in this backup set begins at LSN 239312000000004600001, which is too late to apply to the database. An earlier log backup that includes LSN 237268000000010100001 can be restored. [SQLSTATE 42000] (Error 4305) RESTORE LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013) Mail sent. [SQLSTATE 01000] (Error 17967). The step failed.

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    Depending on the size of the production database, why not just re-initialize the log shipping job. It's a pain, but it's a sure way to make sure you're back up and running.

    The specific problem that the error message is reporting is that the database is expecting an earlier log file to be applied. You have to properly identify, sequence and apply all the log files from the point at which you restored the database. Each one must be applied with the STANDBY or NORECOVERY option.

    This isn't much comfort I realize, but I hope it helps.

    Regards,

    hmscott

Posting Permissions

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