• This database has been running without jobs for years. And before you ask ... no, I was not the DBA before ... 🙂

    -I am using smart ReIndex (Ola Hallengren solution)

    -The ReIndex will run for 1st time

    I'm just trying to do some simple math in order to ensure the job won't fail or fill up the drive, as I won't be checking the job realtime.

    Thought about this...

    Table A x 1.2 = min drive space for Tlog

    Where Table A is the size of the biggest table in the database. So if that table is 20GB, to say something... 24GB at least?