How toSana Commerce Backup and Restore Procedures

Sana Commerce Backup and Restore Procedures

Backup Procedures

The following steps should be performed to backup the Sana Commerce solution and its data:
  • Source code backup;
  • IIS configuration backup;
  • SQL Server database backup;
  • NAV database backup (NAV Connector only).
See detailed description of these steps below.

Source code backup:
Navigate to the folder on the webserver where the web applications' source code had been installed. Create a compressed archive of this folder or simply copy this folder uncompressed and paste it to your backup location.
 
IIS configuration backup:
Very often the website configuration should be backed up, for example when the IIS is reinstalled or when the website is migrated to a new webserver. The backup process differs per different IIS version:
 
For IIS version 6.0 and older versions the configuration of the websites is stored in the IIS metabase, and there is a possibility to backup the metabase. To backup your IIS configuration, 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';
  • Click 'Create backup', choose a name for your backup file, and then click 'OK'.
The default location of the backup is the: '%SystemRoot%\system32\inetsrv\MetaBack' folder.
If you want to save your backup file to another location you can copy the file from this default location to another location.
 
Refer to the following articles on how to create the metabase backup in IIS:
http://support.microsoft.com/kb/302573
http://support.microsoft.com/kb/324277
 
For IIS version 7.0 and newer versions the website configuration is stored in the 'applicationhost.config' file, and an 'appcmd.exe' utility can be used to manage configuration backups. To backup your IIS configuration, run the following command in the command prompt:
%windir%\system32\inetsrv\appcmd.exe add backup 'SC_Backup'
 
Here, 'SC_Backup' is the name of the backup folder, which will be created in the 'C:\Windows\System32\inetsrv\backup\' directory. This folder will contain the backed up configuration files.
 
See the following article 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
 
There are several differences in the way IIS stores website configuration depending on the webserver infrastructure. If the web application is deployed to a multi-server environment and a shared configuration is used in IIS, then the backup and restore of the shared configuration files should be managed manually. Using 'appcmd.exe' utility is not sufficient in this case since it will create a backup only of the local 'redirection.config' file instead of the shared configuration file. See the following article for more details about shared configuration backup:

SQL Server database backup:
The standard backup procedure can be used to backup the Sana Commerce SQL Server database. Follow the link below for information on database backup in SQL Server 2005: 
http://msdn.microsoft.com/en-us/library/ms187510(SQL.90).aspx 

NAV database backup (NAV Connector only):
The standard backup procedure can be used to backup the NAV database. See Microsoft Dynamics NAV Classic Client Help for instructions on NAV database backup procedure. You can find this help by navigating to the 'Help > Microsoft Dynamics NAV Classic Help' submenu in the NAV Classic Client.
How toSana Commerce Backup and Restore Procedures