I need to restore a SQL Server database with/without the log file. This is for a reporting system. When I restore the log file it is sometimes 8x larger than the data file. I am restoring this once a week for a reporting system that will not need to be restored (if it fails I will restore it from the OLTP system).
Is there any reason I should just restore it without the log and keep the recovery model simple so the log file does not grow too much?
On the source the log file is not being backed up. A different group is managing that system.