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

From Wiki_dbSQWare
Jump to navigation Jump to search
Newer edit →
Exploit (talk | contribs)
0 edits
m Updated by Expdbtools
 
Exploit (talk | contribs)
0 edits
m Updated by Expdbtools
Line 1: Line 1:
Librairie de fonctions shell $gvsqw_MssBin/../lib/sqwmsq_BackupDatabase.lib:<br>
shell functions librairy $gvsqw_MssBin/../lib/sqwmsq_BackupDatabase.lib:<br>
lib for sqwmsq_BackupDatabase.ksh
{{SQWareProduction_sqwmsq_BackupDatabase.lib_presentation}}
<br>
<br>
gfsqw_ExecSql ${gvsqw_TmpFile}_$lvsqw_DbName.sql |tee $gvsqw_TmpFile
Functions explanation:
gfsqw_ExecSql $gvsqw_TmpFile.purge > $gvsqw_TmpFile.fic
<pre>
lfsqw_CommandFormat
gfsqw_ConvertBackslashToSlash $lvsqw_BackupPath|read lvsqw_BackupPath
lfsqw_GetShared
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 00:26, 16 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 =>


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 .


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:mssql:lib:sqwmsq_BackupDatabase.lib&oldid=1063"