Home Forums SQL Server 2005 Administering Log Shipping 'skipping' all logs and not restoring RE: Log Shipping 'skipping' all logs and not restoring

  • Janet, Keith, Deepak,

    Thank-you for all your shared experience and advice. I tried a different tack, and worked. My Primary Database had alkready been configured for Transaction Log Backups. The backups were produced with naming convention dbname_backup_timestamp.trn. When I configured log shipping, a 2nd set of transaction log files was produced with namimg convention dbname_timestamp.trn. These 2nd files were then shipped successfully, but I believe the log sequencing with the files was disrupted by the initial transaction log backups.

    So...

    - I stopped transaction log backups on the primary database

    - De-configured log shipping (is that a word ???? 🙂 )

    - took a new FULL backup of the primary database

    - restored this to the 2ndary database (with standby option)

    - deleted ALL .trn file on primary and 2ndary servers

    - Reconfigured log shipping

    the restore job now picks up logs and reports that it has restored them.

    Regards, Neil

    ps. I think I have another problem with availability of the 2ndary database now. It shows up in SQL Management Studio as (restoring...) and the database cannot be opened. I hope this resolves itself as the restore 'catches up'.

    - configured log shipping