The encryption password is visible if the backup is to be run manually (one-time), the password is no longer visible in a scheduled job (either in LiteSpeed Enterprise Console or the Job Step in SQL Server Enterprise Manager | Management | Jobs | Job Step)
STATUS:
This issue was fixed in LiteSpeed 4.6. The latest version of LiteSpeed can be downloaded at http://support.quest.com/support_download/Downloads.asp.
In 4.6 Encryption key/password is no longer visible in a scheduled job (either in LiteSpeed Enterprise Console or the Job Step in SQL Server Enterprise Manager | Management | Jobs | Job Step)
Example of manual backup in 4.5x and 4.6x:
exec master.dbo.xp_backup_database @database = 'Pubs', @filename = 'D:\Backup\Pubs200606250942LiteSpeed_Full.BKP', @backupname = 'Pubs backup', @desc = 'Backup of Pubs on 2006-06-25 09:42:15', @encryptionkey = 'password', @cryptlevel = 6, @logging = 0, @comment = '', @with = 'SKIP', @with = 'STATS = 10'
Example of scheduled backup in 4.6x:
exec master.dbo.xp_backup_database @database = 'Pubs', @filename = 'D:\Backup\Pubs200606250942LiteSpeed_Full.BKP', @backupname = 'Pubs backup', @desc = 'Backup of Pubs on 2006-06-25 09:42:15', @job = '', @cryptlevel = 6, @logging = 0, @comment = '', @with = 'SKIP', @with = 'STATS = 10'.
