COPY_ONLY

• 
  Yes, the COPY_ONLY keyword was introduced in SQL Backup 5.0, and is used in the same way as it would be in a native backup in SQL Server 2005.
  
  Jason

  Jason Cook August 30, 2007 11:05

  - 0 +
• 
  Would adding it after the existing WITH statement like below work okay?
  
  EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [Test] TO DISK = ''W:\Test\<database>\<AUTO>.sqb'' WITH COMPRESSION = 2, THREADCOUNT = 4, COPY_ONLY"'
  
  Thanks,
  Keith

  kedwards November 21, 2007 08:51

  - 0 +
• 
  Yes, that would be fine. Like SQL Server, it doesn't matter where you write the COPY_ONLY option, as long as it's after the WITH keyword.

  petey November 21, 2007 22:20

  - 0 +

Add comment

Please sign in to leave a comment.