SQL Server Copy Only Backup:-
- A copy-only backup is a SQL Server backup that is independent of the sequence of conventional SQL Server backups
- Copy Only backup is a SQL Server backup that is independent backup and it does not break the chain of SQL Server database backup.
- A copy-only backup does not disturb the original backup workflow, but just create a copy of the original database independently.
- Copy only backup are used to perform a full (or) T-log backup without breaking the log (LSN) chain and without distributing regular backups schedules.
- However, we receive occasionally request for backups then we can use this SQL Server Copy Only Backup.
Using T-SQL
-
BACKUP DATABASE adventureWorks TO DISK = N'D:\Secondry_DB_Backup\adventureWorks_copyonly.bak' WITH COPY_ONLY
-
BACKUP LOG adventureWorks TO DISK = N'D:\Secondry_DB_Backup\adventureWorks_logcopy.trn' WITH COPY_ONLY
Using SQL Server Management Studio
