Restore production record data
Users can restore a production record data for example on a new server or after a factory reset.
This does require the corresponding data model. If the data model was purged as well or it is a new server, the data model needs to be restored prior.
On how to restore a data model please follow the instructions here:
User can do this either by using applications such as:
- Microsoft SQL Server Management Studio
- MSSQL CLI
This can also be used for building custom solutions based on applications which allow for an ODBC connection such as:
- Excel
- C#
- .Net
- Python
Execute Stored Procedure PROREC_Misc_ProcessData_Read_Backup
Variable name | Datatype | Description | Example |
|---|---|---|---|
@Backupfile | NVARCHAR(100) | The complete path and filename of the production record data backup file Mandatory! Can not be NULL or Empty | Windows Example: D:\MSSQL\DATA\LE_PROREC_ProRec_Backup_Tooling_Shop_Status_2023-03-23_15-50-30.bak. Linux Example: /var/opt/mssql/data/LE_PROREC_ProRec_Backup_Tooling_Shop_Status_2023-03-23_15-50-30.bak. |
To restore production record data, call the stored procedure PROREC_Misc_ProcessData_Read_Backup using the T-SQL EXEC or EXECUTE keyword and provide the Input variables. Below is an example using T-SQL in SQL Server Management Studio:
If an output window does exist, the progress can be observed.
The stored procedure will verify that the provided values are correct and then restore the dat model configuration.
The result can be read back from the log table PROREC_Misc_Log.
Below is an example using T-SQL in SQL Server Management Studio:
With the result returned
