Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can mirroring be set up with a copy only backup? Expand / Collapse
Author
Message
Posted Thursday, June 20, 2013 2:37 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 8:30 AM
Points: 907, Visits: 1,898
I have to initialize mirroring on a large database.
Due to red tape/policies etc, if i take an offschedule full backup, i have to jump through hoops to get ensure it gets stored wtih the rest of the backups.

Becuase of this a copy only full backup woudl be preferable.

Can mirroring be initialized with a copy only backup? I would expirement but copying the database takes 2+ hours so i dont have the time available for a failed test.

Any help would be appreciated.

Thanks.
Post #1465516
Posted Thursday, June 20, 2013 3:04 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:43 PM
Points: 40,411, Visits: 36,861
You don't need an off-schedule backup. Use your latest normal, scheduled backup and all log backups since that full backup.


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 #1465528
Posted Thursday, June 20, 2013 3:08 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 8:30 AM
Points: 907, Visits: 1,898
the latest scheduled backup is 6 days old meaning there will be a LOT of log files to restore. Coupled with the further red tape to get access to the backups, it would be quicker to just take a new backup.

If i have to il log the ticket to get acces to the backups, but id rather avoid it.
Post #1465532
Posted Thursday, June 20, 2013 10:17 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:53 PM
Points: 6,630, Visits: 14,205
you could take a diff and use the 6 day old full with logs

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1465820
Posted Thursday, June 20, 2013 10:38 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, October 31, 2014 10:27 AM
Points: 708, Visits: 3,293

Can mirroring be initialized with a copy only backup?


From MSDN (http://msdn.microsoft.com/en-us/library/ms191495.aspx)

Restoring a copy-only full backup is the same as restoring any other full backup.

Basically you use it so that you don't break the backup chain so go for it!


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


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1465837
Posted Thursday, June 20, 2013 10:48 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:43 PM
Points: 40,411, Visits: 36,861
Abu Dina (6/20/2013)
Basically you use it so that you don't break the backup chain so go for it!


You mean 'don't reset the differential base', because that's all that a normal full backup does.



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 #1465846
Posted Thursday, June 20, 2013 11:33 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 8:30 AM
Points: 907, Visits: 1,898
Ok, I got it sorted, escalation to management made a lot of stuff easier!

Regarding the question "can you initialize mirroring with a copy only backup", there has been no answer in the post yet to say if this is possible. It would be good to know, for future use.

Thanks!


Edit: Didn't see the post above this one, thanks for the help folks.
Post #1465866
Posted Thursday, June 20, 2013 12:18 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, October 31, 2014 10:27 AM
Points: 708, Visits: 3,293
GilaMonster (6/20/2013)
Abu Dina (6/20/2013)
Basically you use it so that you don't break the backup chain so go for it!


You mean 'don't reset the differential base', because that's all that a normal full backup does.


Yes... Sorry I should have been clearer. (I blame Mr Fritchey ) https://www.simple-talk.com/sql/database-administration/7-preventable-backup-errors/


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


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1465889
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse