The project-log file (SQL Server Database Transaction file) in the SQL directory of the project constantly grows and requires several GigaBytes on the harddiskDue to some reasons the SQL-Log-File of a database can reach indeed a very huge size (this behaviour belongs to default settings of the MS SQL Server).Before executing the shrink action (either with the SQL-Manager Software or via the batch file) it is recommended to create a backup of the database!!
Under very specific circumstances it can happen that the shrink action (especially doing it via the batch file) leads to a corrupt Log-File and thus the Database itself can not be read anymore.
However, it is possible to shrink this file (Note: do not delete this Log-File!! Otherwise important links can get lost and the project itself would be corrupt).
On the zenOn DVD there exists a SQL-Manager Software which can handle this issue (see Additional_Software\MSSQL_Express\ -> SQLServer2005_SSMSEE.msi)
Please follow the steps below after you have installed the software mentioned above:
- create a project-backup (just for safety)
- start the program SQL Server Management Studio Express
- connect to the SQL Server (probably SQL Server (ZENON_DEV))
- select the database (GUID) which should be shrinked (i.e. 0b1b379e-7a6d-43b6-9aa6-39cc5065c984)
- right-click at this database and select properties ("Eigenschaften")
- go to options ("Optionen") and at the recovery model ("Wiederherstellungsmodel") choose simple ("einfach") and close this dialog
- right-click at the database again, choose tasks -> shrink database -> files ("Aufgabe -> Datenbank verkleinern -> Dateien")
- select at datatype protocol (Project_Log will be automatically choosen at filename)
- after pressing OK the Log-File will be shrinked (this process needs about 2-3 seconds -> depends on the size)