yes pavan

Both giving same error ...

Regards,

Sushant

it says "Windows cant find sqlwb, make sure you typed it correctly and try again"

I think i have to run setup.exe again and then install client components.

Let me try that.

Regards,

Sushant

@ pradeep

by other services , I mean reporting service, anaysis service , tutorials etc

When i log into remote server where sql server is installed.

I can see only configuration tools...

@ pradeep

SSMS is not there on the server where sql server is installed.

I am trying to log into SSMS on my local pc.

Regards,

Sushant

@ pradeep

I saw those alerts were shrinking databases and logs, I disabled them.

I will monitor again for the backup execution time.

Thanks Pradeep

Regards,

Sushant

What i noticed is that there was an application sqlagent alert engine , database msdb, whose wait time was very large, and I thought that was a hindrance to my...

thxs a lot

Regards,

Sushant

let me be more clear :-

If i have database1 and database2 .

I take a full backup of database1 and then restore it on database2,

then the database2 will have all the...

thanks all for your replies

Regards,

Sushant

@ any more clues

Regards,

Sushant

@ pradeep

Its bak

Regards,

Sushant

I tried running sp_updatestats in the night, but it failed with error:-

Executing the query "sp_updatestats;" failed with the following error: "Transaction (Process ID 57) was deadlocked on lock resources with...

@ sqlbuddy

There is no option like scan type.

I just have options to select table, view or both and in the update portion: column stats or index stats or all existing...

@ sqlbuddy

Thxs for ur reply

How can I run the update stats with reduced sampling rate ?

Where do i have to specify that(50% or 40%), if I am running it through...

@ saravan

It may be some application or job which runs at night 1 am is using the credentials for autentication.

It checks and cant get authenticated and so you get the...