SQL BAK restore
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.MDFSQLDBName_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
- - - - - S P O N S O R I N G A D V E R T I S M E N T - - - - -