Options

COPY_ONLY

UrsusHorribilisUrsusHorribilis Posts: 22
edited November 21, 2007 10:20PM in SQL Backup Previous Versions
Is the new COPY_ONLY functionality for SQL2005 available in SQB5.2? Thanks
· Share on Twitter

Comments

  • Options
    Jason CookJason Cook Posts: 185
    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
    · Share on Twitter
  • Options
    kedwardskedwards Posts: 10
    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
    · Share on Twitter
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.