You have just created a database with 500 MB data file. How big will the transaction log be by default?

You have just created a database with 500 MB data file. How big will the transaction log be by default?

You have just created a database with 500 MB data file. How big will the transaction log be by default?


Answer – 125 MB

(The default transaction log size is 25 percent of the data file size.)