Technical ManualsSana Backup and Restore

Sana Backup and Restore

Sana Commerce 9.2
Your connector

Sana Commerce Backup

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);
  • Sana Commerce project export (AX 2009 and earlier);
  • Export the Sana Model (AX 2012);
  • Data export (AX 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:

Step 1: In the IIS snap-in on the local computer, click the 'Computer' icon under 'Internet Information Services'.

Step 2: Click 'Action' and select 'Backup/Restore Configuration'.

Step 3: Click 'Create backup', choose a name for your backup file, and then click 'OK'.

 NOTE

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
 
 NOTE

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.


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.

Sana Commerce project export (AX 2009 and earlier)

Step 1: Open the 'Projects' window (Ctrl+Shift+P) and select the 'Shared' folder.

Step 2: Right-click on the Sana Commerce project and select 'Export'.

Export the Sana Model (AX 2012)

The standard export model procedure is used to export the Sana model from Microsoft Dynamics AX.
See 'How to: Export and Import a Model Store [AX 2012]' in the Microsoft TechNet Library.

Data export (AX Connector only)

The standard data export procedure can be used to export  AX data. See Microsoft Dynamics AX Help for instructions on AX data export procedure. You can find this help by navigating to the 'Microsoft Dynamics AX > Help' menu in the AX client.
Technical ManualsSana Backup and Restore