Answered by:

Always on - Active/passive sql server 2012

Question

I am going to install SQL Server 2012 on windows server 2012. I want to create two different windows server 2012 and install sql server 2012 on both servers. I want one server to be primary(active) and other server to be secondary(passive). So that where
active server goes down, passive server becomes active.

I have gone through details about Always on functionality in SQL Server 2012. So can i do active/passive server with always on functionality?

If i can, so when primary server goes down, users can still write data to specific database on secondary server?

In your case, create a windows cluster between the two servers and install the one SQL Server 2012 instance on one node add that instance to secondary node then your instance will can act as Active\Passive as you requested.

If you talking about Always on, it is giving high availability to database level and maintain the secondary copies of primary on passive nodes.

That means, when your first node is goes down then only that grouped database fail over to passive node in Always on other info like jobs and system databases are will not available on passive node.

Thanks for the response. So when we do windows cluster, i have to provide shared storage and virtual IP address, so do i have to create one more server for virtual IP Address? Where should i save disk for shared storage so both active and passive can access
to it?