Installing the MaxMinManufacturingDW Database
Restore the MaxMinManufacturingDW Database Backup
- Download the MaxMinManufacturingDW backup file in the Assignment 1 section on Moodle and copy and paste the file to the following folder: C:Program FilesMicrosoft SQL ServerMSSQL14.MSSQLSVRMSSQLBackup
- Open SQL Server Management Studio.
- In the Object Explorer window, right-click the Databases folder and select Restore Database from the context menu. The Restore Database dialog box appears.
- Select the Device radio button.
- Click the ellipsis button (…) across from the From device radio button. The Select backup devices dialog box will appear.
- Select “File” from the Backup media type dropdown list, if it is not already selected.
- Click Add. The Locate Backup File dialog box will appear.
- Navigate to the folder where you pasted the MaxMinManufacturingDW backup file and select this file.
- Click OK to exit the Locate Backup File dialog box.
- Click OK to exit the Select backup devices dialog box.
- In the Backup sets to restore area, check the box in the Restore column for the MaxMinManufacturingDW – Full Database Backup entry.
- Select the Options page in the upper-left corner of the dialog box.
- Check the “Overwrite the existing database” check box.
- Click OK to restore the database.
- When the database restore is complete. Click OK to exit the restore completed message.
- Set the necessary permissions in SQL Server for the user NTSERVICEMSSQLServerOLAPService, as described from page 10 in Step 3: Grant Database Permissions in the Multidimensional Modelling tutorial. Set both db_reader and public database roles on the MaxMinManufacturingDW database.
The post MaxMinManufacturingDW Database Backup appeared first on My Assignment Online.