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

Creating Mirrored Backups - SQL School Video Expand / Collapse
Author
Message
Posted Tuesday, November 25, 2008 7:16 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
Comments posted to this topic are about the item Creating Mirrored Backups - SQL School Video

Brian Knight
Free SQL Server Training Webinars
Post #608787
Posted Tuesday, December 2, 2008 2:03 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 3:19 AM
Points: 5,375, Visits: 1,391
Great ...


Post #611879
Posted Tuesday, December 2, 2008 9:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 1, 2010 4:55 AM
Points: 2, Visits: 13
Remarkably, Brian forgets to mention that this feature is available only in the Enterprise Edition SKU. I have to wonder why it's only available in EE; does it make sense that user have to pay for a substantially more expensive license to keep their data safe?

Why does the feature fail to write all backups if only one of the destinations fails? Doesn't that make the feature far less useful? Are there strategies for creating robust backups with SQL Server? That is, how does Brian recommend working around the limitation he identifies?
Post #612144
Posted Tuesday, December 2, 2008 9:42 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 7:46 AM
Points: 6,784, Visits: 1,898
Mike, our goal with the video was just to show you "how" to do it quickly, I'm sorry if we didn't quite hit the mark for you. I agree it shouldn't be an enterprise feature, and as for a work around, we've got a video coming up that shows how to supplement the standard/normal backup with a job that copies the baks to another drive/machine.

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #612169
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse