SQL Transaction Log shipping problem

Question

Dear all,

I'm trying to create Transaction Log Shipping on two SQL 2019 servers, the same way as I did before, however in this situation, all jobs are executed with no problem and .trn files are copied normally, except Transaction Log Shipping Status, does not show saucerful execution. Also, in the report table, in field 'Last Backup File', and 'Last copied/restored file' is missing.

Please, if anyone have any idea?

Best regards,

Aleksandar B

Answer 1

Hi Aleksandar,

Welcome to Q&A Forum; this is a great place to get support, answers, and tips.

Thank you for posting your query; I'll be more than glad to help you out.

I also got a similar problem some weeks ago... the initialization went perfect but after some regular cycle failed (and all of the following)... It was a database with several datafiles (due to partitioning - every week a new file)... the logshipping process just took the source-data-path as the path as the new destination path (that was not existing)... so I had to define the destination paths in the restore-process... after that everything worked out fine.

I hope my answer is helpful to you,

Your

Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

Answer 2

Thank you Bjoern Peters,

but I'm not sure that understand your solution.

In my case, I have 2 DBs, one of them is with several datafiles.

I'm performing backup on shared folder, which is located on the destination server. From the backup folder, I copy the files to (local on destination server) 'CopyFolder'. Restore is performed from 'CopyFolder' to another specified folder for databases.

Please, can you be more specific, about how to define the destination paths in the restore-process. Do I miss something?

Best regards,

Aleksandar