I would like to get more information about the MS-SQL database backup and restore, we are using HP OpenView Data protector software to make backup of database, I am performing the full database backup of SAP servers on daily basis, also, performing the transaction log backup after the full database backup made.
SQL transaction log file are beyond the 35 GB, full backup of database not reducing the transaction log file, Backup of Transaction log file has been reducing the size of Transaction log file.
I have doubt about the restoring the full backup,
Do I need to restore the transaction log file after restoring the full database backup?
Does restore the full-backup will be enough