Post reply

Database Level Clustering in SQL 2008

  • October 28, 2012 at 10:11 pm

    #269120

    Hi Techs, is it possible to have DB level clustering in sql 2008? if so how can we achieve this?

    I know DB levek mirroring does work.

    Regards

    Raheel

  • October 29, 2012 at 12:19 am

    #1553611

    Hi,

    I don't think there is a concept of database level clustering in sql server, clustering has always been on windows as parent and it has to be instance level clustering. Correct me if i'm wrong

  • October 29, 2012 at 1:24 am

    #1553628

    Please Refer below link :

    http://www.sql-server-performance.com/2007/clustering-basics-2005/

  • October 29, 2012 at 6:49 am

    #1553705

    raheelr 63130 (10/28/2012)

    Hi Techs, is it possible to have DB level clustering in sql 2008? if so how can we achieve this?

    I know DB levek mirroring does work.

    Regards

    Raheel

    Database mirroring offers you redundancy at the database level, fail over clustering performs at the instance level

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

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

  • October 29, 2012 at 1:27 pm

    #1553886

    I think sql 2012 provides redundancy at DB level as well?

  • October 30, 2012 at 5:58 am

    #1554107

    Yes, SQL Server 2012 supports DB mirroring as well as a new feature called AlwaysOn, which is like advanced DB mirroring that can mirror groups of databases to multiple secondaries.

    Joie Andrew
    "Since 1982"

  • October 31, 2012 at 2:23 am

    #1554505

    raheelr 63130 (10/29/2012)

    I think sql 2012 provides redundancy at DB level as well?

    Have a look at these

    http://www.sqlservercentral.com/articles/AlwaysOn/91408/

    http://www.sqlservercentral.com/articles/FCI/92196/

  • October 31, 2012 at 2:40 am

    #1554507

    raheelr 63130 (10/29/2012)

    I think sql 2012 provides redundancy at DB level as well?

    SQL Server 2012 also supports database mirroring although this feature is now deprecated and marked for removal in a future version\service pack.

    Always On groups are the new HA feature in SQL Server 2012 and combine the clustering and mirroring technologies to create an extremely highly available SQL Server system.

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

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

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

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