@ saravan

I went into sql server management studio-->security-->credentials

Then reenter your passwords..

check and see if it works.

Regards,

Sushant

@ mutthu

The disk is normal E drive

I am backing up locally .

Regards,

Sushant

@ mutthu

The auto update stats is enabled.

So, I will run the t sql sp_updatestats from hte maintennace tasks and see how it goes..

Also, I noticed the full daily backups of...

@ nakul

Do I have to run the script while the job status is exectuing?

Regards,

Sushant

@ vibhavesh

Dude, plz ask your question in a new post.

@geoff

My temdb mdf file is 1.9 GB and its stored on c drive having 48 GB free space..

Also,.

i...

I dont have any idea about clustered scenario but

I had the same problem a lot many times on my prod sql server.

We had changed the passwords of hte sql agent...

@ nakul

I am not running update stats with rebuild/reorganize.

Iam just running update stats every weekend or once in two weeks.

@ mutthu

I stop the job by going into jobs, right clicking...

@ mutthu

There is no blocking

In morning i stop the job, so whats use of killing spid ?

I run this through a maintenance plan-->

update statistics task--> tables and views--> update(all exisitng...

@ gail

Ya, you were correct but i want to say that

firstly i tried running the manually shrink only, but that didnt decrease much space...

So, that means that the combination of...

Thanks gail

My auto shrink is OFF.

After the backup log script , i had to manually shrink the log files thru SSMS(tasks-->shrink-->files), then the size got dereased

@ swayneBell,,,Now you are too...

@ gail

I did backup log with truncate_only.

If backup log doesnt change file size then why do people recommend to do it to decrease growing log file size.

Regards,

Sushant

@ gail

That 20 gb increase is just in 1 week,

Also, you told that Backup log DOES NOT change file size?

I did backup log on my database and it reduced 70...

I know that once we restart sql server, the tempdb starts from scratch but

I cant perform that as they are on my prod server.

Regards,

Sushant

@ gail

I think he trying to say, when log shipping is out of sync and we try to restore the transaction logs ,

it gives error that the LSN number.....is too...

@ chetan

Make sure that sql agent is running on the secondary server.

Also, check on the primary server...

Go to database log shiping configuration, click on the seconday server instances ...( three...