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 123»»»

Mirrored Backups Expand / Collapse
Author
Message
Posted Monday, May 7, 2007 6:15 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Tuesday, August 12, 2014 10:53 AM
Points: 6,783, Visits: 1,876
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/awarren/2990.asp

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #363861
Posted Tuesday, June 12, 2007 5:34 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 2, 2013 12:15 PM
Points: 1,443, Visits: 711

Andy,

Great article!  I especially like the fact you pointed out what happens when the backup fails on part of the mirror, and I'd echo your sentiments... be good if there was a switch to continue the process.

I currently use a disk to disk to DVD solution at my client's location, it works for them, but the amount data isn't too terribly large.

Mark

Post #373028
Posted Tuesday, June 12, 2007 6:42 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Tuesday, August 12, 2014 10:53 AM
Points: 6,783, Visits: 1,876
Backing up to DVD means you can sleep well! Not often you can do that (back up to DVD that is) and good to use the option if it fits.

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #373056
Posted Tuesday, June 12, 2007 6:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 26, 2014 3:32 AM
Points: 122, Visits: 105

Good article, great feature with a fatal flaw!

We've been using DeltaCopy http://www.aboutmyip.com/AboutMyXApp/DeltaCopy.jsp to mirror backups.  It's particularly good for WAN backups if not much has changed as it uses very little bandwidth.  It can be easily scheduled and will send email reports.

Malcolm

Post #373068
Posted Tuesday, June 12, 2007 6:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 1:24 PM
Points: 17, Visits: 297

Thanks for the great article!   Another item I would like to see is doing the mirror for both disk and tape not disk/disk and tape/tape.

 

JG

Post #373071
Posted Tuesday, June 12, 2007 7:10 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 29, 2007 7:01 PM
Points: 15, Visits: 1
Great article. Unfortunately mirrored backups aren't available in the Standard Edition, which is what my client is using.


Post #373076
Posted Tuesday, June 12, 2007 7:12 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Tuesday, August 12, 2014 10:53 AM
Points: 6,783, Visits: 1,876
The backup util is interesting, havent looked into that area much, might have to give it a try!

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #373078
Posted Tuesday, June 12, 2007 7:16 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Tuesday, August 12, 2014 10:53 AM
Points: 6,783, Visits: 1,876
I didnt catch the standard edition limitation, did my testing on Dev edition which of course has the Enterprise features. Dont think I'd upgrade to get this particular feature. I know they need to save a few features to make the extra dollars worth spending, but often it seems like they are forcing you to upgrade for convenience rather than super features.

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #373081
Posted Tuesday, June 12, 2007 8:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, August 12, 2009 10:14 AM
Points: 18, Visits: 167

Nice bit of knowledge. My issue would be that there are other factors that could affect the performance of the backup - especially network latency.  We should keep this in mind when using database backup mirroring.  Also, the database size was relatively small in the sample shown.  I'd like to see performance of a larger database backup, and to see what the network latency would then be for other applications going over the same LAN during tha mirrored backup process.

Post #373116
Posted Tuesday, June 12, 2007 8:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 11, 2013 9:44 AM
Points: 164, Visits: 72

Great article.  It's nice to see some basic new features every once in a while.

Unfortunately, I presume that the fault of an all or nothing backup will make this too risky for most shops to use.  In ours, if it's not on tape and off-site, it's not a successful backup.  Even if I have the local copy. 

I've stuck with the traditional copy/ftp method, but use SQL Backup from Red Gate to accomplish it.  They have gone ahead and incorporated the CopyTo command inline with the backup command, making it very easy to set up a job to backup to several locations consecutively. 

I just checked their new version 5 help file, and apparently they have also included a MirrorFile option that allows up to 32 mirror locations.  However, according to the documentation, they will continue with the backup even if only one of the locations specified works. 

Add compression, encryption, and faster backup and restore speed, and the native Backup for SQL Server just doesn't have a chance to be used by me.

You can go here to review the help file online, if curious: (No, I don't have stock in them.  For some reason, I get accused of that a lot.  Besides, I'm sure the new site owners won't mind.)

http://help.red-gate.com/help/SQLBackup5/0/en/SQLBackup.htm

Keep up the good work, and I hopefully I'll see you in your classroom sometime soon.

Dan

Post #373118
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse