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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 7: Line 7:
 
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.purge
 
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.purge
 
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.sql
 
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.sql
gfsqw_ExecXpCmdShell "dir /-C $lvsqw_BackupPathBackslash\\${lvsqw_DbName}_${lvsqw_BckDate}_?stripe*_c*.dump" > $gvsqw_TmpFile
+
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.trace
 
gfsqw_ExecXpCmdShell $gvsqw_TmpFile.purge| sed 's,  *$,,' | tee $gvsqw_TmpFile.fic
 
gfsqw_ExecXpCmdShell $gvsqw_TmpFile.purge| sed 's,  *$,,' | tee $gvsqw_TmpFile.fic
 +
gfsqw_ExecXpCmdShell $gvsqw_TmpFile.trace| sed 's,  *$,,' | tee $gvsqw_TmpFile
 
lfsqw_BackupPath =>  
 
lfsqw_BackupPath =>  
 
lfsqw_CommandFormat =>  
 
lfsqw_CommandFormat =>  

Revision as of 18:33, 5 April 2014

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

gfsqw_ConvertBackslashToSlash $lvsqw_BackupPath|read lvsqw_BackupPath
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.purge
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.sql
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.trace
gfsqw_ExecXpCmdShell $gvsqw_TmpFile.purge| sed 's,  *$,,' | tee $gvsqw_TmpFile.fic
gfsqw_ExecXpCmdShell $gvsqw_TmpFile.trace| sed 's,  *$,,' | tee $gvsqw_TmpFile
lfsqw_BackupPath => 
lfsqw_CommandFormat => 
lfsqw_InsertMonitoringBackup => 
lfsqw_PurgeHistory => 


Nuvola apps information.png
Note:
You can overload functions contained in $gvsqw_MssBin/../lib/sqwmsq_BackupDatabase.lib

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