Log Shipping Not Able to Restore Log Files in Secondary

• regnar

  Newbie

  Points: 0

  More actions

  March 22, 2025 at 2:16 pm

  #4565232

  I'm attempting to set up log shipping from SQL Server 2005 Standard to SQL Server 2017 Standard. I have restored the database in the follow storage layout on the SQL Server 2017 machine:

  D:\Data\<filename>.mdf
  L:\Logs\<filename>.ldf

  When I execute the restore job and it skips all log backups. I ran restore verifyonly for the log backups and it is saying that the directory path is not valid.

  Message from restore verifyonly:

  The path specified by "D:\Local\<filename>.mdf" is not in a valid directory.

  Directory lookup for the file "D:\Local_logs\<filename>.ldf" failed with the operating system error 2(The system cannot find the file specified.).

  The file path for the files on the SQL Server 2005 instance are:

  D:\Local\<filename>.mdf
  D:\Local_logs\<filename>.ldf

  I thought the restore job is supposed to overwrite or accept the current location of the database that I'm attempting to restore.

  Note: I'm able to restore the log backup manually and bring up the database. It's just the log shipping restore job that is failing to restore the database.

• Site Owners

  Newbie

  Points: 0

  More actions

  March 23, 2025 at 3:10 pm

  #4565933

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.