After implementing Log Shipping plan, the restore job fails with the following.
Executed as user: SERVERNAME\SQLExec. SLS_LogShipping_Restore_Name
failed. msg:source and target database have different logical filenames
restore aborted! [SQLSTATE 42000] (Error 50000). The step failed.
The name of the target database had been renamed without renaming the logical files names.
A target database is required on the Subscriber to restore the backup file and transaction logs scheduled with a log shipping plan.
For additional information on creating a new database:
http://msdn2.microsoft.com/en-us/library/ms176061.aspx
