I am trying to restore a database to a server from a SQL backup. The .ldf file is about 160 gb and database is about 3 gb. I am unable to truncate the logs, etc online as it says it does not have enough free space when restoring it. Is there a way to truncate the log from the backup or somehow get it restored to a new SQL server? Also, the size of drive I am restoring to has 900 GB free.