Sana Commerce Backup and Restore Procedures

Restore Procedures

The steps to take for restoring the Sana Commerce solution and its data are similar to the steps of the Backup procedure:

• Source code restore;
• IIS configuration restore;
• SQL Server database restore;
• NAV database restore (NAV Connector only).

Find more detailed description of the steps below.

Source code restore:
If you have a compressed archive of the source code folder, then uncompress it. Copy and paste the backed up source code of the Sana Commerce web applications to the folder on the webserver, where the web applications had been installed. Pay attention to the 'web.config' configuration files of the Sana Commerce Backoffice and the Starter site. You may need to merge these files instead of just copy-pasting them in case some changes have been made to the original configuration files on the webserver.

IIS configuration restore:
Procedures to restore the IIS configuration depend on the backup procedures described in the Step 2 of the Backup Procedures of current chapter and also depend on the version of IIS being used:

For IIS version 6.0 and older versions follow these steps:

• In the IIS snap-in on the local computer, click the 'Computer' icon under 'Internet Information Services';
• Click 'Action' and select 'Backup/Restore Configuration';
• In the 'Configuration Backup Name' dialog box, select a backup file and click 'Restore'. When you are asked if you want to restore your configuration settings, click 'Yes'.

If you restore the IIS configuration after IIS has been reinstalled, then the restore procedure will be different. Please, refer to the following article for details: http://support.microsoft.com/kb/302573

For IIS version 7.0 and newer versions run the following command in the command prompt in order to restore the IIS configuration:

%windir%\system32\inetsrv\appcmd.exe restore backup 'SC_Backup'

Here, 'SC_Backup' is the name of the backup folder which was specified during the backup process.
Refer to the following articles for instructions on the backup and restore using 'appcmd.exe' utility:
http://blogs.iis.net/bills/archive/2008/03/24/how-to-backup-restore-iis7-configuration.aspx

SQL Server database restore:
The standard restore procedure can be used to restore the Sana Commerce SQL Server database. Follow the link below for information on database restore in SQL Server 2005:
http://msdn.microsoft.com/en-us/library/ms177429%28SQL.90%29.aspx

NAV database restore (NAV Connector only):
The standard restore procedure can be used to restore the NAV database. See Microsoft Dynamics NAV Classic Client Help for instructions on NAV database restore procedure. You can find this help by navigating to the 'Help > Microsoft Dynamics NAV Classic Help' submenu in the NAV Classic Client.