title: SQL-Server: What does NOUNLOAD and STATS mean in sql command line when restoring a DB?
body: <p>When i go to restore my database in SQL server 2012 i can let display the script or command line action as you know. What do these additional parameters do, <code>Nounload and stats = 10.</code></p>
  
  <pre><code>RESTORE DATABASE [db2] FROM  DISK = N'C:\folder\db2.bak' WITH  FILE = 1,  NOUNLOAD,  STATS = 10
  GO
  </code></pre>