Thanks Jason. I will check with App Team. This is not a production environment , we are running few tests using the driver. I supsect it is an issue with...

Yes, it uses MSDTC for an IBM SQL JDBC driver. Is that creating the issue ?. How to solve it ?

I will try to create a custom script to run the index rebuild .

Here is my result set from the weekend.

Index reorganize -After the reorganization the T Log...

May be that is my problem. I have large table called transactions with 6 million records in it. So how can I run the maintenance plan differently...

I will report back on Monday. I made some changes to the plan and hopefully it solves my issue. Have a great weekend.

That is interesting , so Index Rebuild which drops the existing Index and Recreates the index is not logged ? .If I do a Index rebuild my Log file...

Hi ,

Here is the output when the wait is happening

sql I ran

------

select session_id,request_id ,start_time ,status,command ,user_id ,connection_id,wait_time

wait_type ,last_wait_type ,wait_resource

from sys.dm_exec_requests

---

Output

-------

15302009-09-04 09:33:41.130suspendedSELECT5353F9ACB-4151-46C7-B1B2-03F4985ACFC8764796LCK_M_SKEY: 9:72057594308001792 (ac0069ecc4d8)

---

Another SQL for...

It is not within an Open transaction .

The result set is usually 150 records out off 1500.

No one have seen this kind of issue before ?. Intresting...

I think I know what the Problem is . It is the TokenAndPermUserStore cache store growth problem. There is a fix from Microsoft but it says it is being...

That is not true. Microsoft Provides the Interface for the Hardware vendors to use the VSS Writer to do disk level Snapshot backups. This comes handy for a Hardware...

Hi all,

It is strange , No one knows anything about Volume Shadow Copy backups ?

Regards

YeePee

Hi There,  

 The linked server was configured correctly.I found ou thte problem and  solved it . The Problem was that my SQL 2000...

Thank you all. I thought there was a easier way of deploying same Job on multiple servers ,eventually I created one on each server.

...

Hi,

Since the Job Description and Step Name can be edited, the programmer who created this named it according to his discretion.

It no longer contain the original name ....