Restored database with focus on log size
My question is the restoring of the database and the associated log. Sometimes the logs are larger than the database and sometimes the logs are small. How can you minimze the size of the restored log?
Before the backup, should I truncate the log and then RedGate backup and now the restored log will be as small as possible. After restored, now start transactional backing up of log.
Or After backup and restore, truncate the log and then start hourly backing up of the log.