Understanding the Copy_Only option in Backups for SQL Server

The Copy_Only option is very useful in full backup scenario when you don’t want to break up the sequence of log sequence number in conventional SQL Server backups.

For example, when you have a schedule of daily full backups and differential backup of every six hours daily. Then you need to run a weekly full backup using the copy_only option so as not to break the LSN between your daily full backups and differential backups.

To use this copy_only option you may run below statement

BACKUP DATABASE <databasename> TO <disk> …  WITH COPY_ONLY …..

When using doing this via the SSMS, in the backup database dialog box, select the Copy Only Backup option. This option however is only available from SQL Server 2005 and later.



About these ads

4 responses to “Understanding the Copy_Only option in Backups for SQL Server

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Traveller Observer

The SQL Pro

(Ayman El-Ghazali - www.thesqlpro.com)

Meels on Wheels

Meels for breakfast, lunch and dinner.


Just another WordPress.com site

Paul Turley's SQL Server BI Blog

from the world of Microsoft SQL Server BI and reporting


Explaining the bits and bytes of SQL Server and Azure

Coding Tips

We will improve your knowledge

SQL Studies

 Live, Learn, Share

Hemlock Time

Be an Author, Publisher, and Entrepreneur

Sql And Me

My Experiments with SQLServer

Dimitrios Kalemis

I am exactly like Jesus Christ: an atheist and anarchist against society and bad people with influence and power (judges, social workers, politicians, priests, and teachers).

Clint Huijbers' Blog

Senior Certified Microsoft BI Consultant

Blog of Many Useless Wonders

Where Uselessness Abounds!

Stevespevack's Blog

IT Recruitment

SQL Problems and Solutions

Sharing the knowledge & experience of SQL, DBA & BI

Glenn Berry's SQL Server Performance

Semi-random musings about SQL Server performance

Algonquin Studios Blog

Ideas and opinions on software development, web design, customer service, sales and marketing...and food

SutoCom Solutions

Success & Satisfaction with the Cloud


Get every new post delivered to your Inbox.

Join 48 other followers

%d bloggers like this: