DR for SQL server 2005 and 2008 Clustering, any suggestion?

Question

DR for SQL server 2005 and 2008 Clustering, any suggestion?

Viewing 5 posts - 1 through 6 (of 6 total)

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

456789psw SSCarpal Tunnel Points: 4728 More actions · Answer 1

Maybe I am miss understanding,

Clustering should not be your DR solution, It is designed to be for high availability. If your SAN goes down you have an Issue.

I have always set up Both clustering and log shipping going. Log shipping to of site location is my DR. This gives you both HA and DR.

As for question number 2, I am not to sure what you are asking?

Perry Whittle SSC Guru Points: 234065 More actions · Answer 2

jarupan (8/8/2010)
1) Anyone has white paper about set up SQLserevr2008/Windows2008 on Virtual server (or VMware), please let me know the link.

It's your lucky day!! Check the 2 links below for further details

Deploying a Windows 2003\SQL 2005 cluster using VMWare Server 2

Deploying a Windows 2008\SQL 2008 cluster using VMWare Server 2

456789psw (8/9/2010)
Maybe I am miss understanding,
Clustering should not be your DR solution, It is designed to be for high availability. If your SAN goes down you have an Issue.
I have always set up Both clustering and log shipping going. Log shipping to of site location is my DR. This gives you both HA and DR.
As for question number 2, I am not to sure what you are asking?

Geographically dispersed clusters allow DR but for SQL Server do have limitations

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

jarupan SSCommitted Points: 1746 More actions · Answer 3

Thanks for answering.

1) Yes, I agree it sound like High Availability, but I also need DR from this Clustering.

some answers in http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/5b261deb-521c-44ca-9495-814002623049

2) The question number 2 is close to question number 1, sorry I quite confuse at 2 am today that I wrote that question.

By the way, my VM is up so I can test all my issues.

Thanks again.

456789psw SSCarpal Tunnel Points: 4728 More actions · Answer 4

One more reason I failed to mention, If you set up Log shipping after you set up the DR you have a place to fail over to when you need to due patches or upgrades of any type on the Cluster..

for tips on the install go here as 2008 cluster has changed a bit... for the better

http://www.mssqltips.com/tip.asp?tip=1687

jarupan SSCommitted Points: 1746 More actions · Answer 5

Thank again, everyone for your help.

Have a great day.:-D