I have an Azure VM with SQL Server 2014, with a local drive (X:) for storing backups. Using Ola Hallengren's scripts. I added an Azure Files share and tried to do a mirror backup, but I get the following error:
BACKUP DATABASE [Test] TO DISK = N'X:\Backup\SRVSQL01\Test\FULL\SRVSQL01_Test_FULL_20150420_185840.bak' MIRROR TO DISK = N'\\storage.file.core.windows.net\backup\SRVSQL01\Test\FULL\SRVSQL01_Test_FULL_20150420_185840.bak' WITH NO_CHECKSUM, COMPRESSION, FORMAT Msg 3212, Level 16, State 0, Line 3 The mirror device "X:\Backup\SRVSQL01\Test\FULL\SRVSQL01_Test_FULL_20150420_185840.bak" and the mirror device "\\storage.file.core.windows.net\backup\SRVSQL01\Test\FULL\SRVSQL01_Test_FULL_20150420_185840.bak" have different device specifications. Msg 3013, Level 16, State 1, Line 3 BACKUP DATABASE is terminating abnormally. Outcome: Failed
Initially, the local drive was formatted with 64K allocation unit size. Tried switching to 4K, and using the
BlockSize switch, but no luck. Any ideas?