Msg 110405, Level 16, State 1, Line 1 LiteSpeed for SQL Server could not open backup file: (). (4250141)

Microsoft limitation:

“Database name” is limited to 128 (SQL limitation) and is the databases’ name.

DETAILS:   http://msdn.microsoft.com/en-us/library/ms176061.aspx

“Filename” is limited to 260 (the “max_path” of the windows OS) and is the path and name of the database MDF or NDF files.

DETAILS:   

http://msdn.microsoft.com/en-us/library/windows/desktop/aa365247%28v=vs.85%29.aspx

http://windows.microsoft.com/en-us/windows/file-names-extensions-faq#1TC=windows-7

Workaround:

Change the path to lower it to the 260 max character limit or manually change the filename to be lower than the max character limit.

EXAMPLE:

exec master.dbo.xp_restore_headeronly @filename = N'\\127.0.0.1\backups\somefile.bak