Tricky DR

Question

Post reply

Tricky DR

dba_pkashyap

Hall of Fame

Points: 3336
More actions
February 4, 2010 at 9:02 am

#137007

Hey All,
We already have application DR in place (same site), which is database mirroring.
Now we are going for site DR (different site)
My publisher will have multiple subscribers. (Application DR + Site DR)
What do you reckon as the best method?
Regards,
Pavan.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

SQLBOT SSCrazy Eights Points: 8014 More actions · Answer 1

Mirrored SAN and HA clustering across sites would be a hardware solution.

For builtin solutions with SQL Server I would tend to think that log shipping would be the simplest.

Replication is possible too, but it has it's own learning curves and idioms

Good luck

Craig Outcalt

Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 2

I'm confused. You say you have database mirroring, but also a publisher? Are you running replication as well and looking to get that in a DR situation?

It would help if you explain what you mean by each server and need for DR. Application DR isn't necessarily something involved with mirroring. The database failover is one thing. The application moving to reconnect to the mirror is separate.

dba_pkashyap Hall of Fame Points: 3336 More actions · Answer 3

I wrote publisher for making it a bit clear.

My situation currently is our app has 2 web servers and 2 db servers, the db servers are mirrored. (db1,db2)

Now, we will be adding a new db server in a different site.(db3)

I am bit confused how to copy the data from db2 to db3. (or db1 to db3, which will be a bad idea)

Pavan.

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 4

You cannot mirror two ways. Only from DB1 -> DB2. You could log ship to DB3, which would work. See this (http://bit.ly/bXsbz6)

Publisher doesn't make sense in database mirroring

SQLBOT SSCrazy Eights Points: 8014 More actions · Answer 5

Since your db2 is in standby it's going to be useless to you for anything.

You'll have to either use log shipping or replication to move that data to your secondary site.

You can't mirror a database twice that I know of or take a mirror of a mirror (becasue it's in standby)

I could be wrong about that last part.

Other than that, clustering and mirrored disk is what we use for site-wide DR.

Cheers!

Craig Outcalt

Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258

dba_pkashyap Hall of Fame Points: 3336 More actions · Answer 6

Thanks for the suggestions.

I was even thinking of log shipping / replication.

Regards,

Pavan.

dba_pkashyap Hall of Fame Points: 3336 More actions · Answer 7

Hi Steve,

I should say WOW after reading the document!!!

This is what I was thinking of, but was not sure whether it works or not.

I will surely try this option in test environment first.

Thanks Steve!

Regards,

Pavan.

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 8

You are welcome, but send Paul Randal (www.sqlskills.com) a note of thanks. He sent me the link.