May 14, 2014 at 1:33 pm
I'm a newbie to SQL server although I've been and IBM DB2 DBA for years. I've started reading about recovery and continuity for this environment and need more information on why you would choose log shipping, or mirroring or both? We have a small application < 20 gig of data and a home grown application.
Rules of thumb or pointing me to a good resource would be helpful. Does anyone have that?
May 14, 2014 at 3:38 pm
This web site [/url]does a nice job of summarizing the differences between the two. The big difference is that mirroring actually provides an automated stand by situation where the mirror can pick up. With log shipping you'd have to build that functionality yourself and have some mechanism to make the log shipping database into a regular database in an automated fashion. But, the advantage to log shipping is that you get a readable copy of the database (albeit with interruptions when you apply a log). Here's an overview from Microsoft's point of view.
To me, if I was going for an inexpensive DR scenario, I'd go for mirroring because you only have to pay for a single license (since the secondary isn't readable). But it really depends on your needs & goals and how much work you can put into the process.
Now, if you have money, you upgrade to SQL Server 2014 (or at least 2012) and you go with Availability Groups, kind of like mirroring on steroids. You get a lot of the automated functionality of mirroring plus readable secondaries that aren't kicking you out to run log restores over & over.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 14, 2014 at 3:39 pm
Oh, and welcome to SQL Server Central. We try to provide a nice, helpful place around here. If you ever get attitude from anyone, let me know.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply