The xp_restore_automated parameter @sourcedatabase is case sensitive (4242402)

The xp_restore_automated parameter @sourcedatabase is case sensitive

When running the xp_restore_automated command, the parameter @sourcedatabase is case sensitive. This was not case sensitive in previous versions of litespeed.

When you modify the @sourcedatabase parameter to be same case as the database was when it was backed up it works fine. In Litespeed 7.5.1 the upper or lowercase characters didn't matter.

An example command:

EXEC master.dbo.xp_restore_automated  @database = N'DATABASENAME' ,
@backuppath =  N'\\backuplocation\'
, @backupextension = 'bak'
, @checksubfolders = 1
, @encryptionkey = N'xxxxxxxxxxxxxxxx'
, @sourceserver = N'Server1'
, @sourcedatabase = N'DATABASENAME'
, @backuptype = N'full'
, @dryrun = 1

This gives the following error in Litespeed v8.0.1:

=========
LiteSpeed™ for SQL Server® Version 8.0.1.1043 (64bit)
© 2014 Dell Inc.

Msg -2147417259, Level 16, State 1, Line 0
Specified backup files are not found.
=========

Changed by design in Litespeed v8.0

This is a change that was made by design in Litespeed.

The parameter was made case sensitive because it was causing a problem when backups were made on a case sensitive server.

If you make a backup on a case sensitive server of databases i.e. “Database” & “database” and restore it on a different server, automated restore will interpret backups of those databases as backups from one database in case of “case insensitive”.