Failover Strategy

Question

Post reply

Failover Strategy

Zeal-DBA

SSCarpal Tunnel

Points: 4332
More actions
July 10, 2010 at 1:31 am

#224688

hello experts,
i have 30 gb size of database, and have transactions around 50 to 100 mb per day, we have 400 gb free disk space only C drive configured, and have windows server 2008 standard edition, sql server 2008 standard edition, ram 8 gb.
i have asked to present a failover strategy, kindly suggest me which kind of strategy shud i sugest or which papers shud i submit
thanks

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

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

VastSQL SSC-Dedicated Points: 36122 More actions · Answer 1

Whats your requirement?

Automatic failover?

cost?

How much downtime acceptable?

Zeal-DBA SSCarpal Tunnel Points: 4332 More actions · Answer 2

my requirment is to implement a failover strategy, which can available data on planned or unplanned downtime

i need suggestion which i can suggest to my organization

VastSQL SSC-Dedicated Points: 36122 More actions · Answer 3

SQL Server provides you HADR like

log shipping

Replication

Mirroring

Clustering

Choosing among this depends primary on your requirement

log shipping & Replication wont give u automatic failover..

KoldCoffee SSCoach Points: 18971 More actions · Answer 4

Ratheesh. I have a similar question but I am studying for the MCTS exam. I hope I am not crossing etiquette by asking you to look at my question, here:

http://www.sqlservercentral.com/Forums/Topic953397-10-1.aspx

KoldCoffee SSCoach Points: 18971 More actions · Answer 5

Here's a white paper that may help you, sachinsoni84. It addresses determining a strategy from a high level. I am reading it myself. http://msdn.microsoft.com/en-us/library/ee523927(SQL.100).asp

KoldCoffee SSCoach Points: 18971 More actions · Answer 6

And I found this book on-line that does a side by side comparison of the high availability technologies pg 37. The book itself is on Failover Clustering:

http://books.google.com/books?id=llBzeSu_UmYC&pg=PA42&lpg=PA42&dq=when+is+failover+clustering+the+right+solution&source=bl&ots=tsIIF3W8v7&sig=Cjbcc9rCsR4Ur7zAlrR91U7nwh4&hl=en&ei=Bnw_TKGjGpT2swPXvOCBBw&sa=X&oi=book_result&ct=result&resnum=4&ved=0CCoQ6AEwAw#v=onepage&q=when%20is%20failover%20clustering%20the%20right%20solution&f=false

SQLServer-Training.com SSC Enthusiast Points: 160 More actions · Answer 7

Hi,

I just implemented HADR (Availability Groups) a new feature in SQL Server Denali CTP1, in my test virtual Setup.

I used the following Infrastructure To implement HADR / High Availability Group

1) Domain Controller for Authentication

2) Two Virtual Machines with Windows Server 2008 R2 with Failover Clustering installed on each Node.

3) Local Instance of SQL Server (Not Clustered Instance) installed on Virtual Machines with Windows Server 2008 R2 (which are mentioned in point 2)

More Details and Step by Step Guide with screen shots is posted here

http://sqlserver-training.com/how-to-implement-hadr-a-high-availability-and-disaster-recovery-solution-in-sql-server-step-by-step-guide-with-screenshots/-

Suggest me some good test scenarios to test this HADR (Availability Groups) solution now.

Thanks
DBATAG
Website : http://sqlserver-training.com
Email : dbatag@sqlServer-Training.com