Thanks CR for the reply!!

It answers only a part of my question! I think, it works through partition functions. Anyways, nps. Thanks for the reply again!

Thanks for the reply!!

I agree that, "more new data added to the database will be written to the original data file because it has more free space than the second...

Thanks for the reply!!

But the data file that is on E: is growing, though I have restricted its growth on E: and have created a ndf on G: ...

Thanks for the reply brother!!

DBCC Loginfo() did return a value 2 in the status field in the last row.

So I guess, shrinking the TLog is possible only when the...

Thanks so much John! Let me see if it resolves my issue.