nopCommerce Database Restore

17 Dec 2013

Restoring an nopCommerce database from backup

1. Download last Full and last Differential backup from S3

   Using Microsoft SQL Server Management Studio

2. Using Databases / nopCommerce*** - Tasks / Restore / Databases
   Restore Full backup setting Recovery state to RESTORE WITH NORECOVERY
   Restore Differential backup setting Recover state to RESTORE WITH RECOVERY
   If there is no Differential backup the Full backup should be restored setting Recover state to RESTORE WITH RECOVERY

3. Using Databases / nopCommerce* / Security / Users / default* - Delete
   Delete the default*** user in the restored database.

4. Using Security / Logins / default* - Properties | User Mapping
   Map the server login default* to the default* user in the nopCommerce* database

5. Using Databases / nopCommerce* / Security / Users / default* - Properties | General
   Enable the following Role Members - db_datareader, db_datawriter, db_owner, db_securityadmin