title: Restoring database on Azure SQL Data Warehouse
body: <p>What variables determine the length of time it takes to restore an Azure SQL Data Warehouse database?</p>
  
  <p>I am creating a new ADW database on a new logical server (in the same Azure region) using the Azure portal and the source specified as the backup for another ADW database (that has ~100TB of uncompressed data loaded to compressed columnar tables). </p>
  
  <p>The Azure Portal reports the status as "Deploying", but am unclear whether this will be an operation taking minutes, hours, or days.  </p>
  
  <p>Is there any way to track the progress?  </p>