Falta parametrizarlo e implementar copia de lista de archivos tomada desde SQL SERVER.
cd C:\Users\Public\Documents c: date /T >> loffcopy.log time /T >> loffcopy.log vssadmin list shadows >> loffcopy.log echo ---------------------------- >> loffcopy.log sqlcmd -C -b -d master -E -S LOCALSERVER -i alterdatabaseoffline.sql -W -o loffcopytemp.log type loffcopytemp.log >> loffcopy.log echo ---------------------------- >> loffcopy.log vssadmin create shadow /for=F: >loffcopytemp.log SET ShadowPathF= REM Pull the latest shadow copy from the listing. FOR /F "usebackq tokens=1,2* delims=:" %%A IN (`FINDSTR /I /C:"Shadow Copy ID:" loffcopytemp.log`) DO SET ShadowPathF=%%B type loffcopytemp.log >> loffcopy.log mount_latest_snapshot F:\SHADOWCOPY F:\ >>loffcopy.log vssadmin create shadow /for=G: >loffcopytemp.log SET ShadowPathG= REM Pull the latest shadow copy from the listing. FOR /F "usebackq tokens=1,2* delims=:" %%A IN (`FINDSTR /I /C:"Shadow Copy ID:" loffcopytemp.log`) DO SET ShadowPathG=%%B type loffcopytemp.log >> loffcopy.log mount_latest_snapshot G:\SHADOWCOPY G:\ >>loffcopy.log echo ---------------------------- >> loffcopy.log sqlcmd -C -b -d master -E -S LOCALSERVER -i alterdatabaseonline.sql -W -o loffcopytemp.log type loffcopytemp.log >> loffcopy.log xcopy f:\SHADOWCOPY\Default\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\DATABASE*.* \\REMOTESERVER\Transfer\ @if not errorlevel 1 goto script_ok @echo "! Backup en remoto fallido, it returned %errorlevel% !" >> loffcopy.log echo ---------------------------- >> loffcopy.log date /T >> loffcopy.log time /T >> loffcopy.log return 1 xcopy G:\SHADOWCOPY\Default\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DATABASE.* \\REMOTESERVER\Transfer\ type loffcopytemp.log >> loffcopy.log echo ---------------------------- >> loffcopy.log date /T >> loffcopy.log time /T >> loffcopy.log echo ---------------------------- >> loffcopy.log vssadmin delete shadows /Shadow=%ShadowPathG% /Quiet >> loffcopy.log vssadmin delete shadows /Shadow=%ShadowPathF% /Quiet >> loffcopy.log vssadmin list shadows :script_ok sqlcmd -C -b -d master -E -S REMOTESERVER -i local_restore.sql -W -o loffcopytemp.log type loffcopytemp.log >> loffcopy.log echo ---------------------------- >> loffcopy.log date /T >> loffcopy.log time /T >> loffcopy.log
Filed under: Sin categoría | Leave a comment »