Experiment in High Availability

Question

Experiment in High Availability

C.K.Shaiju

SSCarpal Tunnel

Points: 4228
More actions
September 20, 2013 at 4:52 am

#283436

Hi All,
Would like to get some hands-on with the high availability options (Log-shipping, Replication, Database-Mirroring and Server Clustering).
Can I do experiment on these in my personal computer?
_____________________________________________
One ounce of practice is more important than tonnes of dreams

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

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

Dhananjay-440114 Ten Centuries Points: 1365 More actions · Answer 1

Yes, Why not. Create 2-3 instances of SQL Server and get started... or the other way is install Virtual machine on uor box and get started.

C.K.Shaiju SSCarpal Tunnel Points: 4228 More actions · Answer 2

Yes, Why not. Create 2-3 instances of SQL Server and get started... or the other way is install Virtual machine on uor box and get started.

Thanks, have read that clustering and mirroring required new addition of hardware and software, also those are costly. As I am more into development did not get chance to install and do anything in hardware and software installation unless sql installed at home.

That's why the topic posted. BTW, Thanks.

If you had already come through any good links, Please share.

_____________________________________________
One ounce of practice is more important than tonnes of dreams

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

C.K.Shaiju (9/21/2013)

Thanks, have read that clustering and mirroring required new addition of hardware and software

Virtual machines. No additional hardware necessary.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

C.K.Shaiju SSCarpal Tunnel Points: 4228 More actions · Answer 4

Virtual machines. No additional hardware necessary.

Thanks Gail

_____________________________________________
One ounce of practice is more important than tonnes of dreams

Dhananjay-440114 Ten Centuries Points: 1365 More actions · Answer 5

Even for clustering you can do some hands on but you need to search on goole for available VM.. Without any investment..:-)

C.K.Shaiju SSCarpal Tunnel Points: 4228 More actions · Answer 6

Dhananjay-440114 (9/24/2013)
Even for clustering you can do some hands on but you need to search on goole for available VM.. Without any investment..:-)

Thanks Dhananjay. Let me search. 🙂

_____________________________________________
One ounce of practice is more important than tonnes of dreams

dan-572483 SSCoach Points: 15870 More actions · Answer 7

I have gotten mirroring to work between a SQL instance on a Server 2008 VM and a SQL Evaluation instance on the Host Windows 7 machine with 4GB installed, but performance was frustrating at times, especialy if IE was open. If you have more than 4GB or a second machine you can install SQL on, you'll be in better shape.

For a failover cluster, you'll need at least 3 VMs, a domain controller and 2 nodes, and a tutorial on how to set up shared drives in this kind of envronment (if anyone has a favorite link for this, please post it as I'd like to do this). For 3 VMs you'll want a PC with at least 8GB of RAM , or a second PC (you can put the DC there).

Another option might be to use Wondows 2003 SP2 VMs, which can probably run satisfactorly on less RAM.

C.K.Shaiju SSCarpal Tunnel Points: 4228 More actions · Answer 8

dan-572483 (10/2/2013)
I have gotten mirroring to work between a SQL instance on a Server 2008 VM and a SQL Evaluation instance on the Host Windows 7 machine with 4GB installed, but performance was frustrating at times, especialy if IE was open. If you have more than 4GB or a second machine you can install SQL on, you'll be in better shape.
For a failover cluster, you'll need at least 3 VMs, a domain controller and 2 nodes, and a tutorial on how to set up shared drives in this kind of envronment (if anyone has a favorite link for this, please post it as I'd like to do this). For 3 VMs you'll want a PC with at least 8GB of RAM , or a second PC (you can put the DC there).
Another option might be to use Wondows 2003 SP2 VMs, which can probably run satisfactorly on less RAM.

Thanks for sharing.

I didn't get any white papers, but got a youtube link (http://www.youtube.com/watch?v=1ZCCOcWUuOg). This link is the 1st part of a series of 27 videos.

_____________________________________________
One ounce of practice is more important than tonnes of dreams