I have log shipping set up (initial set up) and the backup and copy jobs are working fine. The restores, however, are failing. The SQL Agent logs show the following for each t-log restore attempted:
Error: Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ C:\SQLLogs_LS\dbname.trn'
In the LS configuration, I set the path C:\SQLLogs_LS\, and when I run sp_help_log_shipping_secondary_database it does show that as the backup_destination_directory.
Any ideas why it is adding the default backup directory in front?