My question is what is mean by that negative value ???

Thanks ,

so how to recover a database from suspect mode?

what are the steps we have to take care ??

Hi ,

This queries it will help full to recover database from suspect mode .

use master

go

exec sp_resetstatus 'Databasename'

go

alter database Databasename set emergency

go

dbcc checkdb('Databasename')

alter database Databasename...

Thanks Gila,

My database in simple recivery model . i chnaged auto grow to 10 MB .

I have one more issue with the tempdb .

Tempdb--> tasks --> shrink-->files...

HI ,

I think by using the below query you can find out which SP is taking more cpu time :::

SELECT TOP 20 qt.text AS 'SP Name', qs.total_worker_time AS...

Hi ,

I need some inputs from which SQL version are you using ?

SQL server 2005 standard edition won't support online indexing .

Hi ,

Thanks for your inputs .

What are the steps i have to take care for resolving the these type of issue ..

HI ,

How to find calling SP ???

Hi ,

Select * from sysproecessesm where blocked <>0 , you can find blocking SPID 's

Dbcc inputbuffer(spid) -- you can find the Current running Query .

First try to find out...

HI ,

Go to server -->CMD-->perfmon -->ADD -->Physical Disk [performance object]--> AVG disk Queue lenth[counter].

Thanks,

Lavanya Sri

Hi ,

Can u provide more details . The log file saying all of u r services are failed to install .

On which operating system you installed sql server ??

HI ninja,

Which one i have to change the server name is the present production server ??

HI Jeff ,

I checked with my windows admin , my two servers are running in work group .

Now its not possible to change the my SQl server name why...

hi ,

How to check the two servers in the same domain or different domain ??

Thanks a lot to jeff and ninja ......