Restore a data model configuration

6 min

use cases users can restore a data model for example on a new server or after a factory reset after a data model has been restored, it is also possible to paly back corresponding production records 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 method execute stored procedure prorec misc hierarchy read backup input variables variable name datatype description example @backupfile nvarchar(100) the complete path and filename of the hierarchy backup file mandatory! can not be null or empty windows example d \mssql\data\le prorec misc hierarchy backup urethanes 2023 03 23 14 07 47 bak linux example /var/opt/mssql/data/le prorec misc hierarchy backup urethanes 2023 03 23 14 07 47 bak how to use to restore a backup of a specific data model configuration, call the stored procedure prorec misc hierarchy 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 execute \[le productionrecord] \[dbo] \[prorec misc hierarchy read backup] @backupfile = n' /var/opt/mssql/data/le prorec misc hierarchy backup urethanes 2023 03 23 14 07 47 bak '; if an output window does exist, the progress can be observed result 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 select top (100) \[logid] ,\[logtype] ,\[logprocedure] ,\[logentry] ,\[logtime] from \[le productionrecord] \[dbo] \[prorec misc log] where \[logprocedure] = ' prorec misc hierarchy read backup ' order by logid desc; with the result returned