FAQ: Backup

When using powerKNOW a lot of valuable information is accumulated in the powerKNOW database. Therefore this database and all other components which could be changed should be backed up in regular intervals.

What to back up:

Database
One possible way to do this backup is:
1. Shut down MSDE using the Control Panel.
2. Using Windows Explorer navigate to the SQL Server Data Directory and make a backup copy of all files.
  In a default installation (using MSDE, MSDE installed by powerKNOW installer, parameters unchanged) this will be "C:\Program Files\Microsoft SQL Server\MSSQL$PKNOW\data" (Path depends on OS language as well).
3. Restart MSDE using the Control Panel.
These informations should always be backed up while powerKNOW is not accessed by users.
Please make sure the database and the fulltext index are backed up at the same time. Otherwise both can be out of sync after a potential restore.

Additional infos about backup and restore of MSDE / SQL Server 2000 databases can be found at:
http://www1.us.dell.com/content/topics/global.aspx/power/en/ps4q00_martin?c=us&cs=555&l=en&s=biz
Fulltext Index
You have to backup the index directory and all it's subdirectories and files. The path of the index directory is configured with (ConfigKey: 'idxBasePath'). In a default installation this path is
xxx\index
'xxx' represents the path of the directory where powerKNOW has been installed (default under IIS: "c:\inetpub\wwwroot\powerKNOW", default under Cassini: "C:\Program Files\powerKNOW").

These informations should be backed up while powerKNOW is not accessed by users.
Please make sure the database and the fulltext index are backed up at the same time. Otherwise both can be out of sync after a potential restore.
Configuration
Configuration information is held in the following two files:
xxx\web.config
xxx\data\Config.config
In both cases 'xxx' represents the path of the directory where powerKNOW has been installed (default under IIS: "c:\inetpub\wwwroot\powerKNOW", default under Cassini: "C:\Program Files\powerKNOW").
Style sheets
The style sheets reside in the directory
xxx\GUI
'xxx' represents the path of the directory where powerKNOW has been installed (default under IIS: "c:\inetpub\wwwroot\powerKNOW", default under Cassini: "C:\Program Files\powerKNOW").