Hi,
We need to mirror sql backups to a network location. My backup TSQL looks something like this:
execute master.dbo.xp_slssqlmaint N'-D "ALL DATABASES" -VrfyBackup -BkUpMedia DISK -BkUpDB "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Backup\%D\%SERVER%_%D_%T_%z.bak" -BkFileName -Logging 0 -Reliability 1 -CompressionLevel 2 -Mirror "\\backup_nas\backup_share\SQL\%D" -NOOPTOLR -Exclude Offline LogShippng IgnoreReplica Secondary ReadOnly -MultiThread 5 '
Is this supported? When I run this job the backups do not mirror to the network share.
TIA,
Thomas