Hi Friend,

Thanks for posting this article it's very useful for my self and you should keep on posting the BI related articles.

Thanks and regards,

Mahalingam M

Easy question. Thanks

Q1: Say for 2 nodes cluster, Do we need to have 2 copies of Databases( 1 on each node).

Ans: Because in a clustering environment normally sql database hosted only SAN(single...

Hi Friends,

Sql server 2008 two node clustering we remove the cluster using sql server 2008 management studion itself no need to go for control panal.

Thanks,

M.Mahalingamoorthy

DBA

EY GSS India.

hi sir/madam,

you can change the database set option:

Like this:

alter database "databasename" set page_verify

USE [master]

GO

ALTER DATABASE "database Name" SET PAGE_VERIFY CHECKSUM WITH NO_WAIT

GO

first change the database option

then add the database...

Hi,Andrew

This is Mahalingam,

i am also the same stage. if your are enable the mirroring on the particular database , u cannot truncate the log.Because which is mapped with full...