Hi

Try DBCC checkdb

And be sure Is manual backup is passible on database?

And Is the backup Plan was Ok earlier?

Hi

Smith

Ok I got it , Thanks

Hi

Shuresh

Actualy I never worked in critix inv. so wait for experts comments.

Hi Suresh

look the following

State Description

2 User ID is not valid.

5 User ID is not valid.

6 An attempt was made to use a Windows login...

Hi Smith

Please let us know what you done for the solution.

Please ...

Thanks

Hi

Ratheesh.K.Nair

May we use both TCP\IP and NAMED PIPES at the same time? if Yes...

Kingston Dhasian (9/19/2010)

---

Ali Tailor (9/17/2010)

---

Hi

Joe

If U find the things in Ur Pocket, why ask to another? First check Ur pocket (SQL BOL) please, the forum's expert not free for answer...

Hi

I am not sure but, Every Sql Server need maintenance in my opinion. It may wrong,

wait for experts comment.

Hi

It may work for you

Hi sjiv

Is your OS configured for clustering?

Refer the Dave's provided link, that may useful for you.

Hi Experts

Thanks Gail and all others.

hi

Puru

May we know the tables name and design? and some dummy records for exact solution

:w00t:

Craig Farrell (9/18/2010)

---

Hey Ali,

I'm not sure why you would want to. If you were writing articles and getting them published, sure, I could see that being something for a...

purushotham216 (9/18/2010)

---

hi to all .thanks in advance

I want to get matched recods(if name in both locations ) from table

Table is like this

Name Location

a ...

Hi

nzrdb6

This link may use full for you, Please try it

http://www.sql-server-performance.com/articles/per/performance_audit_part4_p1.aspx