What are the challenges you face when working across database platforms? Take the survey
Options

Log Shipping

Our log shipping was running for almost 2 weeks when it started failing to restore the log files over and over again.  I am not sure why it was failing but I am trying to create a new log shipping job as I always do once the original job fails for more than 24 hours in a row.  5 times now I have gotten to the Restoring Database To Destination Server step and then it just says it failed because "an abort request is preventing anything except termination actions"  I have restarted MSSQL and SQL Backup and it still continues to fail on this step with the same error.  Please help

Answers

  • Options
    Hi SQL_Dude,

    Thanks for posting on the Redgate forums.

    Are you able to provide the full log please as this usually contains more detailed error messages, you can either post this here or forward onto support@red-gate.com
    Kind regards,
    Dan Bainbridge
    Product Support Engineer | Redgate Software
  • Options
    SQL_DudeSQL_Dude Posts: 11 Bronze 1
    Hey Dan,
    We updated to the latest version of SQL Backup.  Running this on SQL Server 2012 on a clustered server.
    The problem above started happening again this week and I'm unable to get past it this time.

    Attaching one of the log files for review

    Thanks for your help.
Sign In or Register to comment.