Difference between revisions of "SQWareProduction:mssql:lib:sqwmsq BackupDatabase.lib"
m (Updated by Expdbtools) |
m (Updated by Expdbtools) |
||
| Line 1: | Line 1: | ||
| − | + | shell functions librairy $gvsqw_MssBin/../lib/sqwmsq_BackupDatabase.lib:<br> | |
| − | + | {{SQWareProduction_sqwmsq_BackupDatabase.lib_presentation}} | |
<br> | <br> | ||
| − | gfsqw_ExecSql ${gvsqw_TmpFile}_$lvsqw_DbName.sql |tee $gvsqw_TmpFile | + | Functions explanation: |
| − | + | <pre> | |
| − | lfsqw_CommandFormat | + | gfsqw_ConvertBackslashToSlash $lvsqw_BackupPath|read lvsqw_BackupPath |
| − | + | gfsqw_ConvertSlashToBackslash ${gvsqw_TmpFile}_$lvsqw_DbName.sql | |
| − | lfsqw_PurgeHistory | + | gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.sql |
| + | gfsqw_EndMailError 34 "Fail to retrieve BackupDirectory !" | ||
| + | gfsqw_ExecSql $gvsqw_TmpFile.sql >$gvsqw_TmpFile | ||
| + | gfsqw_ExecXpCmdShell "dir /-C $lvsqw_BackupPathBackslash\\${lvsqw_DbName}_${lvsqw_BckDate}_?stripe*_c*.dump" > $gvsqw_TmpFile | ||
| + | gfsqw_ExecXpCmdShell "dir $lvsqw_BackupPathBackslash\\${lvsqw_DbName}*.dump" > $gvsqw_TmpFile.fic | ||
| + | gfsqw_ExecXpCmdShell ${gvsqw_TmpFile}_$lvsqw_DbName.sql |tee $gvsqw_TmpFile | ||
| + | gfsqw_FormatHtmlMessages $gvsqw_TmpFile >> $gvsqw_TmpFile.mail | ||
| + | lfsqw_BackupPath => | ||
| + | lfsqw_CommandFormat => | ||
| + | lfsqw_InsertMonitoringBackup => | ||
| + | lfsqw_PurgeHistory => | ||
| + | lvsqw_BackupPathBackslash=$gfsqw_ConvertSlashToBackslash $lvsqw_BackupPath => | ||
| + | </pre> | ||
<br> | <br> | ||
{{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_BackupDatabase.lib}} | {{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_BackupDatabase.lib}} | ||
<br> | <br> | ||
Revision as of 23:26, 15 December 2010
shell functions librairy $gvsqw_MssBin/../lib/sqwmsq_BackupDatabase.lib:
lib for sqwmsq_BackupDatabase.ksh
Functions explanation:
gfsqw_ConvertBackslashToSlash $lvsqw_BackupPath|read lvsqw_BackupPath
gfsqw_ConvertSlashToBackslash ${gvsqw_TmpFile}_$lvsqw_DbName.sql
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.sql
gfsqw_EndMailError 34 "Fail to retrieve BackupDirectory !"
gfsqw_ExecSql $gvsqw_TmpFile.sql >$gvsqw_TmpFile
gfsqw_ExecXpCmdShell "dir /-C $lvsqw_BackupPathBackslash\\${lvsqw_DbName}_${lvsqw_BckDate}_?stripe*_c*.dump" > $gvsqw_TmpFile
gfsqw_ExecXpCmdShell "dir $lvsqw_BackupPathBackslash\\${lvsqw_DbName}*.dump" > $gvsqw_TmpFile.fic
gfsqw_ExecXpCmdShell ${gvsqw_TmpFile}_$lvsqw_DbName.sql |tee $gvsqw_TmpFile
gfsqw_FormatHtmlMessages $gvsqw_TmpFile >> $gvsqw_TmpFile.mail
lfsqw_BackupPath =>
lfsqw_CommandFormat =>
lfsqw_InsertMonitoringBackup =>
lfsqw_PurgeHistory =>
lvsqw_BackupPathBackslash=$gfsqw_ConvertSlashToBackslash $lvsqw_BackupPath =>
