May 10, 2007 at 4:17 pm
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.
May 10, 2007 at 5:03 pm
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
May 11, 2007 at 7:51 am
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