• Hi, if the secondary log shipping database is too large and take long time to restore and create log shipping again. maybe you can try:

    1. Set the secondary to recovery mode (because on stand by mode, you cant exec alter database command)

    2. Disable all log shipping job

    3. Alter your database to modify path: "alter database

    Yourlogshippingdb modify file (name = logicalname, filename = 'newpathofyoursecondarydblocation')

    4. Stop sql server service on your secondary log shipping server

    5. Move your physical file to new location

    6. Start sql server service

    7. Enable log shipping job

    8. Verify your log shipping db

    I've done this on my prod server and it works.

    Regards