If a project has been accidentally deleted in Microvellum, recovery is often possible by restoring both the SQL database information and the physical project folder.
SQL Database Environments
If your environment uses SQL:
Restore a backup of the Microvellum database to a new temporary database.
Connect Microvellum to the restored backup database.
Locate the missing project.
Export the required project or projects from the restored database.
This allows the deleted project data to be recovered without affecting the live production database.
For detailed instructions on restoring a SQL database using SQL Server Management Studio (SSMS), refer to: Microsoft SSMS Database Restore Guide
After exporting the project:
Reconnect Microvellum back to the original production database.
Import the exported project or projects into the live environment.
Once imported, the project should reappear within the software.
Local Database or SQL CE Environments
If the environment uses a local database or SQL CE, recovery depends entirely on whether a backup of the MicrovellumFactory.SDF file exists.
This file can be located from within Microvellum by navigating to:
Help > Browse To Factory Data > Factory Database
Inside this folder, the MicrovellumFactory.SDF file contains the local project database information.
To recover deleted projects:
Restore a backup copy of the MicrovellumFactory.SDF file.
Replace the current database file with the backup version.
Restart the software.
If no backup of the MicrovellumFactory.SDF file exists, the deleted project data cannot be recovered from the local database.
Restore the Physical Project Folder
In addition to the database records, the actual project folder must also exist within the shared project data location.
Navigate to the project data directory and recover the deleted project folder by either:
Restoring it from the Windows Recycle Bin
Restoring it from a backup of the shared drive
Important Notes
Restoring only the SQL database without the project folder may result in incomplete or missing project data.
Likewise, restoring only the folder without the SQL records may prevent the project from appearing in Microvellum.
Exporting and importing projects via the Database Management utility is the safest method when recovering from a database backup.
SQL CE environments require a valid backup of the MicrovellumFactory.SDF file for recovery to be possible. It is recommended to always have a backup of this file before taking any actions that could compromise your Microvellum data.
Result
Once both the database records and the physical project folder have been restored, the deleted project should open and function normally within Microvellum.