During the backup process, you can get different error messages, it doesn’t matter how you make SQL Server database backups. You can backup your database using T-SQL Commands, SSMS or SQLBackupAndFTP. Assume during the backup process, you receive the following error message:
DETAILED LOG: 10/10/2016 10:13:43 Creating backup of Adventureworks to D:TempPranas.NETSQLBackupAndFTPAdventureworks (full) 10/10/2016 10:13:43 ERROR: This BACKUP or RESTORE command is not supported on a database mirror or secondary replica. BACKUP DATABASE is terminating abnormally.
This BACKUP or RESTORE command is not supported on a database mirror or secondary replica – Solution
The solution of this issue is very simple. All you need to do is to make your SQL Server database backups with COPY_ONLY option. With the help of SQLBackupAndFTP, you can simply create backup according to your schedule with COPY_ONLY option. To enable COPY_ONLY option pass these simple steps:
- Scroll down and click “More settings…”
- Find “Backup options” section and check off “Copy Only”.
All new settings will be saved automatically.