title: SQL Server localdb RESTORE runs forever?
body: <p>I'm using visual Studio 2019 community SQL Server localdb on Windows 10 Pro 202H. I've  been trying 'restore' the WideWorldImporters database from WideWorldImporters-Full.bak (downloaded from GitHub)  to my localdb instances without any success.</p>
  <p>This has happened so far:
  Qyery:  (*** = My Username)</p>
  <pre class="lang-sql prettyprint-override"><code> USE master 
   RESTORE DATABASE WideWorldImporters 
   FROM disk = 'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup\WideWorldImporters-Full.bak' 
   WITH MOVE 'WWI_Primary' TO 'C:\Users\***\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB\WideWorldImporters.mdf', 
   MOVE 'WWI_UserData' TO 'C:\Users\***\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB\WideWorldImporters_UserData.ndf', 
   MOVE 'WWI_Log' TO 'C:\Users\***\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB\WideWorldImporters.ldf', 
   MOVE 'WWI_InMemory_Data_1' TO 'C:\Users\***\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\MSSQLLocalDB\WideWorldImporters_InMemory_Data_1', 
   REPLACE
  </code></pre>
  <p>Message (pane) :</p>
  <pre class="lang-none prettyprint-override"><code>Processed 1464 pages for database 'WideWorldImporters', file 'WWI_Primary' on file 1.
  Processed 53096 pages for database 'WideWorldImporters', file 'WWI_UserData' on file 1.
  Processed 33 pages for database 'WideWorldImporters', file 'WWI_Log' on file 1.
  Processed 3862 pages for database 'WideWorldImporters', file 'WWI_InMemory_Data_1' on file 1.
  
  100% | No issues found
  Executing query... (is running on and on) 
  
  Output (General)  is empty
  
  All the stuff notified in message window can be found in desitination folder:
  WideWorldImportes_UserData.ndf                    (2 097 152 kb) 
  WideWorldImportes.mdf                             (1 048 576 kb) 
  WideWorldImportes.ldf                             (  102 400 kb) 
  
  \WideWorldImportes_InMemory_Data_1\
  filestream.hdr                                    (        1 kb) 
  
   \$FSLOG                                          (empty       ) 
  
   \$HKv2
  {1E6DC7E6-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (    2 048 kb)      
  {3E231B6B-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (       20 kb) 
  {4B9D83BE-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (    2 048 kb) 
  {6E82296C-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (   16 384 kb) 
  {6F44D507-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (    1 024 kb) 
  {07FEB052-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (       20 kb) 
  {7C4940C1-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (    1 024 kb) 
  {9A77966E-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (    4 096 kb) 
  {28CE0994-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (   16 384 kb) 
  {63F1F945-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (    2 048 kb) 
  {79B6C099-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (    4 096 kb) 
  {122A2C90-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (   16 384 kb) 
  {285FCA71-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (        4 kb) 
  {421C57F0-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (    4 096 kb) 
  {A54BA375-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (    1 024 kb) 
  {C818BEE6-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (   30 836 kb) 
  {CB6FF974-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (    1 024 kb) 
  {F6F88B52-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (    1 024 kb) 
  {F756E9B8-xxxx-xxxx-xxxx-xxxxxxxxxxxx}.hkckp      (    1 024 kb) 
  </code></pre>
  <p>Executing query... (still running, no changes in size of files for the last two hours)</p>
  <p>This is where I'm now
  <a href="https://i.stack.imgur.com/CQXrR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CQXrR.png" alt="the dialog" /></a></p>
  <p>and I'm getting mad
  <a href="https://i.stack.imgur.com/lNYiH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lNYiH.png" alt="the object browser " /></a></p>