would locks on database or tables causes transaction logs to grow? I realize that some of the clients have a time out connection to the database and at the same...

So if I have my theory right, things that will be written into a transaction log file would be write, delete and rollback transactions?

Is it possible in someway that since this database use to run replication but now is not, it is still trying to replace the transaction?

From what I understand, there is...

In the long term i would like Transaction Log to run as this is a production DB. So recovery would be crucial.

There is no special activity over the past few days. I have read about past topics that says reindexing will cause increase of Transaction Log. I have already stopped the...

Is there a tool that can read the logfile?

Thanks for the advice. I found the problem. C Drive filled up due to replication data directory in REPLDATA folder during bulk copying stage.

wsze

IS it normal for logout process to take up so much system resources?

Thanks guys for all your valuable advice. I have been looking through my DB and seems to be alot of tables that needs tuning in terms of index.

Question. If...

Is it usually adviced to place Clustered Index for Primary Key values?

I can not seem to find the DLL file on my cluster server but the closest I got to it was in C:\Program Files\Microsoft SQL Server\80\COM\Resources\1033 which is a RESPEL...

So how would be the right way to reinstall the second node to get it up?

Does it mean that I would always have to reinstall the entire 2 nodes...

I manage to find a work around it. What I did was I copied this file manually onto the secondary node in the \system32 directory and everything seems to work...

I would think the cluster is running. I have tried moving the resources around in the Cluster Administrator.

I have also tried shutting down one server and see the resource...