I need to create one off backups seperately from the normal backups to restore in our UAT environment when I add the COPY_ONLY command I get an error SQL error 155: 'COPY_ONLY' is not a recognized BACKUP option.
This is the full command that I am trying to use:-
EXECUTE master..sqlbackup '-SQL "BACKUP USER DATABASES TO DISK = ''\\\\172.17.20.49\\SQLBackup\\<DATABASE>.sqb''
WITH COPY_ONLY, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, THREADCOUNT = 3, VERIFY"'
I don't want to break my normal production backup chain.
This is unfortunatley a SQL2000 server version 18.104.22.1689. I am using SQl Backup Version 22.214.171.124 should I be using 7.1?