After a full database and transaction log backup is completed, the backup files is restored and set to 'Loading'; the Restore fails with an unknown error.
Error received when attaching the restored files manually to SQL Server:
"error 9004 processing the log"
If a full db backup from your Database is frequently scheduled into the same folder with the same name, delete the old backup file to prevent the error. Using the LiteSpeed xp_slssqlmaint without specifing a destination file name allows the job to name the backup file with a unique datestamp/timestamp format.
