Find historical data in multiple Database backups
The article was successfully sent to the email
One recommended solution is to restore the backups one by one from the beginning and generate reports via the TRBOnet console after each restoration procedure.
Another solution is to merge all the backup Databases to one Database then search this one Database.
Note that since you are merging multiple Databases, the size of the final Database could be larger than 10 GB and SQL Express is unable to handle such a large Database. You may need to install a commercial version of the SQL Server.
Another solution is to merge all the backup Databases to one Database then search this one Database.
Note!
Neocom Software is not responsible for any data losses that may occur if the below actions are applied to the original Database backups or on the TRBOnet Server PC.
We highly recommend to use the below method on a separate PC and with copies of the Database backups.
Neocom Software is not responsible for any data losses that may occur if the below actions are applied to the original Database backups or on the TRBOnet Server PC.
We highly recommend to use the below method on a separate PC and with copies of the Database backups.
-
1. Install the same version of TRBOnet that is currently installed on the original PC (server and console) to another PC which will be used for Data restoration.
2. Install the same version of the SQL Server that is currently installed on the original PC with SQL Server Management Studio (SSMS) to another PC which will be used for Data restoration.
3. Copy all backups from the server PC to the PC which will be used for Data restoration.
4. Create a new Database in SSMS on the PC which will be used for Data restoration.
5. Restore all backups to the newly created Database.
You may search for guides how to perform step 5; an example is below (use variant #2):
Note that since you are merging multiple Databases, the size of the final Database could be larger than 10 GB and SQL Express is unable to handle such a large Database. You may need to install a commercial version of the SQL Server.
-
6. After the Database restoration, in the TRBOnet server, verify that the Database is available for connection then start the service with saving changes.
7. Run the TRBOnet console and use TRBOnet reports to get the required information.