debugsqlMinor
Backup to local and MIRROR TO Azure Files returns ERROR
Viewed 0 times
localerrormirrorazurefilesreturnsandbackup
Problem
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:
Initially, the local drive was formatted with 64K allocation unit size. Tried switching to 4K, and using the
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: FailedInitially, the local drive was formatted with 64K allocation unit size. Tried switching to 4K, and using the
BlockSize switch, but no luck. Any ideas?Solution
I can't see that you are using backup to URL. It looks like a local drive and a file share.
If you read about mirrored backups you see that there are some special requirements:
"Mirroring applies both to disk and tape (disks do not support continuation tapes). All backup devices for a single backup or restore operation must be of the same type, disk or tape."
"Within these broader classes, you must use similar devices that have the same properties. Insufficiently similar devices generate an error message (3212). To avoid the risk of a device mismatch, use devices that are equivalent, such as, only drives with the same model number from the same manufacturer."
https://msdn.microsoft.com/en-us/library/ms175053.aspx
If you read about mirrored backups you see that there are some special requirements:
"Mirroring applies both to disk and tape (disks do not support continuation tapes). All backup devices for a single backup or restore operation must be of the same type, disk or tape."
"Within these broader classes, you must use similar devices that have the same properties. Insufficiently similar devices generate an error message (3212). To avoid the risk of a device mismatch, use devices that are equivalent, such as, only drives with the same model number from the same manufacturer."
https://msdn.microsoft.com/en-us/library/ms175053.aspx
Context
StackExchange Database Administrators Q#98343, answer score: 3
Revisions (0)
No revisions yet.