So Be concentrate on SQL performance Tuning. it will more help in future.....

Hi ,

Thanks for your information .

Guys,

if you have any other information, please share with us. its really helpful those who are implementing sql 2008 clustering.

reagrds

Subha.

first create the test setup & be practice on that , then only you know the exactly what happened!

at the time of replication setup u have to know so...

Hey Guy!

why u want to delete the data in subscriber? what is purpose?

if deleted you loose that data & inconsistency will be there in that data!

Hi,

Manually run the copy job on secondary server.

& after that restore the copied backup on to secondary server with recovery option...

Note: in log shipping minimal data loss will be there.

Regards

Subha......

thanks ,

i know that first one, iam also looking for second one?

ok, we will wait some one will help us!

HI everyone,

can u give the exact answer for this question!

Regards

Subha

Hi,

in clustering environment Heart beat signal is passing through VIA 'private ip', at the time of configuring clustering we set the 'timeout property' like 30 sec.

in clustering Ping the...

TempDB size is 10 GB.

I didn't get any resolution on my issue.

step(1)

-- if principal server fails

-- Connect to MIrror server.

-- Execute the below command , mirror database becomes online.

ALTER DATABASE Test

SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

Step(2) Start RCA & Resolve the problem in principal...

1) First you should explain them very clearly when database was crashed we required whatever you have the latest Backups Like Recent Full Backup, Recent Diff Backup & Tail/Tran Log...

ok,

what is the purpose of Missing indexes feature in sql server 2005?

i didn't understand the missing indexes concept properly.

is there any chance to missing indexes in a Database?

if Yes!

please...

Hi,

Iam asking why indexes are missing?

How?

Subha

I got it

Thank u Gail