Error:"ERROR 10200:The Backup name exceeds the maximum length (128 characters) imposed by SqlServ (4251205)

Log Shipping backup job fails with ERROR 10200:The Backup name exceeds the maximum length (128 characters) imposed by SqlServer.

Steps to duplicate:

1. Install LiteSpeed version 5.1.x
2. From SQL Server Management Studio(SSMS), create a database with a long filename(e.g. SharePoint_AdminContent_cde54fe4-6f69-4e49-9d5d-ad0916802486)
3. Create a log shipping plan for this database, be sure to enable logging for the plan
4. Run the backup job & it will fail
5. Go into the job history in SSMS and note the failure
6. Find the log that was generated by the backup attempt, note the failure due to the number of characters limitation in a database name

SQL Server Identifier length (in characters) limitation is 128.

WORKAROUND:

Change the database namewith fewer characters

This is a limitation of Microsoft SQL Server.