Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Backups » what is Copy-Only Backup?
Add to briefcase
13 posts, Page 1 of 2
12»»

what is Copy-Only Backup? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
y.koteswarrao-652921
Posted Thursday, August 05, 2010 11:09 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 14, 2010 6:06 AM
Points: 76, Visits: 199
Hi,

What is Copy-Only backup and how does it works?

thanks
Koteswarrao
Post #964523
GilaMonster
Posted Thursday, August 05, 2010 11:28 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:21 AM
Points: 37,686, Visits: 29,943
Have you looked in Books Online? I'm pretty sure the answer is in there.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #964538
Perry Whittle
Posted Sunday, August 08, 2010 12:02 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 5,201, Visits: 11,153
Hi

copy_only is a new feature, it is basically a backup that does not interfere with the current backup chain. As Gail said, BOL does document this feature

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #965677
Robert Davis
Posted Sunday, August 08, 2010 11:34 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 1,558, Visits: 1,396
It's not new though.


My blog: SQL Soldier
Twitter: @SQLSoldier
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring
Post #965728
Perry Whittle
Posted Monday, August 09, 2010 8:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 5,201, Visits: 11,153
let me re phrase that.

New in SQL Server 2005!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #965998
TheSQLGuru
Posted Tuesday, August 10, 2010 7:00 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 9:58 AM
Points: 3,574, Visits: 5,113
Perry Whittle (8/9/2010)
let me re phrase that.

New in SQL Server 2005!


I still refer to numerous 2005 features as "new". When you have been using the product since 6.5 first came out . . .

In any case, BOL is a WONDERFUL resource. I do SQL Server Relational Engine work every day and have for over a dozen years, and BOL is ALWAYS open on my desktop!!!

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #966650
jasonlorraine1999
Posted Tuesday, August 10, 2010 7:05 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 3:44 AM
Points: 12, Visits: 932
No normal master database entries are added to aid recovery but when I run

backup database thedatabase to disk='c:\thedatabase.bak' with copy_only

I still get a up to date last backup date in database properties in SQL Server Management Studio.

Useful but could be confusing...

J
Post #966654
Perry Whittle
Posted Tuesday, August 10, 2010 9:49 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 5,201, Visits: 11,153
TheSQLGuru (8/10/2010)
I still refer to numerous 2005 features as "new". When you have been using the product since 6.5 first came out . . .

In any case, BOL is a WONDERFUL resource. I do SQL Server Relational Engine work every day and have for over a dozen years, and BOL is ALWAYS open on my desktop!!!


Hi Kevin

the only reason i referred to the option as new was because the OP has posted in the SQL Server 2005 forum and at this version it was a new option!

Regards

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #966812
pankushmehta
Posted Tuesday, August 10, 2010 5:18 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, May 29, 2011 9:01 AM
Points: 211, Visits: 4,106
hi Jason,

it will be in the backupset table.

however, the is_copy_only field will be 1, which confirms it is a copy_only backup.
Post #967071
eng_mgomaa
Posted Wednesday, August 11, 2010 9:41 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 22, 2012 11:02 PM
Points: 33, Visits: 156
Copy-only backups are new to SQL Server 2005. They allow a backup of any type to be
taken without affecting any other backups. Normally, a database backup is recorded in the
database itself and is identified as part of a chain that can be used for restore. For
example, if a full database backup is taken, any subsequent differential database backups
use this full database backup as their base. A restore process utilizing the differential database
backups would have a reference to the full database backup, and that backup would
have to be available.
Copy-only backups do not affect the restore chain. They are useful in situations in which
you simply want to get a copy of the database for testing purposes or things of this
nature. Copy-only backups are not supported via SQL Server Management Studio (SSMS)
and must be performed via the Transact-SQL (T-SQL) BACKUP command.
Post #967921
« Prev Topic | Next Topic »

Add to briefcase
13 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.