Krishna1 (11/13/2013)
Noticed that the initial size of the transaction log is Approximatly 7GB. Is this the reason why the trnasction backup file size is 7GB?
Setting appropriate initial size is good from performance perspective because it make the transactions slow whenver file needs the growth or expansion so we should always consider the initial size based on the data/transaction growth.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)