If a backup BAK is provided how to you go about restoring in Web Analyzer?

Here’s how

RESTORE FILELISTONLY FROM DISK
=’D:\Sites\…\***NAME HERE****.bak’

This revealed within your .bak file :
SQLDBName_Data  D:\Data\MSSQL\data\***NAME HERE****_Data.MDF

SQLDBName_Log   D:\Data\MSSQL\data\***NAME HERE****_Log.LDF

Then created all destination directories as desired to reflect intended instruction set of the next string::

RESTORE DATABASE ****NEW NAME HERE****

FROM DISK = ‘D:\Sites\***NAME HERE****_db.bak’

WITH REPLACE, MOVE ‘***NAME HERE****_Data’
TO ‘D:\Sites\databases\***NAME HERE****_Data.MDF’,

MOVE ‘***NAME HERE****_Log’
TO ‘D:\Sites\databases\data\***NAME HERE****_Log.LDF’, STATS