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

From Wiki_dbSQWare
Jump to navigation Jump to search
← Older editNewer edit →
Exploit (talk | contribs)
0 edits
m Updated by Expdbtools
m Updated by BatchUser
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
shell functions librairy $gvsqw_MssBin/../lib/sqwmsq_RestoreDatabase.lib:<br>
shell functions library $gvsqw_MsqBin/../lib/sqwmsq_RestoreDatabase.lib:<br>
{{SQWareProduction_sqwmsq_RestoreDatabase.lib_presentation}}
{{SQWareProduction_sqwmsq_RestoreDatabase.lib_presentation}}
<br>
<br>
Functions explanation:
Functions explanation:
<pre>
<pre>
cat $gvsqw_TmpFile.fic|grep dump|grep "${lfsqw_DatabaseSource}_[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]_[0-9][0-9][0-9][0-9][0-9][0-9]_"|awk '{print $NF}'> $gvsqw_TmpFile
gfsqw_BeginningCom
echo "exec xp_cmdshell 'dir $lvsqw_BackupPath/${lfsqw_DatabaseSource}*.dump'" >$gvsqw_TmpFile
echo "No backup of ${lfsqw_DatabaseSource} found on $lvsqw_BackupPath" |tee -a $gvsqw_TmpFile.mail
echo "No file like ${lfsqw_DatabaseSource}_$lvsqw_BckDate_*\${TYPE}*.dump\n" |tee -a $gvsqw_TmpFile.mail
echo "No file like ${lfsqw_DatabaseSource}_\$lvsqw_BckDate_*\${TYPE}*.dump\n" |tee -a $gvsqw_TmpFile.mail
echo "search file $lfsqw_FileName"
FIC=`cat $gvsqw_TmpFile|grep "${lfsqw_DatabaseSource}_[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]_[0-9][0-9][0-9][0-9][0-9][0-9]_fstripe1_" | tail -1 | sed 's/fstripe..*/fstripe/'`
FIC=`cat $gvsqw_TmpFile|grep "${lfsqw_DatabaseSource}_${lvsqw_BckDate}_fstripe1_" | tail -1 | sed 's/fstripe..*/fstripe/'`
FIC=`cat $gvsqw_TmpFile|grep $lfsqw_FileName | tail -1 | sed 's/fstripe..*/fstripe/'`
gfsqw_ConvertBackslashToSlash $lvsqw_BackupPath|read lvsqw_BackupPath
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.sql
gfsqw_EndMailError 34 "Fail to retrieve BackupDirectory !"
gfsqw_ExecSql $gvsqw_TmpFile.sql
gfsqw_ExecSql $gvsqw_TmpFile.sql
gfsqw_ExecSql $gvsqw_TmpFile.sql >$gvsqw_TmpFile
gfsqw_ExecXpCmdShell $gvsqw_TmpFile| sed 's,  *$,,' | tee $gvsqw_TmpFile.fic
gfsqw_ExecXpCmdShell $gvsqw_TmpFile > $gvsqw_TmpFile.fic
gfsqw_IsXpCmdShellEnabledGlobal "sqwmsq_RestoreDatabase.ksh $gvsqw_InputParameters"
if [ $grep -c ${lfsqw_DatabaseSource} $gvsqw_TmpFile =>  -ne 0 ]
gfsqw_XpCmdShellGlobalDisable
if [ ! -z "$lfsqw_FileName" ]
lfsqw_BackupPath =>  
lfsqw_BackupPath =>  
lfsqw_GenerateMove
lfsqw_GenerateMove =>
lfsqw_GenerateSql =>  
lfsqw_GenerateSql =>  
lfsqw_ListBck
lfsqw_ListBck =>  
lfsqw_ListBck =>  
lfsqw_RemoveWarningFromLog =>
lfsqw_RestoreDatabase =>
lfsqw_RsyncOrphans =>  
lfsqw_RsyncOrphans =>  
lvsqw_BackupPathBackslash=$gfsqw_ConvertSlashToBackslash $lvsqw_BackupPath =>  
lfsqw_Summary
lfsqw_Summary =>  
</pre>
</pre>
<br>
<br>
{{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_RestoreDatabase.lib}}
{{SQWareProductionSurchargeLib|mssql|Msq|sqwmsq_RestoreDatabase.lib}}
<br>
<br>

Revision as of 19:21, 24 January 2023

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

gfsqw_BeginningCom
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile
gfsqw_ExecSql $gvsqw_TmpFile.sql
gfsqw_ExecXpCmdShell $gvsqw_TmpFile| sed 's,  *$,,' | tee $gvsqw_TmpFile.fic
gfsqw_IsXpCmdShellEnabledGlobal "sqwmsq_RestoreDatabase.ksh $gvsqw_InputParameters"
gfsqw_XpCmdShellGlobalDisable
lfsqw_BackupPath => 
lfsqw_GenerateMove
lfsqw_GenerateMove => 
lfsqw_GenerateSql => 
lfsqw_ListBck
lfsqw_ListBck => 
lfsqw_RemoveWarningFromLog => 
lfsqw_RestoreDatabase => 
lfsqw_RsyncOrphans => 
lfsqw_Summary
lfsqw_Summary =>


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

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


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