SQWareProduction:mssql:lib:sqwmsq BackupDatabase.lib: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
m Updated by BatchUser
m Updated by BatchUser
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
shell functions library $gvsqw_MssBin/../lib/sqwmsq_BackupDatabase.lib:<br>
shell functions library $gvsqw_MsqBin/../lib/sqwmsq_BackupDatabase.lib:<br>
{{SQWareProduction_sqwmsq_BackupDatabase.lib_presentation}}
{{SQWareProduction_sqwmsq_BackupDatabase.lib_presentation}}
<br>
<br>
Functions explanation:
Functions explanation:
<pre>
<pre>
gfsqw_ConvertBackslashToSlash $lvsqw_BackupPath|read lvsqw_BackupPath
gfsqw_BeginningCom
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.sql
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.purge
gfsqw_ExecXpCmdShell "dir /-C $lvsqw_BackupPathBackslash\\${lvsqw_DbName}_${lvsqw_BckDate}_?stripe*_c*.dump" > $gvsqw_TmpFile
gfsqw_ExecSql $gvsqw_TmpFile.sql >$gvsqw_TmpFile
gfsqw_ExecXpCmdShell "dir $lvsqw_BackupPathBackslash\\${lvsqw_DbName}*.dump" > $gvsqw_TmpFile.fic
gfsqw_ExecXpCmdShell $gvsqw_TmpFile.purge| sed 's,  *$,,' | tee $gvsqw_TmpFile.fic
lfsqw_BackupDatabase =>
lfsqw_BackupPath =>  
lfsqw_BackupPath =>  
lfsqw_CheckIfFullExists =>
lfsqw_CommandFormat
lfsqw_CommandFormat =>  
lfsqw_CommandFormat =>  
lfsqw_InsertMonitoringBackup =>  
lfsqw_InsertMonitoringBackup =>  
lfsqw_PurgeDiff =>
lfsqw_PurgeDiffLinux =>
lfsqw_PurgeHistory =>  
lfsqw_PurgeHistory =>  
lfsqw_PurgeHistoryLinux =>
</pre>
</pre>
<br>
<br>
{{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_BackupDatabase.lib}}
{{SQWareProductionSurchargeLib|mssql|Msq|sqwmsq_BackupDatabase.lib}}
<br>
<br>

Latest revision as of 09:32, 24 December 2024

shell functions library $gvsqw_MsqBin/../lib/sqwmsq_BackupDatabase.lib:
lib for sqwmsq_BackupDatabase.ksh
Functions explanation:

gfsqw_BeginningCom
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.purge
gfsqw_ExecSql $gvsqw_TmpFile.sql >$gvsqw_TmpFile
gfsqw_ExecXpCmdShell $gvsqw_TmpFile.purge| sed 's,  *$,,' | tee $gvsqw_TmpFile.fic
lfsqw_BackupDatabase => 
lfsqw_BackupPath => 
lfsqw_CheckIfFullExists => 
lfsqw_CommandFormat
lfsqw_CommandFormat => 
lfsqw_InsertMonitoringBackup => 
lfsqw_PurgeDiff => 
lfsqw_PurgeDiffLinux => 
lfsqw_PurgeHistory => 
lfsqw_PurgeHistoryLinux => 


Note:
You can overload functions contained in $gvsqw_MsqBin/../lib/sqwmsq_BackupDatabase.lib

by function with same name in $gvsqw_MsqBin/../lib_cust/sqwmsq_BackupDatabase.lib for all your environnement
or by $HOME/sqwConfig/sqwmsq_BackupDatabase.lib specifically for this user .