Automate Backup of SQL Server Database Structure
Since you are using SQL Server 20141 you could look at using DBCC CLONEDATABASE to create a statistics-only copy of the warehouse database.

See support.microsoft.com for details on the command; however it essentially boils down to:

DBCC CLONEDATABASE (warehouse1, warehouse2);


From the page linked above:


  All files in the target database will inherit the size and growth settings from the model database. File name convention: The file names for the destination database will follow the source_file_name _underscore_random number convention. If the generated file name already exists in the destination folder, DBCC CLONEDATABASE will fail.


You could wrap this in code that drops the current clone, if one exists, then creates the new clone.  This could be added to a SQL Server Agent Job that executes nightly, or weekly, as required.



1 - you'll need service pack 2 or above for SQL Server 2014