How do I create a new eXpress database from a corrupt eXpress database, still keeping all of my data such as jobs, computers, settings, and history?
There are a lot of situations where creating a brand new database might resolve an issue with Ghost Solution Suite 3 (hereafter GSS); most of the time the data from the previous database will still be wanted because is contains jobs, computers, settings, and history. Sometimes this data is what is causing the problem with the database, but sometimes it is not. When the database is having problems because of stored procedures, permissions set incorrectly, or other corruption other than data, the following steps can be very useful.
NOTE: This article pertains to Deployment Solution 6.9 as well, and the steps are identical except for the installer download location.
Now that the data has been successfully transferred over, restart all of your Deployment Server services and check to see if there are still errors or problems with the new database. Open the console and send sample jobs to your workstations.
If there now are problems with the new eXpress database after importing over the old data, the problem might be caused by the data in the tables. If this is the case, you might need to repeat step 2 to re-create the database, but you will not be able to import over the new data. You can try using the built-in export tool to export computers and jobs, then import them into the new database, in some cases this has cleared up corruption, but if this doesn't work then the only option left is to revert to a backup if you have one (hoping the backup doesn't have corruption as well), or to re-create all of your jobs and computer group structure.