PI数据库的备份和恢复

8.0PIServer备份和恢复8.1PIServer备份PIServerDailyBackup最好每天都备份数据

PIBackup.bat备份最好转移到外部存储介质以避免硬件故障（例如硬盘损坏）..\pi\adm\pisitebackup.bat3执行PIServer备份Usethepibackup.batscriptfromthe\pi\admfoldertolaunchaPIserverbackupSyntax:pibackup.bat<destinationpath>[numberofarchives][archivecutoffdate]Example:pibackup.batE:\PI\Backup2*-60d45备份时用到的参数如果没有指定[numberofarchives]and[archivecutoffdate],backupsubsystem会使用默认值Backup_NumArchive(Default:3)Backup_ArchiveCutoffDate(Default:None)Example–backuptuningparameters（默认值）:pibackup.batE:\PI\Backup用Windows的计划任务自动备份用–install开关把pibackup.bat

脚本加入到Windows计划任务默认计划任务在每天3:15AMExample:pibackup.batE:\PI\Backup-install67备份目录的结构和内容adm:sitespecificfilespisrvsitestart.bat,pisrvsitestop.bat,pisitestart.bat,pisitebackup.bat,pintbackup.bat,pibackup_3.4.370.batarc:archiveandannotationfilesbin:pipeschd.batdat:filesfrom\PI\datexceptarchiveandannotationfileslog:filesfrom\PI\logPIbackuplogfiles指定点备份–pisitebackup.bat将备份文件转移8pibackup.batpisitebackup.bat9BackupComplete怎样知道Backup是否成功?会有一个log文件Ex.:pibackup_2-Oct-06_03.15.02.txtPIServerMessageLogs10备份的故障诊断在以下位置能够看到备份执行的一些细节：BackupScriptLogPIMessageLogNTEventLogpiartoolcommandVSSADMIN11手动备份手动备份方式：在PI-SMT中直接进行备份。使用pibackup命令进行备份。停止PI数据库，进行冷态全备份。12Exercise8PIServerBackupObjective:LearnhowtouseandconfigurethePIServerdailybackup8.2PIServer恢复14单个归档文件恢复拷贝备份档案文档在PISMTArchivesplug-in里Register档案文件恢复时版本一致。15整个PI数据库恢复重新安装一个空的PI数据库。将备份文件全部覆盖安装目录