Comments on: Percona XtraBackup for Windows https://www.percona.com/blog/percona-xtrabackup-for-windows/ Thu, 11 Nov 2021 21:06:58 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: MikeG https://www.percona.com/blog/percona-xtrabackup-for-windows/#comment-10973396 Thu, 11 Nov 2021 21:06:58 +0000 https://www.percona.com/blog/?p=76919#comment-10973396 This is pretty cool.

You can also try shadow copy. Here are my rough notes from when I did this last time:

## FTWRL + SHOW MASTER STATUS

vssadmin create shadow /for=D:

## Unlock tables

mklink /D v:shadowmountD \\?\GLOBALROOT\Device\HarddiskVolumeShadowCopy8\

## ^ from “create shadow” but need trailing \

robocopy V:shadowmountD\MySQLData\ F:Backup\dataD\ /XF *.data /MIR /E /J /MT:16 /COPY:DATO /DCOPY:T /W:5 /V /LOG:F:RobocopyLogs\dataD.log

### use start(1) ?

rmdir v:\shadowmountD

vssadmin list shadowstorage

## remove shadow with gui instead of “delete shadows”

### Copy to DR:

robocopy F:Backup\dataD\ Z:\qa /XF *.data /MIR /E /J /MT:16 /COPY:DATO /DCOPY:T /W:5 /V /LOG:F:RobocopyLogs\dataD_to_DR.log

]]>