Copy_Only like option for SQL Server 2000

  • Does anyone know if there is an option in 2000 like the Copy_Only in 2005? 

    Copy_Only option from BOL:

    Taking a backup normally changes the database, in turn affecting other backups and how they are restored. Sometimes, however, a backup must be taken for a special purpose that should not affect the overall backup and restore procedures for the database.

    A data backup is normally a base backup for one or more differential backups taken after it. Microsoft SQL Server 2005 introduces support for creating copy-only backups, which do not affect the normal sequence of backups. Therefore, unlike other backups, a copy-only backup does not impact the overall backup and restore procedures for the database.

    You can create a copy-only backup for any type of backup:

    • Copy-only data backups (all recovery models)

      To create a copy-only data or differential backup, use the COPY_ONLY option in your BACKUP DATABASE statement. A data backup taken with the COPY_ONLY option cannot be used as a base backup and does not affect any existing differential backups.

    • Copy-only differential backups

      These are identical to regular differential backups.

    • Copy-only log backups

      To create a copy-only log backup, use the COPY_ONLY option in your BACKUP LOG statement; doing so causes backup to retain the current log archive point. Also, the transaction log is not truncated by a log backup taken using the COPY_ONLY option. Without COPY_ONLY, a BACKUP LOG WITH NORECOVERY would advance the log archive point.

  • No, Copy-only is a new feature in SQL 2005.  I think the closest you'd get in SQL 2000 would be to use BCP or DTS to export data. 

    Greg

    Greg

  • Thanks for the reply Greg.  That is what I figured, but I wanted to make sure.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply