It's working now..

After restarting/rebooting server, it get flush out & not showing.

Thanks a lot Jeff.

Regards

Majid

Hi Jeff,

I have already killed that process, but still it shows entry in sp_who2 active

as

128

RUNNABLE--walkers-- SOFT41--PRINT_2008--KILLED/ROLLBACK

And also when I check it's status in Kill .It shows as...

I think transaction is getting blocked..

But why this is..

How do I resolve this..

Actually a huge amount of data is updating on my database.

At same time user access the data.

Is it causes the performance issue because my ldf & mdf is on same...

Ok

Thank you sir.

Regards

Majid

Thanks a lot sir,

And be guided every time..

I have taken full database & tranx log backup.

But using truncate it will just remove out inactive transaction logs.

I have to reduce physical size captured by .ldf file.

Ok Sir sorry for posting data in other forum.

My database is 2 years old.

But still no one has taken any type of backup of that database.

So its size became huge.

Now...

Yes sir,

I m not using SQL server 2005.

And about transaction log backup, No not huge transaction is going on it.

So i think it's not necessary to take frequent tranx backup.

Current...

Query u have given is not working...

and backup of transaction log is going on twice in a day..

anything else u want.

Yes My database is in full recovery mode.

Transaction log backup is going on.

Yes I want to recover it from the point of failure..

What is default setting for this.

I mean is it 'ANSI NULL OFF' or 'ON'

I didnt get meaning of 'with proper setting'.

Can u explain in brief.

I have to create table wich allow NULL search.

Total fields(colom) in a table is 1024 & nearly 1010 fields...

In SQL server Agent Error log showing message

[LOG] SetServiceStatus failed (reason: The handle is invalid)

Is this happening due to above error.

Showing error message--

The job failed. The Job was invoked by Schedule 3 (DataTransfer). The last step to run was step 1 (DataTransfer).