Thanks for your response .. Reason which I am posting the questions here is that .. its not because there are issues with performance or the cases that are specified...

Thanks for your response - for sure it's encouraging .

following are the details

Table schema as follows :

CREATE TABLE [dbo].[Target_Table](

[D_Src] [int] NULL, [D_Src_Descr] [varchar](5) NULL,

[Data_Key] [bigint] NOT NULL, [Col_ID] [int] NULL,

[YrMo]...

• This reply was modified 9 months, 3 weeks ago by  Balu R.

Thanks to everyone with the insight .. with details. We were able to shrink the log file - after we disabled the CDC as it was not allowing us to...

Thanks for your detailed analysis .

I have another follow up question - to shrink the log file - is it possible if it doesn't have any free space available ....