BACKUP DATABASE db_name TO disk='C:\db_name.bkp' WITH COPY_ONLY
This option COPY_ONLY, can be performed for any backup type. COPY_ONLY has certains behaviors depending of the backup type:
* A log backup taken using copy_only, does not truncate the transaction log.
* A data backup taken using copy_only cannot be used as base backup for differential or incremental backups.
* A differential backup has not effect with copy_only option.
EmoticonEmoticon