SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Mirrored Backups


Mirrored Backups

Author
Message
Andy Warren
Andy Warren
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: Moderators
Points: 11463 Visits: 2730
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
SuperDBA-207096
SuperDBA-207096
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1927 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


Andy Warren
Andy Warren
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: Moderators
Points: 11463 Visits: 2730
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
Malcolm Matthews
Malcolm Matthews
SSC-Enthusiastic
SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)SSC-Enthusiastic (124 reputation)

Group: General Forum Members
Points: 124 Visits: 122

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


JG-219322
JG-219322
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 320

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


John Pertell
John Pertell
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 1
Great article. Unfortunately mirrored backups aren't available in the Standard Edition, which is what my client is using.



Andy Warren
Andy Warren
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: Moderators
Points: 11463 Visits: 2730
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
Andy Warren
Andy Warren
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: Moderators
Points: 11463 Visits: 2730
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
Jason1972
Jason1972
SSC Rookie
SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)SSC Rookie (34 reputation)

Group: General Forum Members
Points: 34 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.


Daniel Wolford
Daniel Wolford
SSC-Enthusiastic
SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)

Group: General Forum Members
Points: 168 Visits: 75

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


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search