Resetting Server Database
Before performing a server DB reset, you will want to back up all the clients' data because you will need to reset all the clients. When a client is reset, all the local content (the items data / history / users and associated files) is deleted. To back up the server:
- Stop the SQL server using Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> SQL Server Configuration Manager. Right click on all the services and stop.
- Back up the folder of the server items in <Install folder>\Application\Data\
After you have backed up any desired data, follow the procedure below for a server DB reset:
- Open the Configure Server Website at http://<servername>/KnowBook/Configuration
- Choose “Install or Upgrade Server Database”
- Enter the username and password of the SQL sysadmin and click on Next
- Keep the path of the data files as default and click on Next
- Click on ‘Install New Database’
- Click on ‘Remove Databases’ and when ‘Next’ is enabled again click in ‘Next’
- If there are no errors or warnings in the table the click on ‘Next’
- Wait for the process to end. When it's finished, the server DB is clean.
- Run the ResetClient tool (<Install folder>\Application\Components\KB.V.18.104.22.168\ResetClient.exe) on the server and on all the clients that used to connect to this server.
- On the server machine run the Content Importer (<Install folder>\Content Importer\setup.exe)