title: RESTORE is not restoring database in its original state
body: <p>I'm working on a backup file (~9Gb, can't modify) under SQL Server 2012, and frequently have to restore my base to its original state, but I've noticed the .ldf log file is getting really huge (&gt;20Gb today) whereas the first time it was aroung 1Gb.</p>
  <p>I've tried to shrink log file and limit log file size, but still restoring at 20Gb the next time, I've deleted database and cleared msdb restore history and still restoring a huge .ldf file....</p>
  <p>I'm using the code:</p>
  <blockquote>
  <p>USE [master]</p>
  <p>RESTORE DATABASE [MYBASE] FROM  DISK = N'D:\SQLServer\BACKUP\MYBACKUP.bak' WITH  FILE = 1,</p>
  <p>MOVE N'MYBACKUP' TO N'D:\SQLServer\DATA\MYBASE.mdf',</p>
  <p>MOVE N'MYBACKUP' TO N'D:\SQLServer\LOG\MYBASE.ldf',</p>
  <p>NOUNLOAD,  REPLACE,  STATS = 5</p>
  <p>GO</p>
  </blockquote>
  <p>Any ideas ?</p>
  <p>Is there something wrong on my code ?</p>