Meaning of copyonly option when backs up the database

When you back up a database in SQLSERVER, The copyonly option means to copy only the backup WITHcopy_only, which usually changes the database, which affects other backup and restoration methods. However, for special purposes, you must perform backups that do not affect the overall backup and restoration process of the database. Full backup is generally used in

When you back up a database in SQLSERVER, the copy only option means that copying a backup WITH copy_only usually changes the database, which affects other backup and restoration methods. However, for special purposes, you must perform backups that do not affect the overall backup and restoration process of the database. Full backup is generally used in

Meaning of the copy only option when backing up a database in SQLSERVER

Copy backup only WITH copy_only

The database is usually changed during backup, which affects other backup and restoration methods. However, server space, sometimes for special purposes,

You must perform a backup that does not affect the overall backup and restoration process of the database.

A full backup is generally used as a reference backup for one or more differential backups after it. SQL2005 supports creating backup copies only and Hong Kong servers, which does not affect the normal backup sequence.

Therefore, unlike other backups, only copying backups does not affect the overall backup and restoration process of the database.

You can create only copies for any type of backup

(1) only copy the full backup (all recovery modes)

To create a copy-only full backup or differential backup, use the copy only option in the backup database statement.

Data backup performed using the copy only option cannot be used as a baseline backup, and does not affect any existing differential backup. Unlike regular full backup or differential backup, the website space,

Only copying backups does not truncate transaction logs

(2) copy only differential backup

These backups are the same as normal differential backups.

Note: copy_only backup is recorded in the is_copy_only column of the Backup set table. Only backup copies can be created using the backup statement.

SSMS does not support copy only. That is, GUI backup does not support copy only.

Use the following SQL statement to view the database backup operations performed by SQLSERVER since the installation.

,,,,,.