Thanks Alan ,

This Database used to be in simple recovery model and I did change it to Full now. I am taking T-log backup and full backup . here is top table and Index size from your query. whet he is saying is that data space as well as index space grew by 500% when the actual record count grew by 15% .

TableSizeInMB IndexSizeInMB

682.000 741.875

277.000737.117

252.000275.758

252.000275.594

229.000250.539

223.000243.781

220.000240.680

82.000892.813

82.000892.344

75.000811.781

73.000789.617

72.000779.625

65.000730.953

65.000726.852

63.000705.180

61.000687.898

61.000683.188

63.000464.469

62.000455.758

48.000549.047

48.000548.930

48.000548.797

48.000548.656

48.000548.297

55.000407.883

55.000407.195

54.000399.820

62.000316.625

78.000172.438

32.00033.258

25.00015.547