Restore tag data from automated backup

use cases users can restore tag data which have been backup by the automated backup system for example on a new server or after a factory reset this does require the corresponding tag definition if the tag definition was purged as well or it is a new server, the tag definition needs to be restored prior on how to restore a data model please follow the instructions here restore a tag definition docid 6 fjxhnymrxndbcxka6yk the automated backup system only takes a backup and purges tag data and not meta data, as the purpose is to enforce a user defined retention period as meta data might be stale, they are not automatically purged 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 tagdata read backup input variables variable name datatype description example @backupfile nvarchar(100) the complete path and filename of the tag and meta data backup file mandatory! can not be null or empty windows example d \mssql\data\ le prorec tag backup nov 2 2022 3 24am mar 23 2023 4 42pm 2023 03 23 17 42 56 bak linux example /var/opt/mssql/data/ le prorec tag backup nov 2 2022 3 24am mar 23 2023 4 42pm 2023 03 23 17 42 56 bak how to use to restore a backup of tag data, call the stored procedure prorec misc tagdata 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 tagdata read backup ] @backupfile = n' d \mssql\data\le prorec tag backup nov 2 2022 3 24am mar 23 2023 4 42pm 2023 03 23 17 42 56 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 tag definition 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 tagdata read backup ' order by logid desc; with the result returned