What is SQL Server bloating?
A database that has a data file of a couple 100MB and the associated log file is 500MB in size!
It Occurs when transaction log backups doesn't scheduled properly and this growth of log file Called Bloating.
To solve this provblem Change Database Mode to Full or Bulked Recovery Mode.
SQL Server Interview Questions · · · ·