March 22, 2025 at 2:16 pm
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.
March 23, 2025 at 3:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply