When Copy_Only is really needed

Question

When Copy_Only is really needed

forsqlserver

SSCoach

Points: 18902
More actions
May 2, 2011 at 4:37 am

#239391

The sql server database backup copy only is taken so that log chain is not break.
In logshipping and mirroring I have taken the backups and no copy only is needed.
Can anyone tell me the situations when Copy_Only is really needed.
Thanks

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 1

It is needed if you also use differential backup and you don't want to add the new full backup to the chain (in other words you don't want the next differential backup to start from the new full backup).

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

forsqlserver SSCoach Points: 18902 More actions · Answer 2

Thanks...

It means we cannot setup the Differential backup in logshipping or mirroring...??:-)

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

forsqlserver (5/2/2011)
Thanks...
It means we cannot setup the Differential backup in logshipping or mirroring...??:-)

No it doesn't.

http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-option/

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

forsqlserver SSCoach Points: 18902 More actions · Answer 4

Thanks...

I have read the article.It was nice.

I am always in fear If I will set the full,Diff and Tran backup chain then will it disturb the logshipping/Mirroring.

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Separate log backups most certainly will affect log shipping. If you're log shipping you cannot be taking log backups any other way. Full and diff backups won't break log shipping (neither one ever breaks the log chain)

None of them break mirroring.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

forsqlserver SSCoach Points: 18902 More actions · Answer 6

When copy_only was not launched what dba's uses...

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

Don't understand your question.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

forsqlserver SSCoach Points: 18902 More actions · Answer 8

I want to only know if I want the feature of Copy_Only without using Copy_only...

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

I still don't understand what you're getting at...

My previous statement was about backups WITHOUT copy_only. Neither full nor diff will break log shipping and no backup will break mirroring.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

sumit.agrawal SSCommitted Points: 1616 More actions · Answer 10

There was no way out to get the benefit of using "copyOnly" without having this feature.... in earlier versions...