This guide is written to show how to restore SQL Server Analysis sample database “Adventure Works DW” following my convention of SQL Server Backup File Convention. The guide divides into three steps: Restore OLTP Database Restore OLAP Database Test OLAP Restore