Copy_Only Backup

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Copy_Only Backup

Postby torpenhow » Thu Aug 30, 2012 12:50 pm

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 8.0.0.2039. I am using SQl Backup Version 6.5.1.9 should I be using 7.1?

Regards
Carolyn
torpenhow
 
Posts: 4
Joined: Mon Aug 13, 2012 11:36 am

Upgrade

Postby torpenhow » Thu Aug 30, 2012 2:18 pm

i have my answer I needed to upgrade.
torpenhow
 
Posts: 4
Joined: Mon Aug 13, 2012 11:36 am

Postby torpenhow » Thu Aug 30, 2012 2:36 pm

Although it now seemed to accept the command it's still failing with more messages:-

VDI error 1010 Failed to get the configuration file from the server because the timeout interval as elasped .....increase the valuse of the VDITimeout registry setting. note This name does not exist in the registry.

then I get the further message again
SQL error 155: 'COPY_ONLY' is not a recognized BACKUP option.

Regards
Carolyn
torpenhow
 
Posts: 4
Joined: Mon Aug 13, 2012 11:36 am

Postby petey » Thu Aug 30, 2012 6:02 pm

The COPY_ONLY option can only be used on a SQL Server 2005 instance or newer.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests