Database Level Clustering in SQL 2008

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Database Level Clustering in SQL 2008

Database Level Clustering in SQL 2008

Rate Topic

Display Mode

Topic Options

Author

Message

raheelr 63130

Posted Sunday, October 28, 2012 10:11 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 4:33 PM
Points: 18, Visits: 53

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

Post #1378091

Superdoc

Posted Monday, October 29, 2012 12:19 AM

Grasshopper

Group: General Forum Members
Last Login: Today @ 8:31 PM
Points: 21, Visits: 557

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

Post #1378117

mahesh.dasoni

Posted Monday, October 29, 2012 1:24 AM

SSC Journeyman

Group: General Forum Members
Last Login: Saturday, May 04, 2013 1:55 AM
Points: 81, Visits: 858

Please Refer below link :

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

Post #1378136

Perry Whittle

Posted Monday, October 29, 2012 6:49 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:33 PM
Points: 5,201, Visits: 11,150

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" Wink

Post #1378227

raheelr 63130

Posted Monday, October 29, 2012 1:27 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 4:33 PM
Points: 18, Visits: 53

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

Post #1378438

Joie Andrew

Posted Tuesday, October 30, 2012 5:58 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 06, 2013 5:58 AM
Points: 535, Visits: 1,010

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"

Post #1378710

SQLSACT

Posted Wednesday, October 31, 2012 2:23 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:44 AM
Points: 1,185, Visits: 2,099

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/

Post #1379192

Perry Whittle

Posted Wednesday, October 31, 2012 2:40 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:33 PM
Points: 5,201, Visits: 11,150

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" Wink

Post #1379196

« Prev Topic | Next Topic »

Permissions