title: How to Check the Integrity of a SQL Server Backup File?
body: <p>In Microsoft SQL Server is there a way to test the integrity of a database backup file without having to restore it to see if it works? </p>
  
  <p>I've looked through the SQL Server 2014 Management Studio UI and don't see a Test option exposed there. </p>
  
  <p>I've filtered through the <a href="https://msdn.microsoft.com/en-CA/library/ms188223.aspx" rel="nofollow">Restore Options page</a> and haven't been able to pinpoint anything useful there. </p>
  
  <p>Also I've done some searching on the Internet. Maybe it's due to the generic wording of the search items but I haven't come up with anything yet except how to restore databases. </p>