Red Gate forums :: View topic - Copy_Only Backup
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Copy_Only Backup

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
torpenhow



Joined: 13 Aug 2012
Posts: 4

PostPosted: Thu Aug 30, 2012 12:50 pm    Post subject: Copy_Only Backup Reply with quote

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
Back to top
View user's profile Send private message
torpenhow



Joined: 13 Aug 2012
Posts: 4

PostPosted: Thu Aug 30, 2012 2:18 pm    Post subject: Upgrade Reply with quote

i have my answer I needed to upgrade.
Back to top
View user's profile Send private message
torpenhow



Joined: 13 Aug 2012
Posts: 4

PostPosted: Thu Aug 30, 2012 2:36 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Thu Aug 30, 2012 6:02 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group